SQL Server Database Recovery

Stretch Database – Basics about its working and Benefits

In this article we would explore the Stretch database feature present in Ms SQL Server in depth Amongst the range of new features launched with the 2016 edition of SQL Server, the Stretch Database comes across as a remarkable option, which offers the users a solution for dealing with extremely large databases. This feature provides a ‘Dynamic stretch’ for the warm data (active data) and the cold data (archived data), to be stretched to Microsoft Azure – a cloud based storage platform...

Read more »

Dynamic Data Masking – A Primer

In this article we will explore in depth the concept of Dynamic Data Masking in Ms SQL Server SQL Server 2016 helps in protecting sensitive data from being exposed to non- privileged users by masking the data; this is known as Dynamic Data Masking (DDM). It allows the user to simplify the design and coding of application security. DDM allows users to decide what amount of sensitive data should be revealed. This is done to limit unauthorized access to critical or sensitive data. DDM allows...

Read more »

A quick lowdown on query store feature in Ms SQL Server 2016

In this article we will introduce you to the query store feature present in Ms SQL Server SQL Server 2016 has come up with a jazzed up feature to store queries. The Query Store feature in SQL Server not only keeps a record of recently executed queries, query execution plans, query runtime execution statistics but also stores them for troubleshooting performance problems due to query plan changes. The feature allows the user to receive insights on query and complete performance of the...

Read more »