SQL Server 2016 Row Level Security – A Practical Example

How can I use Row Level Security to control which users see certain data in my data table?   Here’s what I want to achieve. I want to create an SSRS report which multiple users from different teams can access.  The report will use the same underlying table for each user so I need to…

0

SQL Server 2016 HA Series Part 2 – SSIS and Availability Groups

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! SSIS and Availability Groups   Current challenges in SQL Server 2012 and 2014: SSISDB relies on…

0

Query Store: How it works? How to use it?

Part 1 “The SQL Server Query Store feature 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. “ msdn. If you want to know, how to enable it, you can find information here: https://msdn.microsoft.com/en-US/library/dn817826.aspx Once you enabled the…


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