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 […]
2019-07-04 (first published: 2019-06-26)
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
2018-04-11 (first published: 2018-03-29)
Generate Script from Logins of Sql Server to recreate in another instance
2015-08-25 (first published: 2015-08-10)
Compare the logins and users on two instances and generate a TSQL script to make them the same.
2015-02-26 (first published: 2013-11-15)
This Script Generates A script to Create all Logins, Server Roles, DB Users and DB roles on a SQL Server.
2016-11-02 (first published: 2013-10-31)