Auditing

Audit Users logging in using "sa" or service accounts

  • Script

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: )

685 reads

Azure SQL Database Auditing

  • Article

While a diminished level of control is certainly a factor to consider when contemplating migration of on-premises systems to Microsoft Azure, especially when dealing with PaaS resources such as Azure SQL Database, you have a range of techniques at your disposal that allow you to control and monitor both the status of and access to your Azure-resident services. One of these techniques is SQL Database auditing.

2015-01-22

9,981 reads

Blogs

SQL Server Quick Tips

By

Earlier this year I made a series of videos that were played before the...

The 2019 State of DevOps Report–Webinar

By

Tomorrow I get to chat with another giant in the world of DevOps: Jez...

An Effective Solution to Resolve SQL Database Corruption

By

I am a SQL Administrator and today I will share my experience about an...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

dsgsaf

By safaswf

sagfdsagh

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers