The Tally Table
The tally table is a valuable tool for a SQL Server developer, but how many of you understand how to create and use one?
2025-12-26 (first published: 2015-08-13)
818 reads
Editorials
The DBA's Twelve Days of Christmas
On the first day of Christmas my new DBA sent to me A table with a primary key On the second day of Christmas my new DBA sent to me Two Foreign Keys, and A table with a primary key On the third day of Christmas my new DBA sent to me Three stored procs […]
2025-12-24 (first published: 2019-12-24)
388 reads
What's Your Area of Expertise?
We might be smart in one area, but not others. That's worth remembering.
2025-12-22 (first published: 2016-06-16)
205 reads
The Microsoft SQL Year in Review
Microsoft gives a year in review from the SQL Server and Azure SQL teams. Steve sees a lot of accomplishments from this past year.
2025-12-20
160 reads
Your Value from a Conference
Today Steve asks what value you get from attending conferences or other events.
2025-12-19
80 reads
The Challenge of AI
Steve sees a lot of challenges ahead for AI, especially in the area of labor and employment.
2025-12-17
99 reads
Growing Artificial Intelligence
This week Steve Jones discusses artificial intelligence and one of the building blocks that will be needed: data.
2025-12-15 (first published: 2016-07-04)
208 reads
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.
2025-12-13
759 reads
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.
2025-12-12
396 reads
Investing for AI
Steve looks to the future of Microsoft and AI after listening to a podcast with Satya Nadella
2025-12-10
135 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