Monthly Archives: April 2018

SQL Server database Backup and Restore strategies

One of the most important roles of a database administrator is to constantly protect the integrity of the databases and maintain the ability to recover quickly in case of a failure. In light of this, it’s critically important to have … Continue reading

Posted in Backup and Restore | Tagged , , | Leave a comment

Overview of SQL Server Backup Types

SQL Server backups, in itself, is a vast subject; so vast, there are multiple books written about them. In this article, however, we are going to focus on the types of backups that are available to us, and understand how … Continue reading

Posted in SQL | Tagged , , , , , , | Leave a comment

Understanding database recovery models in SQL Server

A recovery model is a database configuration option that determines the type of backup that one could perform and provides the ability to restore the data or recover it from a failure. The recovery model decides how the transaction log … Continue reading

Posted in SQL Server Backup | Tagged , , , , , | Leave a comment

SQL Server 2017 on Linux in the Azure portal

SQL Server 2017 now is considered as a hybrid database enterprise solution as it expands its market and is ported to other operating system platforms. It also includes mainstream support for Linux machines. The Cloud makes the life of administrator much easier, now … Continue reading

Posted in SQL Server 2017, SQL AZURE, SQL On Linux | Tagged , , | Leave a comment

Default and Custom Widgets in SQL Server Operations Studio

There are already a number of articles and blog posts that reveal the benefits of the SQL Operations Studio tool. The demand created across the software and the related tools are relatively unimaginable than ever before. The trend and growth will … Continue reading

Posted in SQL Ops Studio, Uncategorized | Tagged , , | Leave a comment