Auditing

Generic trigger for maintaining the Audit Log

  • Script

This trigger will work even if you don't have the primary key on any table. Mechanism to configure the primary key in config table has been provided. This can be very helpful to solve the system audit requirements without much efforts.

Disclaimer : Audit Log trigger has performance overhead. It’s meant for table which is not frequently updated, deleted or inserted. Please take precaution when creating the trigger on the table having too many columns.

2.33 (3)

2019-10-15 (first published: )

744 reads

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

912 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

Social: Going Along to Get Along

By

It’s the eve of the Fourth of July, when the Declaration of Independence is...

Daily Coping 3 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using Docker Volumes for SQL Server in Linux

By

No, not that kind of volume! Over the past couple of blog posts, I...

Read the latest Blogs

Forums

stored procedure to delete user and login

By SZ

I was trying these but it does not work: USE [MyDatabase] GO /****** Object:...

Managing Stress

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Managing Stress

Failover Cluster Instance Share

By Mike Scalise

Hi, I am using AlwaysOn Availability Groups in SQL Server 2016 with a primary...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers