Execution Plans, Performance Tuning and Rum
This is me on the last cruise
In just a few more weeks I’ll be setting sail on the first of...
2015-01-06
1,082 reads
This is me on the last cruise
In just a few more weeks I’ll be setting sail on the first of...
2015-01-06
1,082 reads
I love it that my first post of the new year is going to be Speaker of the Month. I’m...
2015-01-02
422 reads
If you get an execution plan that looks like this:
I wouldn’t blame you for immediately thinking about query tuning. Especially...
2014-12-29 (first published: 2014-12-19)
6,158 reads
For the month of November I was at the PASS Summit and Live360, so I didn’t get to find new...
2014-12-08
551 reads
I have been very remiss in my blogging of late. Apologies.
One thing I haven’t blogged about is Speaker of...
2014-12-05
505 reads
For the first time ever at the PASS Summit, a competition was held to select a speaker for the 2015...
2014-11-13
779 reads
I’m just back from the PASS Summit 2014. What a great event. But this year, it was a little different....
2014-11-11
692 reads
Since I’m starting on the board in January, I’ve stopped taking part in the bloggers table during keynotes. First time...
2014-11-06
621 reads
There are lots of people who talk about Application Lifecycle Management. But, the database is a major part of every...
2014-10-31 (first published: 2014-10-20)
6,978 reads
I love negative feedback. Well, not really. I love constructive feedback. I love the feedback that gives me things to...
2014-10-17 (first published: 2014-10-12)
6,595 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers