Answer the Question Asked
“Bill, are you running SQL R2 on your desktop?”
This seems like a simple enough question, yet I usually cannot get...
2012-01-13
846 reads
SQL Awesomesauce
DBAs@Midnight 6 week roundup
We’ve been awfully busy these last few weeks, what with holidays and work and whatnot. But that hasn’t stopped us...
2012-01-12
691 reads
SELECT GetDate() – 30 AS [This actually works??];
I just ran across this in a piece of code (that I didn’t write):
… WHERE Thing >GETDATE()- 30
Aaaand it works....
2011-12-19
1,233 reads
PASS Board of Directors – Who I’m Voting For
I was inspired by fellow blogger and all around good guy Nic Cain (Twitter, blog) to write about the PASS BoD...
2011-12-15
673 reads
#SQLLove for my Mentor
In 1986, my big brother Jim accidentally encouraged me on my road to geekdom by purchasing an Apple][e, and later...
2011-12-14
746 reads
SQL Server is Smarter Than You
I had a brief email discussion recently, which could be effectively be boiled down to:
Them: “Are foreign key constraints more...
2011-12-08
845 reads
How to Build a Resume (that doesn’t suck)
Resumes are like opinions, which are like something else: everybody’s got one. And if you don’t have one, then certain...
2011-12-06
3,162 reads
Convince me to read books (WHERE LEN(argument)
While you wait for my awesome upcoming blog on data exception notification with SSRS, let’s pursue a whim of mine.
I...
2011-11-30
1,674 reads
Stop SOPA…it already happened in Denmark #StopSOPA
I put out the call to stop SOPA, and one Twitter friend wrote back:
Good luck! We have it in Denmark....
2011-11-16
552 reads
Un-SQL Friday: Stop SOPA!
This will be an unusually political Un-SQL Friday – and it’s two days early, to boot – but I’m making an exception...
2011-11-15
1,059 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers