Distributed transactions are one of the more powerful and important functions within SQL Server. A distributed transaction is just like any other transaction within the SQL Server database, with a ...

Delayed durability was announced late in the SQL Server 2014 development cycle, but offers something that many SQL Server professionals have wanted for years—the ability to disable transaction logging ...

I'm trying to recover an earlier version of a database from a tape. I've got the bak file and all of the TRNs in a folder on a different server (wanted to restore it to our testlab sql server). From ...

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

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

In Exchange Server, transaction logs act as a buffer storage between the user, memory, and database. Transaction logs are generated constantly and purged after a successful backup of the database. If ...