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

A solid database backup plan is just as critical in the cloud as it is on-premise, but running SQL Server on Azure virtual machine introduces a few new issues. Presented by Datavail's Andy McDermid ...

In-Depth Laying the Groundwork for Microsoft SQL Server 2008 Redmond's new database server is a complex product often running mission-critical apps. You can't afford to not get it right. By Josh Jones ...

One configures SQL Server for high availability (HA) in anticipation of some event that will cause a critical application to go offline unexpectedly—a software glitch that causes an app to freeze or a ...

Now in SQL Server 2008, Transparent Data Encryption allows a DBA to encrypt an entire database without the need for any application code changes. In fact, all we need to do is set a database option ...

SQL Server 2008, aka “Katmai,” gives SQL Server shops plenty of reasons to get excited. The best SQL Server release to date, it sports more nice new features than you can count, and the improvements ...

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

eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More. Microsoft is banking on more than functionality to make ...