
Removing Stubborn Partitions in SQL Server
What are stubborn partitions in SQL Server and how do you delete them? This was an interesting issue I recently had
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
If you’ve followed along with the previous blog, you’ll now have a way to re-run and test your query as
So, you have a database or block of code. You’ve been told to “make it fast” but you’re not sure
SQL Server 2022 brought us Contained Availability Groups. This post outlines the new features and some of the pitfalls that we have seen.
In today’s tech-saturated world, we expect developers to have a broad range of skills and programming languages at their disposal,
We often see databases that are simply larger than they need to be. This is usually attributable to technical debt
Maybe a user has reported some data is unavailable, maybe you’ve received an error message on a report that shouldn’t