July 17, 2013 by Kenneth Fisher
I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead …
Continue reading
Category: Microsoft SQL Server, Security, Settings, SQLServerPedia Syndication, SSMS | Tags: security, SSMS
May 30, 2013 by Kenneth Fisher
A couple of months ago I talked about moving a login from one server to another without the password. The …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL | Tags: code language, dynamic sql, language sql, microsoft sql server, security, sql statements, T-SQL
March 25, 2013 by Kenneth Fisher
This is an uncommon task but one that does turn up every once in awhile. A SQL login has to …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL | Tags: language sql, microsoft sql server, security, server permissions, sql statements, system functions, T-SQL
March 1, 2013 by Kenneth Fisher
I was scanning http://dba.stackexchange.com and ran across the following question: http://dba.stackexchange.com/questions/31478/sql-server-script-to-delete-accounts-no-longer-in-active-directory Basically the OP wanted to know how to get …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL | Tags: code language, language sql, microsoft sql server, security, server permissions, T-SQL
December 3, 2012 by Kenneth Fisher
Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems. …
Continue reading
Category: DMV, Microsoft SQL Server, Security, SQLServerPedia Syndication | Tags: database permissions, DMV, microsoft sql server, security, server permissions
SQL Studies