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

T-SQL for Performance and Accuracy – Vern Rabe: A preconference essential for anyone using SQL Server

SQL Saturday Preconference: February 9th, 2018 in Redmond, WA Do you think you write T-SQL queries that perform well?  Think again.  I learn something important – and I mean career and life-altering important – when I attend one of Vern’s sessions on T-SQL optimization.  He taught me SQL Server a…

Read more

0 comments, 301 reads

Posted in SQL Server BI Blog on 11 January 2018

Interview with Guy In A Cube’s Adam Saxton and Patrick Leblanc

Since starting the Guy In A Cube series over three years ago, Adam Saxton has become the front man for Microsoft Business Intelligence feature announcements and Power BI how-to tutorials.  Joined by Patrick Leblanc last year, the Guy In a Cube series features over 200 short video tutorials with at…

Read more

0 comments, 262 reads

Posted in SQL Server BI Blog on 20 December 2017

Enterprise Analysis Services Development: Interview with Alberto Ferrari and Marco Russo

  Between sessions at the PASS Summit, I had the privilege of interviewing Alberto Ferrari and Marco Russo; SSAS Maestros and BI industry thought leaders. Alberto and Marco are revered as expert trainers and practitioners of SSAS and Power BI solutions. They are also well known for evangelizing best practices…

Read more

1 comments, 349 reads

Posted in SQL Server BI Blog on 3 December 2017

Power BI Hands-On Workshops in April, 2017

During the month of April, I will be delivering three full-day Power BI hands-On workshops.  Each of these events will be the Friday preceding these SQL Saturday events.  Seating is limited and many of these workshops tend to book-up.  Follow the links to register. Huntington Beach, Orange County, CA;  March…

Read more

1 comments, 307 reads

Posted in SQL Server BI Blog on 2 March 2017

Gartner Magic Quadrant for BI 2017 Top 3 Rankings

This is a different spin on the top three vendor rankings visualized in Power BI.  According to the placement of the chart elements in the “Visionary/Leader” quadrant, Microsoft leads Tableau by a little over 36% in the “Vision Completeness “ score and Tableau beat out Microsoft on the “Ability to…

Read more

2 comments, 730 reads

Posted in SQL Server BI Blog on 17 February 2017

Professional SSRS 2016 Book Preview Posts

This page is a table of contents for for several new and forthcoming posts.  I’m posting a series of excerpts for my Wrox Press book: Professional SQL Server 2016 Reporting Services and Mobile Reports.  Each of the posts is a condensed version of the material covered in a corresponding chapter…

Read more

16 comments, 454 reads

Posted in SQL Server BI Blog on 22 January 2017

Publish Power BI Reports to SSRS On-premise Preview Now Available

This just in from the Reporting Services product team: “Power BI reports in SQL Server Reporting Services: January 2017 Technical Preview now available”  This feature addition will allow Power BI reports to be published to a local SQL Server Reporting Services server, entirely-on-premises without using the Power BI cloud service.…

Read more

7 comments, 608 reads

Posted in SQL Server BI Blog on 17 January 2017

Power BI on-Premises Production Targeted for Mid 2017

NEWS FLASH: Power BI reports can be deployed to SQL Server Reporting Services web portal.  The production-ready release is targeted for mid 2017.  This is much sooner than most folks in the community were anticipating.  An installable technical preview is targeted for January of 2017.  This announcement was just made…

Read more

3 comments, 397 reads

Posted in SQL Server BI Blog on 16 December 2016

Analysis Services and Power BI: Time-travel, Space-warping and Teleportation

As I visit businesses, consulting clients and training classes, to teach data reporting and analytics; there is a recurring conversation.  It is one that I have had for eighteen years.  The audiences change and the technology implementations are a little different over time, but the essential conversation is still the…

Read more

1 comments, 1,484 reads

Posted in SQL Server BI Blog on 10 December 2016

Migrating reports between SSRS report servers simplified with new PowerShell commands

I recently needed to replicate all of the reports on one report server to a different server.  I started downloading each report one at a time to a file system folder, moving them to the other machine and then uploading each RDL file.  Needless to say, that’s a slow and…

Read more

7 comments, 926 reads

Posted in SQL Server BI Blog on 4 December 2016

Power BI On Premises Integration with Reporting Services Preview

Since the Reporting Services product team announced last year that it was their intention to provide an on premises deployment option for Power BI reports, there has been tremendous interest.  Despite their determination to provide clarity around their efforts , there has still been some speculation about how and when…

Read more

2 comments, 2,047 reads

Posted in SQL Server BI Blog on 19 November 2016

SQL Server 2016 SP1 is Now Available

In the Business Intelligence and reporting space, SQL Server 2016 was a big step forward.  Aside from significant relational engine improvements, Analysis Services Tabular matured considerably.  Components of Reporting Services were completely re-architected and several new features were added, which include modern HTML5 rendering for all browsers, the new web…

Read more

0 comments, 400 reads

Posted in SQL Server BI Blog on 16 November 2016

Business Analytics Day Jan 11, 2017 Chicago

I hope you can join me at the Chicago Microsoft Technology Center for the PASS Business Analytics Day, on Wednesday, January 11, 2017. The focus of this hands-on workshop is building business solutions with Power BI Desktop and the Power BI service.  We will cover both self-service and enterprise scenarios,…

Read more

1 comments, 384 reads

Posted in SQL Server BI Blog on 14 November 2016

Happy Birthday Power BI

Today marks the first anniversary of Power BI Desktop and the Power BI Service.  The effort to achieve this milestone and the on-going commitment of the teams responsible for this product is nothing short of phenomenal.  Earlier this week, I reached out to a few friends to join me in…

Read more

1 comments, 406 reads

Posted in SQL Server BI Blog on 24 July 2016

SSRS 2016 Book Nearly Done… My Brain is now Jell-O

(first excerpt from the upcoming book) “Professional SQL Server 2016 Reporting Services and Mobile Reports” from Wrox Press is content complete!  The book is well into the editing stage– still, another grueling phase of the publishing process, but there is light at the end of the proverbial tunnel.  What is…

Read more

6 comments, 462 reads

Posted in SQL Server BI Blog on 20 July 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,085 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, 622 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,418 reads

Posted in SQL Server BI Blog on 13 June 2016

Where are SQL Server 2016 Client Tools?

So, you just installed SQL Server 2016 and you’re pretty sure you chose the options to install the client tools and all the components you needed.  You look for SSMS and, what the heck?  it’s not there.  OMG, what have they done?! SSMS is Gone! Seriously, SQL Server Management Studio…

Read more

6 comments, 2,907 reads

Posted in SQL Server BI Blog on 27 May 2016

Power BI Application Embedding Releases Today

A few weeks ago, the Power BI team gave us the ability to freely embed Power BI reports, dashboards and other capabilities into a web frame for all the world to see.  The next natural step, you might think, would be a way to to securely embed selected Power BI…

Read more

1 comments, 486 reads

Posted in SQL Server BI Blog on 1 April 2016

Older posts