What steps are there to move to safe automated database deployments?
Database deployments are scary, you have all this data and if you drop the wrong table, run the wrong delete statement or have an error in a stored procedure...
2019-06-10
3 reads
Ed Elliott
How do you choose which columns to include in your SQL Server clustered index?
Database Engineering: Database Modelling: Do I need to have an incrementing identity int/bigint as my clustered index in a SQL Server database? When you want to produce a professional...
2019-06-03
9 reads
How do you choose which columns to include in your SQL Server clustered index?
Database Engineering: Database Modelling: Do I need to have an incrementing identity int/bigint as my clustered index in a SQL Server database? When you want to produce a professional...
2019-06-03
6 reads
Why is my pivot query not returning any data? How to debug a PIVOT query
If you have a PIVOT query and it isn’t returning the data you expect, what can you do to troubleshoot it? The thing to do is to break it...
2019-05-21
21 reads
Why is my pivot query not returning any data? How to debug a PIVOT query
If you have a PIVOT query and it isn't returning the data you expect, what can you do to troubleshoot it? The thing to do is to break it...
2019-05-21
6 reads
How to delete a lot of data from a SQL Server database
How to delete data efficiently When we delete data from a table in SQL Server, we can often find that the delete is slower than even the original insert,...
2019-05-15
336 reads
How to delete a lot of data from a SQL Server database
How to delete data efficiently When we delete data from a table in SQL Server, we can often find that the delete is slower than even the original insert,...
2019-05-15
4 reads
How to load test a SQL database
How do you know whether a database code change is going to be great, okay or awful? If you want to test a new version of SQL Server how...
2019-05-08
293 reads
How to load test a SQL database
How do you know whether a database code change is going to be great, okay or awful? If you want to test a new version of SQL Server how...
2019-05-08
8 reads
Should I pluralize table names, is it Person, Persons, People or People?
Reading Time: 5 minutes (just do it!)
There is a lot of confusion when it comes to designing tables in SQL Server around whether to pluralize names or not. How...
2019-05-02
17 reads
Blogs
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers