sqlsatkey

More SQL Saturday Precon News(Real-time Dashboards)!!!!

As you read in my earlier post, I am delivering a couple of precons in Tampa, FL and Richmond, VA.  Well, I just found out that I will be delivering the same session in Houston, TX at their SQL Saturday.  Bring your laptop, grab a cup of coffee and get ready to learn.  You can […]

image.png

Creating KPIs in SQL Reporting Services

In this blog I will explain how to create a Key Performance Indicatory (KPI) in SQL Reporting Services 2016.  Let’s get started. The first step is ensuring that you install the latest CTP for SQL Server 2016.  After that, you need to create a dataset.  Datasets can be created using Report Builder or SQL Server […]

SSRSandRLS

SQL Server 2016 Row-level Security and SSRS a perfect match

In this blog I will explain and demonstrate how to leverage a new feature in SQL Server 2016, Row Level Security (RLS) with SSRS.  Detailed steps including the TSQL script and SSRS project is provided at the end of this post.  To get started, you need to setup RLS.  In this example I will use […]