A Small Collection of DBCC Commands
There are a number of pretty useful DBCC Commands that have nothing to do with checking the consistency of a...
2010-08-02
1,990 reads
PASS Update #40 (Elections)
Last week I made it through the first screening of candidates for this years Board of Directors election. Seven of...
2010-08-02
355 reads
SQLSaturday #40 – South Florida Recap
I had the great privilege to be able to attend and speak at SQLSaturday #40 – South Florida this past weekend...
2010-08-02
655 reads
SQL Saturday #28 - Two Weeks Away
It’s a little less than two weeks until SQL Saturday #52 in Baton Rouge. I attended last year, and thoroughly...
2010-08-02
359 reads
SQL Saturday 28 Baton Rouge and Ask the Experts
The second annual SQL Saturday Baton Rouge event is coming up in less than two weeks! Have you registered?
I’m honored...
2010-08-02
609 reads
What Are You Afraid to Ask?
There are some questions that can’t necessarily be answered in a book or a training video. Those are often the...
2010-08-02
600 reads
MDX Puzzle #5
Writing YTD totals and Running totals using T-SQL can take a little effort. However, with MDX it's not too difficult. ...
2010-08-01
554 reads
A Milestone
I just passed 100,000 views on the blog. That’s from 400 posts over a period of time starting in March...
2010-08-01
661 reads
Moving to a New Blog Platform
Moving to a New Blog Platform
First, I want to say that having my blog on SQL Server Central has been...
2010-08-01
1,024 reads
Like a Phoenix rising from the ashes ...
NOTE: At least one project will be selected every week for the remainder of 2010. Like the Phoenix rising from...
2010-07-31
1,436 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