T-SQL Tuesday #12 - Misconceptions
It’s time for T-SQL Tuesday again, and I’m happy to participate again. This is a monthly blog party started by...
2010-10-12
1,263 reads
Blog Posts
TSQL Tuesday Misconceptions in SQL Server
I haven’t written a post for a TSQL Tuesday for a little while and I know that I’m late getting...
2010-10-12
1,077 reads
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
549 reads
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,451 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,576 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
523 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,419 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,398 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
539 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,099 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers