Azure SQL Offers Manual Failover for PaaS Resources
Sometime having the right command in place opens up new doors to test things, like a failover for example. In this post we will take a look at a...
2020-09-22
5 reads
John Morehouse | Sqlrus.com
Azure SQL Offers Manual Failover for PaaS Resources
Sometime having the right command in place opens up new doors to test things, like a failover for example. In this post we will take a look at a...
2020-09-22
4 reads
Understanding how to enable SQL Server Optimizer Hotfixes
There are a number of knobs and switches that are available to database administrators that can be used to enable better performance. There are three options in particular that...
2020-08-12 (first published: 2020-07-31)
1,607 reads
Understanding how to enable SQL Server Optimizer Hotfixes
There are a number of knobs and switches that are available to database administrators that can be used to enable better performance. There are three options in particular that...
2020-07-31
6 reads
Using LAST_QUERY_PLAN_STATS in SQL Server 2019
In my opinion, SQL Server 2019 is one of the greatest releases of the product that Microsoft has ever produced. The amount of improvements across the platform really allows...
2020-07-28 (first published: 2020-07-17)
1,079 reads
Using LAST_QUERY_PLAN_STATS in SQL Server 2019
In my opinion, SQL Server 2019 is one of the greatest releases of the product that Microsoft has ever produced. The amount of improvements across the platform really allows...
2020-07-17
27 reads
Using Docker Volumes for SQL Server in Linux
No, not that kind of volume! Over the past couple of blog posts, I have been talking about the versatility of deploying SQL Server with Docker. This combination is...
2020-07-13 (first published: 2020-07-03)
856 reads
Using Docker Volumes for SQL Server in Linux
No, not that kind of volume! Over the past couple of blog posts, I have been talking about the versatility of deploying SQL Server with Docker. This combination is...
2020-07-03
6 reads
Restoring a SQL Server Database in Docker
Last month I blogged about using Docker to run SQL Server as a quick and easy way to get SQL Server up and running. While it continues to be...
2020-07-01 (first published: 2020-06-19)
625 reads
Restoring a SQL Server Database in Docker
Last month I blogged about using Docker to run SQL Server as a quick and easy way to get SQL Server up and running. While it continues to be...
2020-06-19
9 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
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
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