Setting DBCC 1222 on startup
The following command is run to gain details on deadlocks.
DBCC TRACEON (1222,-1)However, once the SQL instance is restarted this flag...
2016-09-19
145 reads
Sheldon Hull
- Website: https://www.sheldonhull.com
Remote Desktop Workflow Improvements
Remote server management is a fact of life for folks involved with sql server. Since we work so often with...
2016-08-29
176 reads
Remote Desktop Workflow Improvements
Remote server management is a fact of life for folks involved with sql server. Since we work so often with...
2016-08-29
653 reads
Install ReadyRoll via Command Line
command line install options
ReadyRoll has some great features, including the ability to use without cost on a build server. If...
2016-08-26 (first published: 2016-08-18)
1,111 reads
SSMS - Connection Color with SQL Prompt & SSMSBoost
If you haven't explored the visual color coding of tabs based on pattern matches with SQL Prompt, I'd suggest you...
2016-08-23
223 reads
SSMS - Connection Color with SQL Prompt & SSMSBoost
If you haven't explored the visual color coding of tabs based on pattern matches with SQL Prompt, I'd suggest you...
2016-08-23
1,108 reads
SQL 2016 - Brief Overview on some new features
These are notes taken from the Houston SQL Pass User group from July. This presentation was given by John Cook,...
2016-08-19
165 reads
SQL 2016 - Brief Overview on some new features
SQL 2016 - New Functionality
These are notes taken from the Houston SQL Pass User group from July. This presentation was given...
2016-08-19
834 reads
Install ReadyRoll via Command Line
command line install options
ReadyRoll has some great features, including the ability to use without cost on a build server. If...
2016-08-18
263 reads
Regex With SQL Server - SQLSharp
In the context of my developer machine, I had log files I wanted to parse through. I setup a log...
2016-08-17 (first published: 2016-08-11)
3,344 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
The String Distance I
Comments posted to this topic are about the item The String Distance I
How Database Professionals Sent a Million Emails a Day from SQL Server
Comments posted to this topic are about the item How Database Professionals Sent a...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers