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

SQL with Dustin Ryan

Dustin Ryan is a Data Platform Solution Architect on the Education Specialist Team Unit at Microsoft. Dustin has worked in the business intelligence and data warehousing field since 2008, has spoken at community events such as Code Camp, SQL Saturday, SQL Rally, and PASS Summit, and has a wide range of experience using the Microsoft business intelligence stack of products across multiple industries. Prior to his time at Microsoft, Dustin worked as a business intelligence consultant and trainer for Pragmatic Works, a Microsoft partner. Dustin is also an author, contributor and technical editor of books such as Applied Microsoft Business Intelligence, Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX, and others. You can learn more about Dustin at http://SQLDusty.com.

Making Sense of the Power BI Ecosystem Presentation Materials

I just wrapped up my first presentation on Making Sense of the Power BI Ecosystem at SQL Saturday #755 in Davie, Florida at Nova Southeastern University. The room was full and unfortunately people had to stand or sit in the back, but the audience was great and we had lots… Read more

0 comments, 177 reads

Posted in SQL with Dustin Ryan on 9 June 2018

Monitoring and Tuning Azure SQL Database at SQL Saturday Jacksonville and 24 Hours of Pass

I’m speaking at two upcoming events that I wanted to share with you! My topic is Monitoring and Tuning Azure SQL Database. Being able to monitor and tune the performance of your database is an important part of any database professional’s job. Azure introduces a host of new tools and… Read more

0 comments, 174 reads

Posted in SQL with Dustin Ryan on 20 April 2018

Converting a Power BI Desktop File from Import to Live Query

A customer of mine is in the midst of a proof of concept using SQL Server and Power BI. During the POC, all the modeling was done in Power BI Desktop. Now that the POC is coming to the next phase, the customer is ready to move the Power BI… Read more

6 comments, 639 reads

Posted in SQL with Dustin Ryan on 30 January 2018

2017 Year in Review for SQLDusty.com

2017 was an awesome year for SQLDusty.com! Thank you to all of the readers and visitors that stopped by to leave a comment or share a blog post on social media. I appreciate all of you! But I also thought I’d share some interesting stats from the previous year: Read more

0 comments, 241 reads

Posted in SQL with Dustin Ryan on 29 January 2018

Creating a Knowledge Base Chat Bot w/ Azure Bot Service

A while back you may have caught my blog post introducing the Power BI Chat Bot 9000. Since posting that blog, I’ve received a lot of requests on the steps required to build the bot. The good new is that its super easy and really only take a few… Read more

3 comments, 1,118 reads

Posted in SQL with Dustin Ryan on 12 December 2017

Making Sense of Data Migration Assistant Assessments with Power BI

The Data Migration Assistant is a great tool developed to assess your SQL Server environment for a migration to a modern SQL Server platform such as SQL Server 2017 or Azure SQL Database. If you’re assessing a single SQL Server with only a few databases, reading the exported results (which… Read more

6 comments, 282 reads

Posted in SQL with Dustin Ryan on 6 December 2017

Setting Up a Drillthrough Action in your Power BI Report

At some point this weekend, the Microsoft Power BI folks turned on the drill-through feature in the Power BI service. Then the following week, the September release of Power BI Desktop included the new drill-through action feature. This is the same drill-through feature that demonstrated during day 1 of the… Read more

24 comments, 693 reads

Posted in SQL with Dustin Ryan on 3 September 2017

Preparing for Microsoft Certification Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI

Late last month Microsoft released the certification exam for Power BI, 70-778: Analyzing and Visualizing Data with Microsoft Power BI. The exam is currently in beta and will likely remain that way for the next eight to twelve weeks. If you were lucky enough to snag one of the… Read more

18 comments, 478 reads

Posted in SQL with Dustin Ryan on 23 August 2017

Power BI FAQ Chat Bot 9000 lives!

So I’ve been working on a fun little project over the past couple weeks. A lot of my customers have questions related to Power BI and I spend a lot of my time answering those questions. So I said to myself, “Self, why don’t you build a chat bot that… Read more

7 comments, 339 reads

Posted in SQL with Dustin Ryan on 18 August 2017

Building Your Brand and Becoming a Thought Leader Session Materials

Thank you to everyone that attending my session today at SQL Saturday #649 in Jacksonville, Florida! It was a packed room with over 70 people attending my session and the audience was lively! We had lots of great questions and tons of awesome interaction! If you want to download my… Read more

2 comments, 329 reads

Posted in SQL with Dustin Ryan on 12 August 2017

What-If Analysis in Power BI Desktop

One of the most talked about features previewed during the Microsoft Data Insights Summit in the previous June was the What-If Analysis capabilities. Today, this capability was finally released as part of the August update to Power BI Desktop.

New to Power BI? Start here!

The What If Parameter… Read more

2 comments, 738 reads

Posted in SQL with Dustin Ryan on 11 August 2017

Power BI NFL Football Stats Comparisons and Analysis Report is now available!

For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power BI reports featuring player statistics. This year is no different. This year I’m finally able to release my NFL Football Stats, Comparisons, and Analysis reports featuring the stats for players… Read more

10 comments, 2,520 reads

Posted in SQL with Dustin Ryan on 28 July 2017

Power BI NFL Football Stats Comparisons and Analysis Report is now available!

For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power BI reports featuring player statistics. This year is no different. This year I’m finally able to release my NFL Football Stats, Comparisons, and Analysis reports featuring the stats for players… Read more

6 comments, 94 reads

Posted in SQL with Dustin Ryan on 28 July 2017

How to Automate Processing of Azure Analysis Services Models

I’ve been working on a proof of concept for a customer that involved using Azure Analysis Services as a cache for some data in an Azure Data Warehouse instance. One of the things I’ve been working on is scheduling the automatic processing of the Azure AS database. I did find… Read more

10 comments, 176 reads

Posted in SQL with Dustin Ryan on 21 June 2017

How to Automate Processing of Azure Analysis Services Models

I’ve been working on a proof of concept for a customer that involved using Azure Analysis Services as a cache for some data in an Azure Data Warehouse instance. One of the things I’ve been working on is scheduling the automatic processing of the Azure AS database. I did find… Read more

9 comments, 1,019 reads

Posted in SQL with Dustin Ryan on 21 June 2017

Microsoft Data Insights Summit Day 2 Recap: Timeline Storyteller, Future of Power BI Desktop, and Freakonomics

The theme of day 2 of the Microsoft Data Insights Summit was sessions, sessions, sessions! There were a ton of different sessions for attendees and for us to watch! In total, there are 75 different videos between the keynotes and the individual sessions posted on the Microsoft Power BI YouTube… Read more

6 comments, 1,763 reads

Posted in SQL with Dustin Ryan on 15 June 2017

Microsoft Data Insights Summit Day 2 Recap: Timeline Storyteller, Future of Power BI Desktop, and Freakonomics

The theme of day 2 of the Microsoft Data Insights Summit was sessions, sessions, sessions! There were a ton of different sessions for attendees and for us to watch! In total, there are 75 different videos between the keynotes and the individual sessions posted on the Microsoft Power BI YouTube… Read more

6 comments, 104 reads

Posted in SQL with Dustin Ryan on 15 June 2017

Microsoft Data Insights Summit Day 1 Recap: Power BI Visio & PowerApps Integration, Custom Drill Through Actions, Book Marks, What If Analysis, & Data Insights

If you were at the Microsoft Data Insights Summit or were watching the live stream of the keynote, then you know that yesterday was a great day for Power BI! There were numerous announcements regarding new features, capabilities, and integrations coming to Power BI (If you missed it, you can… Read more

9 comments, 98 reads

Posted in SQL with Dustin Ryan on 13 June 2017

Microsoft Data Insights Summit Day 1 Recap: Power BI Visio & PowerApps Integration, Custom Drill Through Actions, Book Marks, What If Analysis, & Data Insights

If you were at the Microsoft Data Insights Summit or were watching the live stream of the keynote, then you know that yesterday was a great day for Power BI! There were numerous announcements regarding new features, capabilities, and integrations coming to Power BI (If you missed it, you can… Read more

7 comments, 2,164 reads

Posted in SQL with Dustin Ryan on 13 June 2017

Deploying to Power BI Premium

Obviously the big news of the day is the announcement for general availability of Power BI Premium! And if you were at or you watched the Microsoft Data Insights Summit you saw that announcement. But early last month on May 3rd, Microsoft announced Power BI Premium, which allows you… Read more

1 comments, 429 reads

Posted in SQL with Dustin Ryan on 12 June 2017

Older posts