Writing Dynamic SQL (A how to)
A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions...
2013-07-01
2,741 reads
Blog Posts
My Thoughts about SQL Server 2014
SQL Server 2014 is coming. Go ahead and download the public CTP.
I’ve just started getting my hands dirty with the...
2013-06-28 (first published: 2013-06-25)
2,868 reads
Natural Born Killers (The series) – Day 6 Sargability
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-28 (first published: 2013-06-25)
2,791 reads
Reblog: June 21 to June 27
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-06-28
1,175 reads
SQL 2014 CTP1, where is my BIDS?
Oh wait sorry, I meant SSDT. Or was it SSDTBI? To avoid confusion about the developer tool to create BI...
2013-06-28
4,504 reads
SQL Server – Understanding ‘sp_spaceused’ Results for Database Size Information
From a recent conversation with a customer, I noticed even some of the experienced DBAs are not very clear about...
2013-06-28
1,623 reads
SQL Server 2014 CTP1 Released
This week has been the week of the release: We’ve had the Visual Studio 2013 Preview and now the SQL Server 2014 CTP1. And that’s just the ones I’m...
2013-06-28
5 reads
5 community stored procedures you need for your servers
We’re blessed in the SQL Server community that there are so many people willing to share work they have done...
2013-06-27
4,070 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.1: An Introduction to Plug-In Algorithms
by Steve Bolton
…………In my last post in this amateur series of self-tutorials on SQL Server Data Mining (SSDM), I got...
2013-06-27 (first published: 2013-06-25)
2,730 reads
Improved Temp Table Caching in SQL Server 2014
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Under some preconditions...
2013-06-27
3,209 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