Rating PASS Abstracts
I was on a committee to help rate abstracts for the PASS Summit this year. It was an interesting and...
2010-07-01
836 reads
SSAS Cache Warming with an SSIS package
There are several techniques that can be used for performance tuning Analysis Services. You may already be familiar with the...
2010-07-01
2,867 reads
My Ideal SQL Server Test Box is on the Way
Several weeks ago I wrote a blog post called “What is the Ideal SQL Server Test Box?” At that time...
2010-07-01
1,169 reads
Building A Remote Desktop Manager Cluster List
The Microsoft Clustering and High Availablity bloggers have taken noticed of the Remote Desktop Connection Manager (RDCMan) utility from a...
2010-06-30
1,612 reads
MDX Puzzle #2
Now that we have our feet wet, let’s get started with the next puzzle. In this puzzle we will write...
2010-06-30
1,453 reads
One of these things is not like the other
I’m working with PowerShell, and digging it. I decided that I wanted to create a new script (blog post later,...
2010-06-30
2,092 reads
The Politics of SQL Server Performance
Like most DBA’s I’m sure you often find yourself delivering information to the business concerning the performance of your SQL...
2010-06-30
1,521 reads
SQL Saturday #48 - Columbia, SC - Registration and Call for Speakers is On-line
The website is up for SQL Saturday #48 - Columbia. We're holding it on October 2, 2010, in West Columbia, SC,...
2010-06-30
1,445 reads
PASS, Don’t Waste My Time
Update: Apparently I can't write, or get a point across from the
comments and a few emails, so I have...
2010-06-30
2,518 reads
DB2 – Create a Database
OK for my next DB2 trick and remaining off the path of the righteous for the time being we will...
2010-06-30
4,991 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