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
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
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: January 31st, 2019   By Puran Kandpal Read More
database mirroring setup check

Important Things to Consider When Setting Up Database Mirroring In SQL Server

When properly and fully configured, the mirroring system enables high availability of the database. However, when studied in detail a number of other factors are also associated

Posted Modified: May 13th, 2016   By Andrew Jackson Read More
Do Not Shrink Database Files

Why to Prevent Shrinking Data Files In SQL Server?

A few days earlier, we were approached by a client who had a SQL Server database of very large size and it was surpassing their disk space.

Posted Modified: February 22nd, 2019   By Puran Kandpal Read More
Dynamic Data Masking in SQL Server

How To Implement SQL Server Dynamic Data Masking?

SQL Server 2016 added a new data protection feature known as Data Masking in SQL Server. It allows user to limit the sensitive data by masking it

Posted Modified: July 12th, 2018   By Naveen Sharma Read More
SQL Server log shipping configuration

Step By Step Configuration of Log Shipping in SQL Server

What is SQL Server Log Shipping ? Log shipping in SQL Server provides a disaster recovery solution at the database level. A log-shipping configuration involves two or

Posted Modified: November 29th, 2018   By Andrew Jackson Read More
Preventing Accidental Update or Delete

Procedure For Preventing Accidental Update or Delete In a SQL Server Table

Overview The users of SQL Server database needs to make sure that their data is protected from any kind of silly mistakes that could lead to a

Posted Modified: May 4th, 2016   By Puran Kandpal Read More