Audit SQL Server Extended Stored Procedures Usage

In this article, we look at how to audit and monitor the use of SQL Server extended stored procedures in your database instance.

Auditing SQL Server – Part 4 – Database Configuration Audit

This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level hardware audits and SQL Server engine level audits. This section examines database configuration audits.

Auditing SQL Server – Part 3 – SQL Server Configuration Audit

This section gets into detailed SQL Server configuration details. This is less relevant in a cloud environment, but there are still items to confirm.

Auditing SQL Server – Part 2 – Hardware Audit

This is the second part of my series on auditing SQL Server. In the first part, I discussed basic server discovery and documentation. It covered some items to check at the hardware level and configuration items, but this section gets into more detailed hardware auditing details.

Who’s Changing the Table? Answers and Discussion

Your challenge for this week was to find out who keeps mangling the contents of the AboutMe column in the Stack Overflow database.

A New Audit

Simple script to de-identify data

An audit finding relating to production data, containing customer identifiable data, in a UAT environment, prompted this simple script, which completely scrambles data in such a way that the original value can not be reconstituted.

Capturing Data Changes

If you capture data changes with the OUTPUT clause, let us know today.

Design your systems and processes for auditability

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

Checking Up on Vendors

Being able to audit the actions others take on your systems is important to Steve, especially when working in the cloud.