Liability for AI Errors
Who is liable for mistakes made when listening to AI tooling? In at least one case, Steve isn't sure.
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Taking SQL art from shamrocks and Easter eggs to something your DBA manager might actually care about. If you've been following my SQL spatial art series — shamrocks, Easter eggs, Christmas trees — you'll know I have a habit of finding increasingly creative misuses for SQL Server's geometry data type. Most of them have been […]
The Degradation of the Turing Test
Are computers getting smart enough to pass the Turing test or are humans getting worse at representing themselves as intelligent?
How data scientists work with PostgreSQL from Python (and how to write queries that don’t break at scale)
In this article, learn how PostgreSQL powers data science workflows, including query execution, performance optimization, indexing, data retrieval, and more.
SQL Saturday Austin 2026
SQL Saturday Austin 2026 is coming on Jun 27, 2026. A free day of networking, training, and inspiration. Register today and come spend a day with your peers.
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Stairway to Reliable Database Deployments introduces a progressive approach to managing database changes with clear intent, predictable rollback, and explicit behavioral guarantees. Starting from change design and moving toward execution and coordination in complex environments, the Stairway provides a conceptual framework for deploying database changes safely and consistently, independent of specific tools or automation platforms.
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
After defining the deployment contract in the previous level, this article focuses on validating a changeset before it reaches production. Rehearsal across environments ensures that execution order, rollback behavior, and baseline alignment all behave exactly as expected.
Stairway to Reliable Database Deployments Level 2 - Defining the Deployment Contract
Level 2 formalizes the behavioral guarantees that a changeset must provide in order to be safely deployed and rolled back. It introduces the deployment contract, checkpoint semantics, and the structural scope of Create and Rollback scripts. Data changes are addressed through a dedicated Update mechanism, with clear boundaries and limitations. By the end of this level, a changeset becomes a predictable and well-defined unit that can be reasoned about independently of execution context.
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
This level examines how a rehearsed changeset is transformed into production-ready deployment artifacts. By consolidating scripts into controlled execution units and validating the resulting artifacts, the approach ensures that production deployment remains predictable and aligned with what was proven during rehearsal.
How Do the Experts Become Experts?
How do the experts get to that level? A few thoughts today in a guest editorial from Kathi Kellenberger.
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Alamat BCA KCU BEKASI Hub:Cs,0817781222
Wa:0817781222 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa...
Alamat Kontak BCA KCU RAWAMANGUN Hub:Cs,0817781222
Wa:0817781222 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah Khusus...
Alamat Kontak BCA KCU THAMRIN Hub:Cs,0817781222
Wa:0817781222 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers