Query Exercise Answer: Generating Big TempDB Spills
In last week’s Query Exercise, I challenged you to play some code golf to generate big spills with tiny T-SQL.
The AI Bubble and the Weak Foundation Beam
The problem that I continue to struggle with the AI Bubble is not innovation, but who has leverage. The AI industry has quietly constructed a capital stack with too many mutual dependencies and too few independent cash flows. When AI profitability hiccups, the financial impact does not land in one place. It cascades across the entire championship and everyone loses and not all players are equally positioned to survive it. This is the AI Bubble in a foundational nutshell.
Refactoring SQL Code
Refactoring code is a common task in many software development teams. Steve asks if this is something common for database developers as well.
Working with JSON/JSONB Data in PostgreSQL using Python
This article discusses how to work with JSON data in PostgreSQL using Python.
How to Monitor and Optimize Batched Deletion Processes in SQL Server
Batched deletions are a common strategy in SQL Server to manage large datasets without overloading the system, but poorly tuned deletes can cause blocking, long-running transactions, and heavy log usage. Learn how to monitor and optimize these processes for smooth, efficient database performance.
Investing for AI
Steve looks to the future of Microsoft and AI after listening to a podcast with Satya Nadella
Running SQL Server in Local Containers with VSCode MSSQL Extension
You are a developer using SQL Server for your applications, and you need to quickly setup a local development environment. How can you make sure the environment is OS agnostic, so it can run on any operating system? Let’s see how we can quickly create a local container to run SQL Server using the VSCode MSSQL Extension.
Configuring the On-Premises Data Gateway: The Fabric Modern Data Platform
In this next article on the Fabric Modern Data Platform, we examine setting up an on-premises gateway.
Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server
Learn about dbt, a tool used by lots of data engineers to move data between systems.
Your Security Checkup
We often find security issues come from holes in the way we've set up systems. Steve asks if you perform security checkups on your systems.
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
Backup Availability Group
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers