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

Archives: June 2016

What do you want to learn about SSRS 2016 at PASS Global Summit?

I’m thrilled to have been selected to deliver a session at the 2016 PASS Global Summit titled “Reporting Services 2016: The Force Awakens”.  I’ve been speaking at SQL Saturdays and have done some training on SSRS 2016 this year but this new session has yet to be finished SO…. please…

Read more

8 comments, 1,112 reads

Posted in SQL Server BI Blog on 24 June 2016

Using Power BI with Enterprise, On-premises Data

I just finished posting a 4-part series demonstrating how to use Power BI with on-premises data.  The running time for all four parts is about 44 minutes.  I cover using the Power BI Enterprise Gateway to connect published Power BI reports to on-premises data sources:  SQL Server database connected with…

Read more

2 comments, 658 reads

Posted in SQL Server BI Blog on 19 June 2016

Row-level Security Just Got Better: Passing Report Credentials to Analysis Services in SQL Server 2016

A new ground-breaking feature in SQL Server 2016 allows report user context to be passed through shared data sources, enabling role-based, row-level security.  This feature doesn’t require complex administration configurations, service principal delegation, Kerberos, Claims/Windows Token conversion or impersonation.  You may not be as excited as I am about this…

Read more

9 comments, 1,455 reads

Posted in SQL Server BI Blog on 13 June 2016