SQL Solution center round-up – July 5th, 2013

In the latest SQL Solution center articles we focused on SQL Server database auditing techniques and recovery options

Here is the aggregated summary for the past two weeks:

Auditing triggers in SQL Server databases – the article describes how to audit SQL Server databases using triggers to find out who did something, what and when. It’s not just about creating the triggers, but about storing the captured records as well. See how to create and manage SQL triggers manually or using ApexSQL Trigger

SQL Server database auditing techniques – check out data and schema changes that have occurred on a SQL Server database. See how to use SQL Server Auditing and SQL Server Extended Events, create SQL triggers manually or using ApexSQL Trigger, read SQL Server transaction logs using ApexSQL Log, or read SQL Server traces using SQL Profiler or ApexSQL Audit

Multiple SQL Server data recovery options – the article describes different SQL database recovery situations: how to restore a SQL database to a point in time; recover deleted Team Foundation Server (TFS) records using ApexSQL Log; recover deleted SQL data from SQL Server transaction logs using ApexSQL Recover; or retrieve deleted SQL data with ApexSQL Data Diff

Related posts:

  1. SQL Solution center round-up – February 15th, 2014 – SQL formatting, recovery of deleted images, SQL Server auditing, security, and compliance
  2. SQL Solution center round-up – June 21st, 2013
  3. SQL Solution center round-up – September 20th, 2013
  4. SQL Solution center round-up – October 18th, 2013 – SQL Server compliance with FERPA and Basel II, database recovery, and methods for auditing failed logins
  5. SQL Solution center round-up – August 8th, 2013
July 12, 2013