Audit Users logging in using "sa" or service accounts

Security is probably one of a production DBA's most important tasks and if developers use application or service accounts to run queries in your production environment you need to identify then and prohibit it. I notice some unwanted activity after staring a new job and decided to create a script that notifies me via email when […]

Renaming a login

Login restriction from selected applications and users

It will help to DBA for restrict the SQL Users login from selected applications programs and track there logins with Host name and other details

Generate Login Script(2008R2 And Older)

Generate Script from Logins of Sql Server to recreate in another instance

Prevent and Log Certain SQL Server Login Attempts

Aaron Bertrand presents a more elegant to prevent developers from attempting to log into production databases using application logins (and to log any such attempts).

Drop Me? No, I Don't Think So

Can't See The Forest For the Logins

The Unusable User

Script Login Differences

Compare the logins and users on two instances and generate a TSQL script to make them the same.

Script All Logins / Users / and Roles

This Script Generates A script to Create all Logins, Server Roles, DB Users and DB roles on a SQL Server.