Query Data Store Size Cleanup Retention

SQL Server’s Query Store introduced in SQL Server azure and SQL Server 2016 provides you with insight on query plan choice and performance. It simplifies performance troubleshooting by helping you quickly find performance differences caused by query plan changes. Once you enabled the Query Store for the database you can configure some Query Store settings,…

0

Set your PowerShell session to automatically log into Azure

I’ve been working in Azure for a while and find it quite frustrating that every time I launched up PowerShell ISE I needed to first log into Azure to get things started.  I knew back in the classic days you could download your Azure profile and load that into PowerShell to save you having to log…

3

SQL Server 2016 HA Series Part 1 – 3 Auto Failover Targets

This series is intended to provide a short focused write up on some of the key new SQL Server 2016 HA features. Got questions?  Stick them in the comments below and we will do our best to answer them!   Part 1 – 3 Auto Failover Targets   With SQL Server 2016 we are enabling…

0

Query Store – Settings and Limits

SQL Server 2016 and SQL Azure represent the biggest leap forward in Microsoft data platform history with features that increase performance, simplify management, and transform your data into actionable insights—all on a database that has the least vulnerabilities of any major platform. For those of us interested in the improvements made to the core engine,…


Database Owner sa and TRUSTWORTHY set to ON – Be Careful!

While working with a customer we discovered a potential vulnerability when having database owners set to sa and TRUSTWORTHY set to on for a database, so here’s a quick post showing how this is achieved so you can better understand it and hopefully avoid this scenario. The setup             Now if…

1

How To: Use the Azure Key Vault to Manage the Key for a TDE enabled Database

There are many posts available showing the steps to create an Azure Key Vault and to use it for TDE, but I’ve not found a good post which helps detail the end to end steps required to do this “smoothly” – so here goes…   In this post I’ll go through: Creating the “custom” application…

0

Using ‘R’ Services within SQL Server 2016

 Using ‘R’ Services Within SQL Server 2016 ‘R’ Services in SQL Server 2016 is a new technology within the SQL Server suite. This is an Enterprise feature allowing data scientists to explore and model data directly against the database, thereby minimising data movement and potentially stale data.   Enabling ‘R’ services requires the selection of…


Log Ship SSISDB in SQL Server 2012

Recently I’ve been helping out on an SSIS consolidation project and was asked to help understand how to make the SSISDB highly available. There were a few challenges on the platform we were working on such as no SAN replication, 2 separate WSFCs.  Ideally we would want to put the SSISDB in an availability group,…

0

Incremental Statistics and Trace Flag 2371 in SQL 2014

Over the last few days I’ve been asked a few times if trace flag 2371 works in SQL2014 with Incremental Statistics.  I wasn’t too sure so I decided to check test it and see for myself. What is Trace Flag 2371? TF 2371 alters the behavior of auto update statistics so that it triggers at…

1

Incremental statistics … How to Update Statistics on 100TB Database

I really like the idea of Incremental Statistics and what it can offer customers, specifically around reduced maintenance times and I’ve been trying to find a real life example of how a customer has used this feature to help them manage super huge databases. I was fortunate enough that one of our Brazilian colleagues has…

4