My Application to the PASS Board
The application form mentions that the quite a bit of what you include will be made public. While I won’t...
2010-07-20
711 reads
SSIS - Event Handler Performance
Event handlers are a great tool for managing errors and other events that occur during the execution of a package...
2010-07-20
1,141 reads
Free SQL Server DMV Starter Pack
The SQL Server DMV Starter Pack is a free eBook (84 pages) that describes 28 different ways that DMVs can...
2010-07-20
4,905 reads
Increasing or Decreasing Sampling Size in SSAS Data Source View Data Explorer
Recently, I have begun my quest of mastering SSAS. I realize that it may take time and I am more...
2010-07-19
513 reads
SSIS - Event Handler Performance
Event handlers are a great tool for managing errors and other events that occur during the execution of a package...
2010-07-19
3,966 reads
Creating UDL Files On The Fly
Many years ago, in the dark ages of DTS I created a little app that would take two parameters and...
2010-07-19
661 reads
Finding Your Next Job
We’ve had a few people in the SQL community find jobs lately and many of them attributable to their network....
2010-07-19
522 reads
How to Deal with Quebec’s Extremists: Expose Their Malfeasance Publicly?
NB - to my regular blog readers, excuse the tangent here, but the local provincial extremists attempted something in my 'hood...
2010-07-19
6,761 reads
I Did It - PASS Nomination Application
I send my board of directors nomination application to PASS and asked for a confirmation. I always worry that something...
2010-07-19
675 reads
SQL University: Introduction to Indexes, Part the First
Right, all eldritch tomes are to be closed and Elder Signs are to be put away during this course.
Welcome to...
2010-07-19
758 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