Auditing

SQLServerCentral Article

Design your systems and processes for auditability

  • Article

I have worked in more than one regulated industry, and since the banking crisis of 2008, I have witnessed a sea change in the approach to regulation.  The UK Financial Services Authority (FSA) was seen to be a toothless tiger.  The UK government replaced the FSA with two separate bodies, each with its own more […]

5 (3)

2021-10-25

1,291 reads

Technical Article

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

1,510 reads

Technical Article

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

1,534 reads

Blogs

How to Calculate Compound Rate in Power BI

By

Recently I had an interesting use case where I had to a compound calculation...

Daily Coping 28 Sep 2022

By

Today’s coping tip is let go of other people’s expectations of you. I think...

SQL Server In Place Upgrades

By

Good morning dear blog reader. Today’s episode is fresh from a great weekend with...

Read the latest Blogs

Forums

sp_send_dbmail using HTML with templates and injecting datasets

By aaron.reese

Morning all,  Looking for any advice or thoughts on how to achieve the impossible...

Forms Authentication Setup for SSRS in 2019

By mohan.bndri

As I was looking the authentication set up which come as default when we...

SQL inplace upgrade from sqlexpress to standard edition in VM Google cloud

By RK2012

Hello Team, planning to do SQL in place upgrade from sql2016express to sql2016 standard...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers