Presenting at SQLSaturday #40 – South Florida
I'M ON A BOAT!
This is just a quick note to say that I’ll be in South Florida this weekend presenting...
2010-07-27
421 reads
Hit and miss
Or “Monitoring plan cache usage”
For people interested in the details of how SQL is using and reusing execution plans, there...
2010-07-27
1,143 reads
Count(*) or Count(1) ?
Every so often on the on-line forums, the question of : Which is better Count(*) or Count(1) ? will occur. So can...
2010-07-27
1,476 reads
Powershell Remoting with SQL Server
One of the best things to come out with Powershell V2 is remoting and asynchronous calls. Between the two of...
2010-07-27
1,581 reads
Slack Traveler
I realized over the weekend that I hadn’t booked a hotel for my SQL Saturday #28 trip to Baton Rouge....
2010-07-27
678 reads
Speaking at SQLSaturday #40 – South Florida
I finally get to head down to Miramar to speak at SQLSaturday #40 – South Florida. I really wanted to go...
2010-07-27
337 reads
Do As I Say, Not as I Do
Do I follow my own advice?
I’ve been asked that at a few of my Modern Resume presentations if I do...
2010-07-27
1,490 reads
[OT] Where Ya Been?
Have you heard the sound of silence? Yep, that’s been my blog.
It’s been weeks since I’ve posted anything on here,...
2010-07-27
682 reads
Pillbox Application
Ran across Pillbox in Government Computing News (GCN), a web app that lets you identify what a pill is based...
2010-07-27
625 reads
SQL Saturday #51 in Nashville
I just found out today that I will be one of the speakers at SQL Saturday #51 in Nashville, Tennessee...
2010-07-27
869 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