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

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

There could be many reasons why you need to restore a database. Let’s look at some common reasons. The server has been re-installed, after failure. The database gets corrupted or is not mounting.

The next version of Microsoft’s relational database management system (RDMS) promises to bring immense performance gains to online transactional processing systems. SQL Server 2014 will come with a ...

In this Microsoft SQL Server and JDBC tutorial, you'll learn how to connect to a Microsoft SQL Server in Java using JDBC. The steps are relatively straightforward: Each database is different, so ...