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)
811 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)
372 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)
198 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
91 reads
Your Value from a Conference
Today Steve asks what value you get from attending conferences or other events.
2025-12-19
45 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
83 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)
191 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
729 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
270 reads
Investing for AI
Steve looks to the future of Microsoft and AI after listening to a podcast with Satya Nadella
2025-12-10
120 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers