The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

In SQL Server Management Studio (SSMS), you can see the SQL Server database state. Alternatively, you can use T-SQL commands to verify your database status. You can use the DATABASEPROPERTYEX function ...

There’s some good news for IT managers deploying Windows Server 2008: Backup and Restore has been reworked in this edition to leverage the Volume Shadow Copy Service (VSS) and block-level transfers ...

One of the interesting new features in SQL Server 2008 is Change Data Capture. I wrote about Change Tracking in a previous blog entry. That will track the what, when and who but will not tell you ...

New BI and reporting features in SQL Server 2008 R2 hit the mark, but other additions leave SQL Server shops wanting more With Microsoft SQL Server 2008 R2, Microsoft begins to fully realize its ...

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...

In SQL Server 2005, Microsoft introduced the Upgrade Advisor. This was a great idea to be able to analyze your current SQL Server in a safe environment and start the planning process of an important ...

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...

Microsoft announced today that SQL Server 2008 R2 is released to manufacturing just 20 months after SQL Server 2008, the platform on which it is built. SQL Server 2008 R2 (codenamed Kilimanjaro) ...