Speakers Announced for SQLSaturday #232 in Orlando
It’s done, finally! The sessions for SQLSaturday #232 have been selected and the schedule is available for viewing. We have...
2013-07-17
695 reads
Blog Posts
SQL Server: Performance Tuning :Understanding Set Statistics IO output
Performance tuning is one of the important task of DBA. Many times people comes to us with different types of performance issue.To handle all these, we should have...
2013-07-17
51 reads
SQL Server: Performance Tuning :Understanding Set Statistics Time output
In the last post we have discussed about Set Statistics IO and how it will help us in the performance tuning....
2013-07-17
19,713 reads
The Stairway to Deployment
Next week I travel to Sacramento, CA for the SQL in the City Seminar – Stairway to Deployment on Friday, July...
2013-07-17
1,078 reads
70-457 Reviewer #03, Planning an Installation of SQL Server 2012
Planning an installation on SQL Server 2012 is under the Install and Configure SQL Server objective which is 19% of...
2013-07-16
657 reads
Cumulative Updates - SQL Server 2012 SP1 CU5
As part of their Incremental Service Modelling, Microsoft have released SQL Server 2012 Service Pack 1 Cumulative Update #5.To apply this cumulative update package, you must be running SQL...
2013-07-16
14 reads
Data Visualization – Book Review
To prepare myself for my session Data Visualization Tips & Tricks, I read a few books. In this blog post, I’ll...
2013-07-16
1,099 reads
How to share redgate database tools settings with Team Foundation Service
In a previous post we’ve seen how to share the SQL Prompt snippet folder to the development team. We’ve used dropbox for sharing...
2013-07-16
1,005 reads
OT: Kicked Out of a Motel for Charging at 12 Amps
This is a pretty long story…
My wife and I had an interesting road trip to Salida, CO this past weekend,...
2013-07-16
1,297 reads
Setup an Availability Group with Multiple Subnets in VMware Workstation
Before we get started, I want to make it clear this is NOT how you would normally configure all these...
2013-07-16
2,530 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