SQL Server 2008 Diagnostic Information Queries (Dec 2010)
I have been quite the slacker (by my usual standards) for blogging over the past few weeks, but my excuse...
2010-12-14
676 reads
Busy Week
It’s going to be a busy week for me. At last count, I had over 40 comments for my T-SQL...
2010-12-14
706 reads
Notes from Mirroring Deep Dive Session with Mohammed Sharaf: Microsoft Premier Engineer (I can never learn enough about Mirroring :)
One thing I have gotten wrong before, or not elaborated on during a past presentation on mirroring, although Roman Rehak mentioned...
2010-12-14
3,086 reads
Soft Skills Matter More Than You Think
Over my career I’ve seen interviews fall into three categories:
The technical part. Questions on trace flags, wait states, backups, etc,...
2010-12-14
613 reads
Do IF statements cause recompiles?
I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...
2010-12-14
1,495 reads
T-SQL Tuesday #13– The Business and Disaster Recovery
I’m hosting this month’s T-SQL Tuesday blog party, but that doesn’t mean I can’t participate. I posted the invitation last...
2010-12-14
1,173 reads
Can You Dig It? – Missing Indexes
She can dig it!
D Sharon PruittWhen I started using XQuery to dig into the plan cache, it was just searching...
2010-12-14
2,772 reads
T-SQL Tuesday #13 - What the Business Says Is Not What the Business Wants
So this month’s blog party is being held by non-other than Steve Jones (blog|@Way0utwest) of SQL Server Central fame. This...
2010-12-14
595 reads
Work With Me at Pragmatic Works
Recently Adam Jorgenson wrote a blog post titled Come be your best at Pragmatic Works, which described the work environment...
2010-12-14
985 reads
T-SQL Tuesday #13 – What the Business Says Is Not What the Business Wants
This T-SQL Tuesday is hosted by Steve Jones (blog | twitter) and the topic he proposes is: "What issues have you...
2010-12-14
1,303 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