Scripts

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 […]

2019-07-04 (first published: )

835 reads

SQL Server System Audit Report

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 […]

3 (3)

2019-04-18

990 reads

Blogs

Our SQL Server 2019 Administration Inside Out Fun Author Survey

By

SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...

What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup

By

Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...

My home office setup

By

That aging hippie (he likes Apple products and has a goatee) known as Brent...

Read the latest Blogs

Forums

Recover data log loss

By norleeza23

Hi. I would like to know is it possible to recover data log table...

Execute business rule runtime

By CoolMoon

Hi I have set of hundreds of business rules that I need to executed...

Switching Database context in transaction

By Thomas Franz

Comments posted to this topic are about the item Switching Database context in transaction

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers