-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: February 2016

Refreshing KPI Data in SSRS 2016

Continuing my blog from last week, Creating KPIs in SQL Reporting Services, I am now going to explain how to configure scheduled data refresh for the KPI that was created in that blog post.

Prerequisites
1.  SQL Server Agent must be running
2  Credentials must be stored in the… Read more

1 comments, 3,461 reads

Posted in SQLDownSouth on 23 February 2016

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… Read more

0 comments, 1,115 reads

Posted in SQLDownSouth on 19 February 2016

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… Read more

12 comments, 5,776 reads

Posted in SQLDownSouth on 17 February 2016

Upcoming SQL Saturday Precon Sessions (Update!!!!)

Wow, Power BI is making a tidal wave in the BI industry.  New features are being released regularly and blog posts are flying across twitter.  How can you keep up?  Well, if you are in Tampa, FL or Richmond, VA join me in one of these two full day sessions… Read more

2 comments, 821 reads

Posted in SQLDownSouth on 8 February 2016

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.… Read more

2 comments, 4,975 reads

Posted in SQLDownSouth on 8 February 2016