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)
835 reads
Script database and object level permissions for all database users
2019-07-03 (first published: 2019-06-10)
1,054 reads
We decided to build a quick worker thread alert so we know when we are near the limits.
2019-05-02
834 reads
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-05-01
806 reads
2019-04-30
1,451 reads
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-04-25 (first published: 2019-04-18)
621 reads
SQL Server System Audit Report Rudy Panigas, 2018-05-25 (first published: 2016-02-02) With every technology, security is in the forefront of the minds of professionals around the world. Ensuring that your SQL Server is secure is the job of every Database Administrator (DBA). The DBA(s) needs to configure the system to minimize the “attack surface” (reducing […]
2019-04-18
990 reads
2019-04-16 (first published: 2019-04-12)
2,368 reads
Function that converts AD UserAccountControl number to details text
2019-04-15 (first published: 2019-04-12)
398 reads
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
2019-03-15 (first published: 2016-05-17)
1,504 reads
By Will Assaf
SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...
By Will Assaf
Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...
That aging hippie (he likes Apple products and has a goatee) known as Brent...
Hi. I would like to know is it possible to recover data log table...
Hi I have set of hundreds of business rules that I need to executed...
Comments posted to this topic are about the item Switching Database context in transaction
Ask SSC