Upcoming Engagements
I haven’t been speaking a lot lately as I’ve been busy working, planning SQLSaturday #49 – Orlando, and planning PASS SQLRally,...
2010-09-07
482 reads
Auto Close – SQL Server
I ran into an issue recently where I had a third party supplied database set to auto close. I couldn't...
2010-09-07
3,000 reads
Unique and non-unique non-clustered indexes on a non-unique clustered index
In the last weblog post I have talked about the differences in unique and non-unique
non-clustered indexes on a unique clustered...
2010-09-07
4,111 reads
Virtual Labs - A Great Resource for SQL Server
I had someone send me a note recently asking some questions about how to get set up to work with...
2010-09-07
1,063 reads
Book Review: Rehnquist: A Personal Portrait of the Distinguished Chief Justice of the United States
Another choice brought about by wandering the local library, Rehnquist: A Personal Portrait of the Distinguished Chief Justice of the...
2010-09-07
592 reads
PASS BI Virtual Chapter Event - SSRS 2008 R2 The New Stuff
Quick update from your PASS BI Virtual Chapter folks!
September 29th, Mike Davis is doing a session on SSRS R2: The New...
2010-09-06
389 reads
Get ready for the Third Annual SW Florida .Net Code Camp!
Hey there database folks! Don’t be scared off by a little .NET. The SW Florida code camp is getting underway...
2010-09-06
364 reads
PASS BI Virtual Chapter – Adaptive BI: Engineering a BI Solution
Hey there folks – PASS Virtual BI Chapter Event Alert!
Don’t forget to come out on Sept 20th and get Adaptive with...
2010-09-06
1,088 reads
SQL Lunch #38-Restartability in SSIS
Hey There SQL Lunchers – Come out and check out Kyle Walker talking about restartability in SSIS.
Specifics to make sure you...
2010-09-06
405 reads
Where do you get your motivation and drive?
I was asked by someone the other day, where do you get your drive and motivation? For a second, I...
2010-09-06
653 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