Understanding data security in cloned databases created using DBCC CLONEDATABASE

DBCC CLONEDATABASE feature was first introduced in SQL Server with SQL Server 2014 SP2 and was later added to SQL Server 2016 with SP1. The primary design goal for DBCC CLONEDATABASE which the SQL Product team had in mind is to provide mechanism to create fast, minimally invasive and transaction ally consistent database clones, useful…


Easy way to get statistics histogram programmatically

Statistics being the building blocks on which the Query Optimizer reasons to compile a good enough plan to resolve queries, it’s very common that anyone doing query performance troubleshooting needs to use DBCC SHOW_STATISTICS to understand how statistics are being used, and how accurately they represent data distribution. Let’s see how to use this. Take…


Columnstore Index – How to Estimate Compression Savings

SQL product team has made significant improvements in columnstore index functionality, supportability and performance during SQL Server 2016 based on the feedback from customers. Please refer to  List of Blogs  for all blogs published by SQL Tiger Team on columnstore index. Issue When SQL Server team released ROW and PAGE compression in SQL Server 2008,…

2

Columnstore Index – List of blogs on columnstore index published by SQL Server Product Team

SQL product team has made significant improvements in functionality, supportability and performance of columnstore indexes during SQL Server 2016. These improvements were prioritized based on the feedback by customer who had used columnstore index functionality in prior releases. SQL Server product team has created a large set of blogs across multiple columnstore index scenarios. This blog consolidates the…

1

Released: Data Migration Assistant (DMA) v3.1

Overview Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It also allows you to not only move your schema, data, but also uncontained objects…


SQL Server vNext Management Pack Demo

We recently released CTP2 for SQL Server vNext Management Pack that can be used to monitor SQL Server vNext versions both on Linux and Windows. We are introducing new monitoring modes in the vNext MP. In addition to the standard agent monitoring where you have a SCOM agent on the server you are monitoring, you…

1