Attending 2011 MVP Summit in Bellevue/Redmond, WA – Great Face-time with Fellow Speakers/Writers/Bloggers
The raincoast weather could be a little better, but so far, I am very happy with the brain-filling load of...
2011-03-01
915 reads
Blog Posts
Delimiting Results
Recently, I came across the need to delimit some data in order to be able to test some procedures that I was writing. The procedures need to be able...
2011-03-01
7 reads
Delimiting Results
Recently, I came across the need to delimit some data in order to be able to test some procedures that...
2011-03-01
611 reads
Firefox and NTLM Authentication
By default Firefox doesn’t pass through NT credentials, not a big deal when you’re browsing Amazon by a big pain...
2011-03-01
938 reads
How to Get a Head Start on Performance Tuning
The problem with performance tuning is that it is commonly considered as secondary to the task at hand rather than...
2011-03-01
725 reads
March Question: What’s Your Biggest SQL Server Performance Headache?
As DBAs, we have all received a phone call from a database user, asking why the database is so slow....
2011-03-01
604 reads
Rocky Mountain Tech Trifecta on March 5
I will be attending and speaking at the Rocky Mountain Tech Trifecta in downtown Denver on March 5, 2011. This...
2011-03-01
500 reads
SQL Server 2008 R2 RTM Cumulative Update 6 Released
Microsoft actually released SQL Server 2008 R2 Cumulative Update 6 on February 21, 2011, so I am a little late...
2011-03-01
1,076 reads
SQLDIY: Alert On Blocking Chains
Continuing the SQLDIY monitoring project we will take a look at tracking blocking events. I actually received a request to...
2011-03-01
2,866 reads
Don’t Be Afraid of Windows Failover Clustering!
One of the more exciting features in SQL Server code-named “Denali” (which is the current official name for the next...
2011-02-28
1,871 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers