Voting Theory
I was enjoyed the Sunday newspaper (on Sunday!) and ran across this column about various voting systems and that made...
2010-09-09
431 reads
Connection String Settings: Timeouts and Pooling
If you are having SQL Server Database connection issues, I reckon they could be due to one of two connection...
2010-09-09
26,614 reads
PASS SQLRally – Session/Speaker Selection
Hopefully by now you’ve heard about the PASS SQLRally event that will be held in Orlando, May 11-13. Andy Warren,...
2010-09-09
530 reads
Retiree Association Firmly Onboard with My Repetitive Criticism of Quebec’s Deposit and Investment Fund: Mille fois Bravo l’AQRP ! :)
Just a bit of follow up here, to start closing the loop, regarding my multiple written outbursts regarding the institutionalised...
2010-09-09
2,053 reads
The Perfect SQL Server DBA / Developer Role
Whilst enjoying my coffee fix this morning, along with today’s SQL Server Central Email, my attention was caught by Steve...
2010-09-09
358 reads
SQL Server - Dedicated Administrator Connection (DAC)
This a short post looking at the Dedicated Administrator Connection or DAC for short. In extreme circumstances, when there is...
2010-09-09
8,237 reads
SQLRally Meeting Minutes
The starting point for a good meeting is an agenda and minutes. It took us a bit to catch up,...
2010-09-09
681 reads
T-SQL - Is Saving Space Worth It?
I ran across this blog post on Joe Celko’s Restaurant Seat Assignment Problem that found a way to implement the...
2010-09-09
308 reads
Some Moderately Big Iron on x64
Here is a screenshot from a Dell PowerEdge R910 with four 2.27GHz Intel Xeon X7560 processors and 256GB of RAM....
2010-09-08
1,004 reads
September TSQL Tuesday
It is hard to believe that time is flying like it is. Already it has been a month since I...
2010-09-08
525 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