Can You Dig It? – Find Estimated Cost
She can dig it!
D Sharon PruittIt’s the eighth post in the plan cache series. I hadn’t expect to take as...
2011-02-11
907 reads
Blog Posts
Colorado Speaking Tour
Next week, I’ll be making a swing through central Colorado on a working vacation of sorts. I met up with...
2011-02-11
535 reads
Iowa PASS Presentation Materials
Driving to the User Group
This past Wednesday I took a drive down to the Iowa SQL Server Users Group meeting. ...
2011-02-11
483 reads
MDX Performance - burdens of IIF
I used to think naively that IIF is an innocent little function that can only do good and help me...
2011-02-11
3,101 reads
Pragmatically Yours Day 2 – Our Team
One of the things I’m most proud of at our company is our team.You can see some of our team...
2011-02-11
710 reads
SQL University: Home-Grown, with Real Options!
There's the light, as this is the last class for Security week at SQL University. From the scenarios we specified...
2011-02-11
1,613 reads
StreamInsight: A new way to think about analyzing data
Last night’s Oregon SQL user
group meeting was very enlightening. Mark Simms form the SQLCAT team came
down from Redmond to talk...
2011-02-11
1,090 reads
T-SQL Tuesday Topics – Feb 2011
I was looking for a static list of all the T-SQL Tuesday topics and couldn’t find one. The domain moves...
2011-02-11
899 reads
Un-SQL Friday #003: Show Some Love
Last week, I asked the Twitter hive-mind about its favorite tech companies: “Which SQL (or SQL-adjacent) tech companies are doing...
2011-02-11
511 reads
Windows Instant File Initialization and SQL Server
One Windows setting that I think is extremely important for SQL Server usage is the “Perform volume maintenance tasks” right,...
2011-02-11
1,786 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
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
Imagine the Physical World
Comments posted to this topic are about the item Imagine the Physical World
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