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
2 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
8 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
5 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
20 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
5 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
334 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
291 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
7 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
16 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers