Tag Archives: Security

Login Script Generation For Migration or DR

Posted on March 25, 2020 by thomasrushton

I needed a script to create logins on a second server to match the primary. There are reasons why using, say, the powershell dba tool set isn’t an option (eg the server isn’t built, or the two can’t communicate, or … Continue reading →

Posted in Uncategorized | Tagged , , | 5 Comments

Departure of a SQL Server Administrator – What to Check?

Posted on January 3, 2020 by thomasrushton

A SQL Server administrator has left. But what does that actually mean? What do we need to check to make sure that things will continue to work after their Active Directory account is disabled? Some things to check are: SQL … Continue reading →

Posted in Uncategorized | Tagged , , , , , | 1 Comment

Book Review – “Securing SQL Server” by Denny Cherry

Posted on December 28, 2012 by thomasrushton

As part of my SQL Saturday 194 homework, I’m reading through “Securing SQL Server: Protecting Your Database From Attackers” by Denny Cherry (blog|@mrdenny on Twitter). Denny’s doing a full day training session (“pre-con”) at this event on “SQL Server Security”, … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | 1 Comment