How to Avoid SQL Server 2008 Lingering Evaluation Installs - Validation Before Applying SP2 (10.0.2531 to 10.0.4000)
We wound up in a nasty situation recently where SP2 could not be applied to an instance of SQL Server. ...
2011-02-21
1,612 reads
Blog Posts
London UK SQL Server User Group – It’s Back!
"We're back with a Bang!"
In case you missed it, being tucked away amongst all the other UK SQL Server User...
2011-02-21
649 reads
Moore’s Law May Be The Death of NAND Flash
"It ain’t what you don’t know that gets you into trouble. It’s what you know for sure that just ain’t...
2011-02-21
1,012 reads
Pragmatic Transition: Lighthouses and Shipwrecks
Sometimes your mistakes are the greatest lessons...
This is the next post in my series about transitioning from a DBA to...
2011-02-21
698 reads
SQLSaturday#69 - Update - Schedule Posted! - You Can Still Register
It's just a little less than 2 weeks to SQLSaturday#69 at DeVry University, 1140 Virginia Drive, Ft. Washington, PA 19034...
2011-02-21
873 reads
Testing SSAS Security in Excel
There are many posts available that describe how to test Analysis Services security from inside the development environment.Today I would...
2011-02-21
1,502 reads
The Joy of Contracting
As you may or may not know I have been contracting since 2007, almost 4 years now and I have...
2011-02-21
918 reads
The Winter 2011 Colorado SQL Tour
During my visit to Denver last September for SQL Saturday 52, I spent a while talking with Marc Beacom, who...
2011-02-21
963 reads
Use Patterns and Prior Code and Don't Reinvent the Wheel
In recent days I've seen folks try to recreate functionality when they had access to code that already did effectively the...
2011-02-21
1,987 reads
24 (Hours of SQL Training Delivered to Your Computer)
The Spring 24Hours of PASS: Celebrating Women in Technology will be broadcast live on the intertubez on March 15 and 16...
2011-02-20
1,631 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