Tag: sql server 2016

  • SQL Server 2016 – Identifying Tables to Stretch to Azure Cloud

    SQL Server 2016 – Identifying Tables to Stretch to Azure Cloud

    Yesterday I covered what’s strecthing a database to cloud. Today I’m going to cover how to identify the tables which can stretch to Cloud. In most of the cases you knew which table we can move however if you are not sure when one then you can make use of this tool. I’m going to…

  • SQL Server 2016 – What’s Stretch Database

    SQL Server 2016 – What’s Stretch Database

    One of the new feature that’s going to accompany in SQL Server 2016. There is a significant improvement in the hardware sector moving into SSD, flash disk etc which increases the cost of hardware. Holding all the historical or archieve data in to this high performing disks is going to cost you more, assuming you…

  • SQL Server 2016 – Dynamic Data Masking

    SQL Server 2016 – Dynamic Data Masking

    One of the new feature that’s being developed with SQL Server 2016. If you are a DBA then you will like this feature very much. In the real world when you move the data from production to development or uat server we are supposed to obfuscate the data so that the developer wont see the…

  • SQL Server 2016 – Tempdb Configuration During Installation

    After couple of years I’m started playing around the pre release packages. Today I installed Windows Server 2016 Technical preview release 3 and SQL Server 2016 CTP 2.4 in my machine to play around the upcoming release.