<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Posts by Devin Knight

Preparing a Technical Session Part 1: Picking a Topic

Posted Jun 30, 2015 by Devin Knight

So you’ve decided or perhaps were told to do a technical presentation. If this is something that’s new for you, then you may be going through a variety of emotions. You may start feeling excited in anticipation of the event, but often that quickly that changes to anxiety as you realize the amount ofwork ahead of you. As an experienced technical presenter, I understand what you're going through and the challenges you'll face throughout the process. 

Creating a SQL 2016 CTP2 Virtual Machine in Azure

Posted Jun 17, 2015 by Devin Knight

With the CTP2 of SQL Server 2016 now released, you may be eager to try it out. One of the best ways to do this in my opinion is to set it up on a virtual machine. You could certainly do this with VMWare or Hyper-V but my new preference for creating VMs is Azure.

Power BI with Azure SQL Database

Posted May 28, 2015 by Devin Knight

**Information is current as of 5/21/2015**

Recently Azure SQL Database was added as a new connection to the Power BI Preview. Read the notes about how it can be used here. The things I found especially worth noting were:

Power Query – Controlling M Query Functions with User Driven Parameters

Posted Apr 08, 2015 by Devin Knight

Have you ever had a user run a query against one of your largest tables only for them to immediately filter the results in Excel to show the last years worth of data? All of that data brought across your network and then immediately filtered out. Or maybe Excel just can handle the amount of unfiltered data they’re trying to return.

Optimizing Power BI Q&A with Synonyms & Phrasing Using Cloud Modeling

Posted Oct 02, 2014 by Devin Knight

If you’ve have used or even just seen a demo of Power BI Q&A you’ve likely seen there’s great potential in the feature for even low-tech user. I usually say, “If the user knows how to use a search engine then they can interact with Q&A.” You can read the basics of how Power BI Q&A works from my previous post here.

While having this capability is great it can take some fine tuning to perfect for users interacting with it. Power BI provides you with the ability to now optimize your models for Q&A and it can all be done directly from the Power BI site with what Microsoft is callingCloud Modeling.

Writing Parametrized MDX for Reporting Services

Posted Aug 15, 2014 by Devin Knight

By: Devin Knight

Click here to view Devin's blog.

Writing MDX inside of Reporting Services has been the nemesis for many report writers for far too long.  If all you need is the Query Designer to create a drag and drop datasets then it’s a piece of cake, but have you ever wondered what’s going on with all the MDX that the Query Designer creates.  Or how about how do the parameters work that it creates inside MDX.  I’ve heard many report writers that use Analysis Services as a data source (including myself) say it is too difficult to create parameters and that’s why they use the Query Designer.

Using PowerShell to Build Your Azure VM Environment

Posted Jul 07, 2014 by Devin Knight


By: Devin Knight

Subscribe to Blog Updates