[Video] Office Hours: Salem Witchcraft Edition
It’s spooky time again! I visited Salem, Massachusetts again this year, this time for a friend’s wedding. I ended up in the same spot next to the Charter Street Cemetery that I filmed at last year! I went through your top-voted questions fr …
MySQL Index Overviews: FULLTEXT B-Tree Indexes
If you’ve been following Simple Talk for a while, you know that we’re fans of databases and everything they involve. We’re also big fans of database performance, too. And if you’re a developer or a DBA, you surely know one of the primary answers to dat …
Using a Service Account in Microsoft Fabric
The post Using a Service Account in Microsoft Fabric appeared first on SQLServerCentral.
[Video] Office Hours: Open Q&A About Databases
I’m back in the home office to take your database questions from https://pollgab.com/room/brento. Here’s what we covered in this episode: 00:00 Start 03:15 Mattia Nocerino: I’ve always ignored database t-sql snapshots. What are good u …
What’s In Your Development Database? The Answer: Production Data.
Are your developers working with live production data, completely made-up synthetic data, or something in between? I posted a poll here on the blog and on a few of my social media feeds, and here were the results: Note that the numbers can add up to mo …
Troubleshoot Chained SQL Server CTE
The post Troubleshoot Chained SQL Server CTE appeared first on SQLServerCentral.
[Video] SQL Server Always On Availability Groups 101
I got a few closely related Availability Groups questions at https://pollgab.com/room/brento and decided to do a half-hour introduction to AGs: Here’s what we covered: 00:00 Start 00:24 Paul Hunter: My company decided to move to AZURE. The person …
How To Embed Your Azure Logic Apps in a Metadata-driven Data Platform
In this article, I am going to explain how you can dial your productivity up to 11 when you’re dealing with a lot of Azure Logic Apps in your data platform. Suppose you have a SharePoint List, and you need to extract that data and store it inside an Az …
Updated First Responder Kit and Consultant Toolkit for October 2024
The wording of all of sp_BlitzIndex’s warnings is now much more clear and inclusive thanks to hard work by W. Eli Hayes and VladDBA. When Kendra Little first wrote sp_BlitzIndex about a decade ago to help you analyze your index designs, we brains …
The GitHub Web Platform
Introduction to the GitHub Web Platform In a previous article, we explained how to sign up for the GitHub platform to protect our code and publicize our code on the web to work with multiple users simultaneously on the internet. With GitHub, you can co …
Data Lake Implementation – Data Lake Zones and Containers Planning
The post Data Lake Implementation – Data Lake Zones and Containers Planning appeared first on SQLServerCentral.
Writing an Efficient Query
SQL is easy to start writing. The basic syntax to start returning data is very simple. This low threshold for starting SQL hides some of the nuances that divide efficient queries from inefficient queries. As your SQL gets more complicated and you need …
Consistency and Concurrency in NewSQL Database Systems
Companies today require database systems that are reliable and capable of efficiently handling large volumes of data and numerous transactions. Traditional relational databases, once the foundation of data management, often struggle to meet these moder …
Uncover SQL Server Missing Indexes
The post Uncover SQL Server Missing Indexes appeared first on SQLServerCentral.
PASS Summit Livestream and on-demand
The post PASS Summit Livestream and on-demand appeared first on SQLServerCentral.