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 ...

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 ...

SQL Server transaction logs A transaction log is a sequential record of all changes made to the database while the actual data is contained in a separate file.

The restore features of Windows Server Backup in Windows Server 2008 are appealing, but let down by inflexible backup options and lack of support for Exchange Server and tape drives.

Using Extended Events Extended Events is a tracing feature built into the SQL Server database engine, starting with SQL Server 2008.

With Microsoft SQL Server 2008 R2, Microsoft begins to fully realize its vision of SQL Server as an information platform and not “just” a database.

Microsoft's SQL Server database software offers two easy-to-use functions, one of which encrypts data using a passphrase, the other decrypting it with the same passphrase.

Using Extended Events Extended Events is a tracing feature built into the SQL Server database engine, starting with SQL Server 2008.