GDPR in the USA
GDPR enforcement began in May of 2018, but if you are doing business in the US, you may not think it applies to you. Grant Fritchey explains why you might be wrong about that and why you need to act now.
Scripting Custom SQL Server Clones for Database Development and Testing
Phil Factor shows how to automatically apply T-SQL modification scripts during image and clone creation. Using this technique you can, for example, apply data masking to all clones, or customize an individual clone to work on a special variant or branch version, or set up instance level objects like Agent jobs or linked servers.
Building a Database Engine
Someone tried to build a database engine from scratch. While not something Steve wants to do, it's an interesting exercise.
4 Top Tips for starting your database DevOps journey
Want to get database DevOps implemented where you work but unsure where to start or how? We’ve written a handy blog to help you begin your database DevOps journey....
In Azure SQL DB, what does “The connection is broken and recovery is not possible” mean?
All it really means is, “Click Execute again, and you will be fine.”
Cloud Native
Building software for the cloud often requires some changes. This week Steve wonders how many of you are making the effort.
Sorting Months By Number (SQL Spackle)
Fill in another bit of your T-SQL knowledge by learning how to sort a result set by the proper month order, but use the month name instead.
Avoid running out of Disk Space ever again using SQL Monitor
SQL Monitor not only collects all the disk and database growth tracking data you need, automatically, but also analyses trends in this data to predict accurately when either a disk volume will run out of free space, or a database file will need to grow.
Manage SQL Server Agent History More Effectively
In this tip we look at how to build a custom approach to managing SQL Server Agent history data.
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Detecting Deadlocks Quickly
Comments posted to this topic are about the item Detecting Deadlocks Quickly
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers