databasejournal.com databasejournal.com

New Date,Logical Functions in SQL Server 2012

As we all know, Microsoft officially released SQL Server 2012 RC0. You can register and download the binaries from http://www.microsoft.com/sql. As with every new release, Microsoft added more features and enhancements, improvements not only to the SQL Server database engine but also to other features in SQL Server. Some of the improvements that Microsoft did are on Transaction SQL. In this article, I am going to illustrate some of...

databasejournal.com databasejournal.com

Auditing made easy by 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 requirements, such as Sarbanes Oxley, SAS 70, etc. In Microsoft SQL Server 2008, Microsoft made the life of a DBA...

databasejournal.com databasejournal.com

SQL Server Virtual Database from Idera

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. Idera has created a solution to this nightmare. After 12 years of waiting, finally, a third party tool vendor has...

databasejournal.com databasejournal.com

Rebuilding the log when attaching multiple .MDF files

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 when attaching multiple .MDF files. Now let's assume that we have the database,...

databasejournal.com databasejournal.com

Database Mirroring in SQL Server 2008

What is Database Mirroring? Database mirroring is the feature in SQL Server 2005 and SQL Server 2008 that provides a high availability solution for Databases. This feature can be enabled and used only on a database with Full recovery models. The database can be mirrored from one SQL Server instance to another SQL Server instance. The source instance is called Principal server; the target instance is called Mirrored server. We could...