Why do I contribute to the SQL Server Community?
As an active speaker and volunteer in the SQL Server community I am often asked why do I do it? ...
2010-10-12
535 reads
Blog Posts
Forgotten T-SQL Cheat Sheet
You’ve seen the blog, you’ve downloaded the code…you even watched the 24HOP session recording…now own the Forgotten T-SQL Cheat Sheet!
Yessir,...
2010-10-11
1,427 reads
Listing members of a group in SQL Server.
In SQL we are used to the GROUP BY and the type of result it produces. In real life, we...
2010-10-11
1,559 reads
PASS Update #44 (Budget)
I had a question recently about how budgets work at PASS, and I think that’s something worth sharing, so I’m...
2010-10-11
520 reads
Return Values from XP_CMDSHELL
Let’s be clear: I don’t recommend the use of xp_cmdshell as a general tool. It ought to be used when...
2010-10-11
17,389 reads
Running Totals for Each Group
A while ago, I posted a blog on how one could perform running totals using Reporting Services and a user...
2010-10-11
4,394 reads
S–3–X Talk Week: This Totally Won’t be Awkward
We’re conducting S–E–X Talk Week here at the MidnightDBA #Awesomesauce blog, in honor of everyone’s favorite subject. In deference to the...
2010-10-11
529 reads
SSMS Tip – Tab Groups
A few months ago as I came across tab groups in SSMS and once I found them I was very...
2010-10-11
1,097 reads
Updates on SQLSaturday#59.....6 Weeks to go!
I just wanted to update everyone on our event happening in NYC, November 20, 2010. We have just six weeks...
2010-10-11
547 reads
Getting ready for the third “Industrial Revolution”: Database 2010-2015
I searched the internet for “connect and forget”. Wonderbox.net offer is described as a...
2010-10-10
10 reads
Blogs
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers