SQL Saturday 232 Schedule is LIVE!
Hello Dear Reader! Just a quick blog post today. The Schedule for SQL Saturday 232 is now live! You probably...
2013-07-16
554 reads
Blog Posts
SSMS 2012 Extender for the times you want some organization to the random pile of objects gathering in the dusty confines of that database
When dealing with large amounts of objects in a database, navigation can be tedious with SSMS object explorer. This extender...
2013-07-16
745 reads
The benefit of placement firms
Why do companies use placement firms to find IT contractors instead of using internal recruiters?
Who better to answer that question...
2013-07-16
795 reads
A Tale of Two Hotels
This is a long and convoluted post about my experiences at two hotels, but it has a point for DBAs...
2013-07-15
835 reads
Check unused index in SQL Sever 2008
Checking for unused indices across your database should also be a part of housekeeping. Usually i would schedule checking for...
2013-07-15
364 reads
Guide to SQL Server Table Indexes (Part 1)
One of the most important tasks for every database administrator (DBA) is to ensure that query times are consistent with...
2013-07-15
1,386 reads
Last Weeks Top “Reading” Links #41
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-07-15
616 reads
Microsoft SQL Server security best practices checklist
SQL Server is a repository of sensitive information for organizations, and that is why it is important to ensure that...
2013-07-15
3,422 reads
New Hebrew SQL Server Podcast
Five months ago, I wrote a post about my love for Podcasts.
At some point, I started to think about starting...
2013-07-15
1,082 reads
Ordering steps in a SQL Agent job
Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is...
2013-07-15 (first published: 2013-07-08)
2,199 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