What is the “cost” in Cost Threshold for Parallelism?
tl;dr; While at one point the cost of a query was an estimated time to run in seconds, today it’s...
2017-04-17
508 reads
Kenneth Fisher
No space queries
You know, sometimes you get a silly idea in your head and you just HAVE to try it out. The...
2017-04-13
383 reads
The more things change, the more they stay the same
Koen Verbeeck (b/t) is hosting T-SQL Tuesday this month and our topic is The times they are a-changing. In other...
2017-04-11
480 reads
Creating a list of random numbers
I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly...
2017-04-05 (first published: 2017-03-22)
2,265 reads
How do I change the increment of an identity column?
Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. No...
2017-04-05
486 reads
Compressed backup errors and TF 3042
Compressing your backups has very few downsides. It’s usually faster (the additional time for compression is less than the time...
2017-04-03 (first published: 2017-03-16)
1,619 reads
Hiding tables in SSMS Object Explorer
Extended Properties
Sometimes you find out the strangest things about SQL Server. I’ve written about extended properties before but had no...
2017-04-03
503 reads
Increasing and decreasing the performance level of your Azure SQL Database
One of the big benefits of Azure, and in fact any of the cloud offerings I’ve seen, is the ability...
2017-03-29
724 reads
Limits vs Goals
It’s that time again. Kennie Nybo Pontoppidan (b/t) is the host this month and has a fun topic for us....
2017-03-27 (first published: 2017-03-14)
1,128 reads
sp_SrvPermissions & sp_DBPermissions V6.0 Finally!
It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well,...
2017-03-27
505 reads
Blogs
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
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...
Forums
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Upgrading Admin Queries
Comments posted to this topic are about the item Upgrading Admin Queries
Question of the Day
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