Wife and kids are leaving for holiday (it’s not off-topic)
My wife and kids are leaving for holiday (without me). Bad thing is that I will miss them, good thing...
2011-07-07
1,302 reads
SQLDIY: Index Fragmentation Levels
Indexes, indexes, indexes my kingdom for an index! Well, something like that. Indexes are the single most important structure in...
2011-07-07
1,273 reads
The IF Statement in a T-SQL Query
I’ve seen quite a few posts from people asking how to do something like this:
SELECT
a.ID
, IF a.MyChar = 'A' THEN...
2011-07-07
158,485 reads
Maciej Pilecki Speaking at Space Coast UG on July 14, 2011
Just got an email from the Space Coast User Group that Maciej Pilecki (@DrHouseOfSQL) will be doing a presentation to...
2011-07-07
614 reads
PASS Update #59 (Run for the Board)
If it hasn’t happened already we should be close to beginning the election cycle for the 2012 election. Last year...
2011-07-07
601 reads
What is Pipeline Backpressure?
First - I'll get the "what's a pipeline got to do with Integration Services" question out of the way. The "pipeline" I'm referring to here is the word commonly...
2011-07-07
11 reads
What is Pipeline Backpressure?
First - I'll get the "what's a pipeline got to do with Integration Services" question out of the way. The "pipeline" I'm referring to here is the word commonly...
2011-07-07
34 reads
SQLSaturday #85-Call for Pre-Con Speakers
We’re going to be hosting two pre-conference seminars this year in Orlando on Friday, September 23rd, and we’re looking for...
2011-07-07
420 reads
What is Pipeline Backpressure?
First - I'll get the "what's a pipeline got to do with Integration Services" question out of the way. The "pipeline"...
2011-07-07
3,450 reads
Less code with rethrowing “exception” in SQL Server 2011
I wrote about some skeletons in the Denali’s closet here. Let’s also put some good on the table. Very handy...
2011-07-06
1,221 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
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...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
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