Muthusamy Anantha Kumar

Learn how to use the SQL Server 2008 catalog view and dynamic management view to access the audit details of existing server and database level audits. Previous articles have illustrated the Auditing feature of SQL Server, namely creating a server level audit, database level audit and granular level database level audit. This article illustrates how […]

Learn how to create a database level audit at a granular level and retrieve the audit records in this 9-step tutorial. "Auditing made easy by Microsoft SQL Server 2008" illustrated how to create, and test a database level audit, as well as how to retrieve the audit records. Now we move on to creating a […]

MAK shows us how easy it is to create a database level audit, test the audit and retrieve the audit records in Microsoft SQL Server 2008.

It is one of the major tasks of the Microsoft SQL Server database administrator to enable auditing on all of the servers, secure the data collected and extract the data from those audits for the internal and external auditors. Auditing is very important to track and log events. It provides data for many legal compliance […]

Database administrators often script the schema of a table and generate stored procedures from an existing table and stored procedure respectively. In SQL Server 2008, Microsoft added a new option in scripting: scripting data from a table. This article illustrates how to use the "Generate Script option" to script out the table data and store […]

Active Directory Service Interfaces, also known as ADSI, is a set of COM interfaces used to access the directory services to retrieve data. Though it is predominantly used by network administrators and system administrators, there are situations where SQL Server Database administrators or the application that uses SQL Server as the backend needs to get […]

Database administrators are often faced with a situation where business users ask them to recover a table from the previous night after an application has deleted an entire table or partial table. Imagine you have a 1TB database backup. It would take the entire day to restore the database and then get to the table. […]

Open DBDiff 1.0 is the utility provided by Microsoft via CodePlex. You may have used the Open DBDiff utility for SQL Server 2005 before. DBDiff utility compares two databases and generates a script that could be used to synchronize two databases. The Open DBDiff utility is in beta version 8. This article is going to […]

Part 1 of this article series illustrated the use of the "Create Database" statement "For Attach" and "for ATTACH_REBUILD_LOG" for a single .MDF file and single .LDF file. Part 2 illustrated how to handle multiple .MDF files and .LDF files when attaching the database. Part 3 of the series illustrates how to rebuild the log […]