SQL Server Storage Internals Part 1 - Basics
While learning query tuning topics, I got a chance to understand anatomy of data page and different types and levels...
2010-12-13
6,812 reads
Upgrading to SQL Server 2008 - a comprehensive checklist.
There are many considerations and much preparation to do, when a company decides that it is ready to upgrade their...
2010-12-13
13,797 reads
iPads for Christmas
There's a contest going on, today through Friday, and you can win a copy of SQL Monitor from my employer...
2010-12-13
808 reads
SQL Server 2005 SP4
Last year I submitted a Connect item for SQL Server 2005 SP4. Quite a few people supported this item and...
2010-12-13
1,438 reads
All Things Awesome and MidnightDBA-y – 12/9/2010
Here’s the rundown of what we were up to last week
Friday night at 11pm CST we present another wildly appealing...
2010-12-13
811 reads
December PASSMN Meeting This Week
Getting SQL Server for
Christmas! Happy holidays and seasons greetings!
Let PASSMN put a little SQL and PowerShell in your...
2010-12-12
630 reads
SQL Standards
Three posts, three critical rants. It's time to be constructive.
I was given the responsibility to decide on the SQL development...
2010-12-12
1,651 reads
SQLPSX 2.3.1 Release
We’ve released a minor update to SQLPSX which includes several bug fixes as well as two new modules. Here’s an...
2010-12-11
773 reads
SSIS: great idea, but buggy as heck.
Oh SSIS, how I love and hate you.
As DBA at my company, I don't actually develop much in SSIS. But...
2010-12-11
1,791 reads
RTFM365, Week 1
Big lessons learned this week: 1, its’ always worthwhile to go back and reread the basics. 2, sys.sp_trace_create option 4 doesn’t...
2010-12-10
514 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