Auditing DDL Actions

Failed and Successful Login Auditing Using xp_readerrorlog

Script uses undocumented extended stored procedure xp_readerrorlog to find failed logins (grouped) and last successful login

Users , Roles and Logins

Useful script in cases where auditors would like to know roles for each user in each database of an instance as well as the status of associated logins.

Azure SQL Database Auditing

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.

Last Accessed Datetime for table - Easiest way

This function is used to get the complete table lists are particular table and its last access datetime.

How to Audit Login Changes on a SQL Server

I've been charged with coming up with a quick solution to audit login changes on my SQL Servers. However, there's no budget so I'm going to have to come up with basic scripts and the like to do the work. Is this tip we cover a solution for you to audit login changes.

What, when and who? Auditing 101 - Part 3

Who messed around with my database? Auditing 101. In this article we will take a look at another technique available in SQL 2008 and higher. This new technique is SQL Audit.

What, When and who? Auditing 101

In this article we will take a look at one of the new technology that was introduced in SQL Server 2008 for Auditing.

Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 3

Part 3 of the series on using MAP 5.0 looks at Software Usage Tracker audit mecanism, as well as migrating and uninstalling the MAP database.

Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 2

Part 2 of the series on using MAP 5.0 looks at using the toolkit to inventory servers, preparing audit reports and server virtualization planning.