The Three C’s Of Interviewing
A client of mine recently asked me to help fill a junior-level position in their organization. This isn’t uncommon; I...
2011-03-07
1,041 reads
Blog Posts
Upcoming Engagements
I haven’t been blogging lately because I’ve been busy tweaking my resume, working on PASS SQLRally, serving at church, and spending...
2011-03-07
633 reads
Upcoming Engagements
I haven’t been blogging lately because I’ve been busy tweaking my resume, working on PASS SQLRally, serving at church, and spending time with my family. Things aren’t going to be...
2011-03-07
12 reads
XQuery for the Non-Expert – Aggregates
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2011-03-07
1,256 reads
In summary - SQLskills internals.
Well, I attended a full week of SQL internals from Paul Randal [Blog | Twitter] and Kimberley L. Tripp [Blog | Twitter]...
2011-03-06
502 reads
Leading Wildcards Aren’t A Good Default
SQL Server has LIKE, which lets us do various pattern matches, but most commonly we use the percent side as...
2011-03-05
1,181 reads
SQL Server Hardware Selection Presentation from Rocky Mountain Tech Trifecta
I just wanted to post a link to my presentation on Hardware 201: Selecting and Sizing Database Hardware for OLTP...
2011-03-05
512 reads
Back from the MVP Summit
Back home after three days in Seattle at the 2011 MVP Summit. As I wrote in an editorial this week,...
2011-03-04
443 reads
Having Cake and Eating it Two
In early January, I wrote a little tribute to my wife for the awesome job she does when making cakes. There was a lot of good feedback from that....
2011-03-04
9 reads
Having Cake and Eating it Two
In early January, I wrote a little tribute to my wife for the awesome job she does when making cakes....
2011-03-04
518 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