As consultants, we often see system databases existing on the C drive on SQL Servers. There are some issues with
We’ve had Full-Text index issues come up with surprising frequency lately, so I thought I’d share the fix with all of you lovely people who read this blog. For reference, the customer in this example asked us to look at this problem on a server that is not managed by us.
The latest edition of SQL Server comes with many enhancements, and updates to TempDB in SQL Server 2025 are one of our favourites.
We’ve recently come up across a fun little bug with log shipping in contained availability groups. A cursory Google search
Explore in-memory/memory-optimized tables in SQL Server and if you should use this feature in your production environment.
When testing code, it’s critical to have enough robust data. This often requires removing personally identifiable information. Find out how!
What are stubborn partitions in SQL Server and how do you delete them? This was an interesting issue I recently had
With the recent announcement by Microsoft that they’re removing Azure Data Studio alongside the release of the new 64-bit version
Microsoft recently announced SQL Server Management Studio (SSMS 21). Here’s a quick look at what’s included in this latest iteration.
This is part three of the blog series on following a structure when performance tuning. From the previous posts (part