Deconstructing Extended Event XML

In a recent engagement, I had need of an Extended Event to gather range scans on my target instance. The overall premise was to determine which queries were driving the large number of range_scans being reported by a recent health check. The target instance was a SQL 2008 R2 SP3 build. So… lets create an…


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…

1