2023-04-12
480 reads
Database Administration
2023-04-05
602 reads
Find Invalid Objects in SQL Server
This article shows how you can find which objects in your database might not be valid after schema changes.
2023-03-13
22,565 reads
The Top SQL Server Engine Errors
The SQL Server Support team published the top errors they see in calls. Steve has a few comments on what they're doing to help customers.
2023-03-04
639 reads
The Struggles to Keep Up with Growing Systems
The growing complexity of environments can cause struggles for many IT professionals. However, we need to ensure we are not making things worse.
2023-03-03
168 reads
2023-02-20
491 reads
2022-10-05
582 reads
The Lock Escalation Threshold – Part 1
This article isn’t about the act of lock escalation itself, which is already well documented and generally well understood. Some myths (like row locks escalating to page locks) persist, but challenging those yet again probably wouldn’t change much.
2022-09-19
2022-09-02
562 reads
2022-08-26
483 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers