October 2014 – Paul Turley's SQL Server BI Blog

PASS, SolidQ, SQL Server, SQL Syndication, SQLServerPedia, SSAS Administration, SSAS Design, SSRS Administration, SSRS Design, Tabular Models

SQL Server Upgrade Preconference at PASS Summit 2014

Paul TurleyOctober 21, 2014October 23, 2014

Please join my associates and I for an all-day SQL Server Upgrade workshop on November 3rd

If you are planning an upgrade to a newer version of SQL Server, you won’t want to miss this all-day, preconference workshop.

Join John Martin, Sr. Technology Evangelist from Microsoft, will spend the morning discussing migration planning from SQL Server 2005.

In the afternoon, SolidQ mentors Ron Talmage, Richard Waymire, Jim Miller and Paul Turley will talk about and demonstrate upgrading specific workloads (projects and features) from older product versions to newer product versions. We will introduce the comprehensive SQL Server 2014 Upgrade Whitepaper that we recently wrote for publication by Microsoft.

Microsoft BI Platform

BASIS Band is Almost a Great Device… Almost

Paul TurleyOctober 19, 2014October 23, 2014

I started shopping for a wearable fitness band several months ago. I looked at several and was most impressed with the BASIS Band concept. It was different because it combined a device that had advanced tracking capabilities with a cloud-based service that could be expanded and improved with only server-side upgrades. What a great business model, I thought. reading the forums, I could see that the BASIS customer service folks were very responsive to feedback and feature requests. A lot of people were also very excited to see this service expand and were eagerly asking for more features and capabilities that could be added to the back-end service or software.

BI Industry, BI Projects, Business Analytics, DAX, Microsoft BI Platform, Power BI, PowerPivot, Self-service BI, SQL Server Pro Magazine, SQL Syndication, SQLServerPedia, Tabular Models

Adding and Displaying Comments to Power Pivot Results in an Excel Pivot Table

Paul TurleyOctober 5, 2014October 7, 2014

Requirement: Allow users to enter comments after they review results from a Power Pivot model and then show the comment text in the Pivot Table report results. Here’s a quick example of the final result. My example uses Flintstones characters in-place of employee or customer names and a simple measure value. After reviewing the results, the user moves to another worksheet and enters a comment for the date and person with an expiration date for the comment. After refreshing the report, each cell with a comment is indicated with a little “dog ear” and the comment is displayed by clicking the cell…

BI Industry, BI Projects, Business Analytics, Microsoft BI Platform, MVP Community, PASS, SolidQ, SQL Saturday, SQL Server, SQL Server Pro Magazine, SQL Syndication, SQLServerPedia

SQL Server MVP for a Sixth Year

Paul TurleyOctober 5, 2014October 5, 2014

Thank you to the Microsoft MVP Program for awarding me MVP for six years running! I love this program and…

Month: October 2014

SQL Server Upgrade Preconference at PASS Summit 2014

Like this:

BASIS Band is Almost a Great Device… Almost

Like this:

Adding and Displaying Comments to Power Pivot Results in an Excel Pivot Table

Like this:

SQL Server MVP for a Sixth Year

Like this:

SQL Server Upgrade Preconference at PASS Summit 2014

Share this:

Like this:

BASIS Band is Almost a Great Device… Almost

Share this:

Like this:

Adding and Displaying Comments to Power Pivot Results in an Excel Pivot Table

Share this:

Like this:

SQL Server MVP for a Sixth Year

Share this:

Like this: