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
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers