Natural Born Killers (The series) – Day 8 Parameter Sniffing
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-27
1,936 reads
Blog Posts
Ohio Business Intelligence Road Trip 2013
Next month Mike Davis and myself will be making a epic road trip. We will be flying into Columbus, OH...
2013-06-27
1,627 reads
PowerSQL – Different Approaches to Find Free Space in all disk drives
Different ways to find FreeSpace in all disk drives of a given server
T-SQLUsing WMIObjectCountersAll three methods are explained below
This post...
2013-06-27
1,511 reads
SQL Server Installation Date
I have been working on a project recently to collect system metrics of a SQL Server environment. One of the items...
2013-06-27
1,399 reads
SQL Server Society of Las Vegas presents HealthySQL - Webinar! Tonite!
Hey, all!
Today, going on all day, is the Summer Performance Palooza 2013, hosted by the PASS Performance Virtual Chapter. It is...
2013-06-27
1,716 reads
SQL Server: Part 2 : All About SQL Server Statistics :Histogram
In the Part 1 about SQL server Statistics, we have discussed about density vector information stored in the the statistics. In...
2013-06-27
16,288 reads
Visual Studio 2013 preview available
Wow, Visual Studio 2012 is just out of diapers and here comes the next version!
Microsoft officials released the preview of...
2013-06-27
1,619 reads
Checkout SQL Server 2014 CTP1 and Windows 2012 R2 preview up in the cloud
You must be really busy spinning up VMs to test SQL Server 2014 CTP1 and Windows Server 2012 R2 preview.
If...
2013-06-26
1,616 reads
Indexing Fundamentals Presentation
**This Session has been rescheduled for July 10th @ Noon EST (16:00 UTC)** On July 10th 2013 @ Noon EST (16:00 UTC)...
2013-06-26
1,256 reads
Natural Born Killers (The series) – Day 7 Table Variables vs Temp Tables
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-26
2,666 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