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,715 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
937 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,140 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,715 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
683 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,038 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
775 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
685 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,074 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
614 reads
Blogs
Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
The End of Year Vacation Burn
By Steve Jones
It’s been a good year for me. With my sabbatical, I felt like I’ve...
Speaking at PASS Summit 2025
By alevyinroc
In less than one month, I will be speaking not once but twice at...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
how to write this query?
Hi everyone I am a bit stuck on how to write this query. Below...
Powershell script to generate SQL server Inventory in CSV format
Comments posted to this topic are about the item Powershell script to generate SQL...
Question of the Day
Azure SQL Database MAXDOP
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers