My 2011 Aspirations
Yesterday, I posted a blog about my year in review for 2010. So, I thought that it would be a...
2011-01-04
444 reads
MCM Prep – Only ONE Transaction Log File
Unlike for data files, SQL Server does not use multiple files for the transaction log in any way that improves...
2011-01-04
790 reads
SSMS addin (and wrapper)
So I mentioned I'd been working on an SSMS addin. What I didn't mention was that I've also been working...
2011-01-04
1,415 reads
MCM Prep - Sliding the test
If you can’t cram enough for the test, what’s the thing to do? Slide the test. I realized last night...
2011-01-04
769 reads
The Best Database Administrators Automate Everything
Do you understand the value of your time? I mean really understand it. Time is your absolute number one most valuable asset. Once...
2011-01-04
1,428 reads
Invitation to T-SQL Tuesday #014
Hello and welcome to the first T-SQL Tuesday of 2011!
2010 was a great year for T-SQL Tuesdays, dreamed up and...
2011-01-04
1,303 reads
MCM Live Blog – Week January 3
Watching videos?! Su-ure!
Surprisingly it’s now my fourth week of blogging about the things that I’m doing to study for the...
2011-01-04
274 reads
MCM Prep - Only ONE Transaction Log File
Unlike for data files, SQL Server does not use multiple files for the transaction log in any way that improves...
2011-01-04
781 reads
My 2010 Year in Review
While in Cincinnati for the first time since September of 2007, I heard on several occasions that I work too...
2011-01-04
404 reads
31 Days of SSIS – Data Flow Breakpoints?! (3/31)
31 Days of SSIS
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. In yesterday’s post I...
2011-01-04
546 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