Re-blog – July 1-July 7
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-07-08
468 reads
Brute-force searching for data.
Today, I needed a way of searching through a database, any database, looking for a certain string. The procedure I...
2011-07-08
3,831 reads
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
602 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
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