Restarting SQL Server using a Batch Script
In a previous post, I showed you how one could Restart, Stop and Start the services for an instance of...
2010-08-29
13,176 reads
BrianKMcDonald
Restarting SQL Server using the GUI
Sometimes you may need to restart your instance of SQL Server. You should rarely do this on Production boxes, but...
2010-08-29
487 reads
Jax Code Camp - My Presentation and Projects
First and foremost, I want to thank everyone who attended my presentation today. It got off to a late start due...
2010-08-28
420 reads
How Many Columns In Table and Which Have Identity Columns
I recently had to find a way to look up how many columns were in a table and which of...
2010-08-20
427 reads
JSSUG Tomorrow Night - 8/18/2010
I heard a little birdy cherping and it looks like there is going to be a great give away tomorrow...
2010-08-18
551 reads
When Did I Install SQL Server?
While getting prepared for an upcoming presentation, I remembered that I installed the November CTP trial on the machine that...
2010-08-18
449 reads
Forgetful Fred and SQL Server Management Studio
Scott Gleason just posted a blog yesterday that showed an awesome new tool that people can create little animated videos....
2010-08-15
370 reads
Pesky Protected Mode
How many of you keep falling for this one…You open up Report Manager for a user that you know you...
2010-07-29
1,473 reads
Commenting TSQL Scripts
If you have ever searched for “commenting in TSQL” scripts, I am sure that you’ve found hundreds or maybe even...
2010-07-29
1,754 reads
What Indexes are on My Table!
In this quick blog, I want to show you one way of how to find out what indexes you have on a table...
2010-07-29
482 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