Determining Active Directory Group Membership
As discussed in my previous post I prefer to use Windows authentication over SQL authentication on my SQL Servers. There...
2012-01-24
1,722 reads
Chris McGowan
Security - SQL vs Windows
Security is a very important part of every DBA’s role. If you are not clued up on security best practices...
2012-01-23
939 reads
Database uplevel Restores Follow On
Today's post is a follow on from one earlier this month Database uplevel Restores. I got round to testing restoring...
2012-01-20
1,144 reads
Don’t Be a Balloon!
I had a problem just before the festive period where one of our production SQL Servers was randomly grinding to...
2012-01-18
1,717 reads
Moving Database Files and Replication
Today’s post is a quick one as I am a bit under the cosh.
There are many ways to move database...
2012-01-13
685 reads
System Stored Procedures
I've been using 4 alerts for corruption now for about 2 years for Errors 823, 824, 825 and 9100. Basically...
2012-01-11
1,047 reads
Server Name and SQL Server Name
I have, in the past had the need to rename a server, either because the server has been named incorrectly...
2012-01-10
776 reads
Database uplevel Restores
Today I've been reading Paul Randal's collection of Blogs from a series called A SQL Server DBA myth a day....
2012-01-06
687 reads
SQL Server Error Logs
I read a blog post this morning on SQLServerCentral by Tim Radney about SQL Server Error Logs. Tim talks about...
2012-01-04
1,079 reads
Dropping a Database
I came across an issue on a server this morning where a drive had run out of free space. Now given...
2012-01-03
617 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