SQL Server Alerts
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until they don’t. By the time someone notices an application outage or a failed backup, you’re...
2025-11-03 (first published: 2025-10-15)
300 reads
Kevin3NF
- Interests: Cycling, family, sci-fi, DBA stuff
SQL Server Versions: Out With the Old, In With the Supported
If your production SQL Servers are still running 2016 (or older) you’re basically banking on inertia. Sure, it’s been stable. But that doesn’t guarantee it’ll stay safe or compliant....
2025-10-29
19 reads
SQL Server is Slow, part 3 of 4
In parts 1 and 2 of this series, we’ve gathered info and done the triage just like anyone in almost any industry does At this point you’ve: Defined what...
2025-10-27 (first published: 2025-10-01)
1,637 reads
SQL Server Migration Overview
It’s Not Just Backup / Restore At some point every company faces it: the SQL Server that’s been quietly running for years is due for retirement. Maybe the hardware...
2025-10-22
13 reads
SQL Server Is Slow (part 1 of 4)
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at you that SQL Server is slow? Stop. Don’t Open SSMS Yet. You’ve heard it...
2025-10-08 (first published: 2025-09-17)
378 reads
“SQL Server Is Slow” Part 4 of 4
Parts 1, 2 and 3 got you to the (SQL) engine room. Now we use community-trusted tools to find what’s going on, fix it safely, and hopefully keep it...
2025-10-07
177 reads
SQL Server Is Slow – Part 2 of 4(?)
The 10-Minute Outside-In Triage Don’t Blame SQL First It’s 9:05 AM and your helpdesk lights up: “The SQL Server is down. Nothing works.” By 9:07, everyone is staring at...
2025-09-24
20 reads
SQL Server Failover Cluster Instances
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve heard of Failover Cluster Instances (FCIs). They’ve been part of SQL’s high availability toolbox since...
2025-09-19 (first published: 2025-09-03)
202 reads
SQL Server Log Shipping: The Tried and True of DR
It’s not glamorous, but it works In a world where shiny new HA/DR features get all the press, there’s one SQL Server technology that just keeps doing its job....
2025-09-15 (first published: 2025-08-27)
207 reads
SQL Server Availability Groups
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups (AGs), they changed the HA/DR game. Unlike Failover Cluster Instances (FCIs), which protect the whole...
2025-09-10
18 reads
Blogs
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Forums
The Cosmetics Testing Laboratory is called FARE LABS Pvt. Ltd.
Because we are NABL Accredited Laboratories, our personal care and cosmetics research center provides...
fast farward curson vs while loop on @table
hi, need to known weather fast farwand cursor is faster than a while loop...
Economics of AI: What is the Real Cost to Profit?
Comments posted to this topic are about the item Economics of AI: What is...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers