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