Bad Stored Procedures
Stored procedures can be poorly written, but Steve prefers them over embedded code.
2024-09-20
423 reads
Editorials
When Do We Worry About Scalability?
Steve has a few thoughts on the tradeoff between getting work done quickly and producing well performing code.
2024-09-18
123 reads
2024-09-16
89 reads
2024-09-14
91 reads
A Simple Solution
Today Steve wonders if you have simple solutions you like or complex ones you don't.
2024-09-13
162 reads
Casino Night is Back
Casino Night from SQL Server Central is coming back to the PASS Data Community Summit.
2024-09-11
411 reads
The Invisible Disk
Steve sees disk drives as shrinking to the point of being invisible to most of us.
2024-09-09
311 reads
Knowing What You Don't Know
I used to think I knew everything. I felt like I had the world all figured out. But then, when I went to kindergarten, I realized that I didn't know much at all. As I grew older and finished college, I regained confidence in my knowledge and again felt like I knew everything about the […]
2024-09-07
113 reads
2024-09-06
136 reads
2024-09-04
394 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers