In the latest SQL Solution center articles, we wrote about SQL data recovery, SQL database auditing, and LDF files. Here is the aggregate report
Four techniques for recovering lost tables due to DROP Table operation – in this article we showed that recovery is possible, even if there is no database backup available, and described four techniques for recovering lost tables due to the DROP table operation. These techniques use SQL Server Management Studio, ApexSQL Diff, ApexSQL Log and ApexSQL Recover. The article provides a step by step instructions for each technique and points out their respective advantages and disadvantages
Tracking DDL changes in SQL Server – the ‘Trouble with Triggers’ – in this article we described two ways for tracking DDL changes in a SQL Server database. Proper setting of SQL triggers can provide a comprehensive way to audit DDL changes, but this requires knowledge of SQL scripting. On the other hand, ApexSQL Log relies on database transaction logs which already contain changes made to a SQL Server database
Track SQL Server security changes – in this article, we provided various security recommendations for SQL Server. There is a step by step guide how to add a new user with limited access and permissions. Setting security is the first step. Auditing security changes is equally important, as it provides information about changes which can help to determine whether system is exposed to risk. Auditing can be accomplished by ApexSQL Audit
How to meet requirements of HIPAA compliance as a part of a SQL Server audit – this article describes The Health Insurance Portability and Accountability Act (HIPAA) and how to monitor and report access to the confidential patient data to ensure compliance using ApexSQL Audit
Open LDF file and view LDF file content – in this article we wrote about LDF files. An LDF file contains information about database transactions that can be used to track, undo or redo changes in a database. Structure of an LDF file is complex and reading it is not simple. There are several ways to open an LDF file but ApexSQL Log provides additional functionality and usability advantages
