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

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.

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

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

Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...

How to back up and restore MySQL/MariaDB data for a website Your email has been sent If you've never backed up your MySQL or MariaDB databases, now's the time. Jack Wallen shows you how to back up ...