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)
650 reads
2019-04-16
699 reads
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)
394 reads
Generate Script from Logins of Sql Server to recreate in another instance
2015-08-25 (first published: 2015-08-10)
1,703 reads
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).
2015-04-14
7,318 reads
2014-05-14
2,204 reads
2014-03-28
1,855 reads
2014-03-26
2,063 reads
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)
2,639 reads
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)
8,110 reads
We spread my Fathers ashes over the past weekend. It was one of the...
Some 2019 tips for other SQLSat organizers from my last year as lead organizer...
One of the powerful aspects of Query Store is the ability to directly query...
Comments posted to this topic are about the item Let’s Start with Architecture
Comments posted to this topic are about the item Database Auditing
Comments posted to this topic are about the item Don't Get On This Page
Ask SSC