Tag Archives: sql dba

New Features Added in SQL Server

New Features Added in SQL Server This post helps you in quickly reviewing the “New Features Added in SQL Server” from 2008 to 2016. The most common interview question is “What are the new features added in SQL Server XXXX?” … Continue reading

Posted in Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , | 8 Comments

Backup Compression in SQL Server 2008

Backup Compression in SQL Server 2008 Backup Compression in SQL Server 2008  is really a amazing feature. Earlier we used to use litespeed to compress the backup. As we are dealing with the backups that are in 2 GB to … Continue reading

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

Database Restore Progress in SQL Server

Database Restore Progress in SQL Server This post will takes you through you monitoring Database Restore Progress in SQL Server. Here we have an useful script which can help us in the process of restoration of databases. As we are … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | 1 Comment