sqlmvpnaveensir

Troubleshooting Log Shipping Issues in SQL Server

 What is Log Shipping? In SQL server, Log Shipping is a feature to automatically backup databases and transaction log files from a server (primary) database to a

Posted Published: June 16, 2016   By Naveen Sharma Read More
SQL Server 2016

SQL Server 2016 Developer Version Now Available for Download 

 The SQL Server 2016 is finally available now for download. Microsoft has released the latest version of SQL Server on 1 June 2016. To check out the

Posted Modified: July 12th, 2018   By Puran Kandpal Read More
DBCC CHECKDB

New T-SQL Features In SQL Server 2016 – Updated List

 Application upgrades are an important procedure in order to ensure the provision of updated technology. SQL Server 2016 version is currently available in the online market as

Posted Published: May 31, 2016   By Puran Kandpal Read More
New Release SQL 2016

Prepare For the First Public Preview of SQL Server 2016 On 1 June 2016

 Overview SQL Server is Microsoft’s crown jewel database product that has been in existence for more than a decade. It is the most sought after database solution

Posted Modified: February 23rd, 2017   By Andrew Jackson Read More
How to Rebuild Master Database

Rebuild Master Database in SQL Server Without Backup

  It has been observed that many SQL Server administrators, in fact majority of them, backup their user databases regularly, but turn a blind eye to the

Posted Modified: October 4th, 2018   By Puran Kandpal Read More
End Of Support For SQL Server 2005

What’s in Store for SQL Users after End of SQL Server 2005 Support?

 April 12, 2016 officially marked the end of support to Microsoft SQL Server 2005. Prior to this end-of-life, Microsoft will no longer be providing any feature updates,

Posted Published: May 6, 2016   By Andrew Jackson Read More
Restore Table From Backup

Procedure to Restore Table from SQL Backup

 Almost all the DBAs have gone through the phase once in their career when they had to restore a single table from SQL Server backup. Whilst it

Posted Modified: February 27th, 2018   By Naveen Sharma Read More
Norecovery

SQL Server Restore Database With Norecovery

 Overview In SQL Server, the process of copying data from a backup & applying logged transactions to the data rolling it forward to target recovery point is

Posted Modified: July 19th, 2016   By Andrew Jackson Read More
Always Encrypted in SQL Server 2016

Always Encrypted Feature in MS SQL Server 2016

 The latest release of SQL Server, i.e. version 2016 introduced with it a new method of data security. The measure offers to secure particular columns with encryption-based

Posted Modified: July 12th, 2018   By Naveen Sharma Read More
sql server backup corrupted

SQL Server Backup Detected Corruption In the Database Log

 Overview MS SQL Server is tricky business as far as the significance of database is concerned which is obvious in case of an RDBMS because of its

Posted Modified: July 11th, 2018   By Puran Kandpal Read More