TRY, CATCH, and Transactions
The T-SQL TRY/CATCH structure (“new” in SQL 2005!) is, as the professionals say, da bomb. It’s also underused and under-understood,...
2013-06-20
2,410 reads
Blog Posts
use Table Variables in transaction
when using table variable, please note table variable doesn't support transaction rollback. here is the words from BOL
Because table variables...
2013-06-20
2,778 reads
Das Keyboard - First Thoughts
There seems to be a lot of buzz around mechanical keyboard lately as more and more manufacturers have started producing...
2013-06-19
46 reads
Dealing with Auditors: Password Settings
Yet again I've seen an audit request where the auditor wants the DBA to show what SQL Server's settings are...
2013-06-19
8,240 reads
Natural Born Killers (The series) – Day 3 Scalar UDF’s
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-19
911 reads
New Page - "How to Get Involved With the SQL Server Community"
I recently composed an email (on the side) for a client DBA looking for info on getting involved with the...
2013-06-19
514 reads
ORDER BY the numbers
Have you ever needed to order by a calculated column? You might have written it something like this:
SELECT LoginID, YEAR(HireDate)...
2013-06-19 (first published: 2013-06-17)
2,784 reads
Special Recognition For Top Community Leaders In India
I got a special recognition from Microsoft, India as one of the top community leaders.
My sincere thanks to SQLServerCentral (my...
2013-06-19
1,310 reads
SSAS Data Mining – Time Series Algorithm
At TechEd 2013, I attended a few sessions on the topics of Data Mining and Predictive Analytics. I thought I’d...
2013-06-19
7,090 reads
The Changing World of BI, A New White Paper for Magenic
In the ever changing landscape that is Business Intelligence (or is that Business Analytics?), a fellow business analyst from Magenic,...
2013-06-19
923 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