Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).

Preparing a Technical Session Part 1: Picking a Topic

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 excited in anticipation of the event but quickly that changes to anxiety when you realize all the… Read more

0 comments, 3,721 reads

Posted in Devin Knight on 2 December 2014

PASS Summit 2014 in Review

I’m finally completely recovered from a great week in Seattle last week for PASS Summit.  Now that it’s back to the grind of regular work I thought I’d put together some thoughts and tell you about my experiences from the week. 

You may have read others blogs about their experiences… Read more

0 comments, 142 reads

Posted in Devin Knight on 11 November 2014

Creating a Reporting Services Subscription

Subscriptions are a great feature in Reporting Services that will run a report unattended and deliver it to users either by email or Windows File Share. Subscriptions can also be scheduled so if your end users need a report monthly you can automate the delivery process. The steps given in… Read more

0 comments, 6,014 reads

Posted in Devin Knight on 13 October 2014

Optimizing Power BI Q&A with Synonyms and Phrasing using Cloud Modeling

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… Read more

0 comments, 5,595 reads

Posted in Devin Knight on 1 October 2014

Analysis Services Partitions

Partitions are a great feature in Analysis Services that allow you to split measure groups in to separate physical files. All measure groups by default have one partition but by splitting that partition you will gain improved query and processing performance.

Partitions can be split in any way you see… Read more

0 comments, 6,057 reads

Posted in Devin Knight on 5 September 2014

Analysis Services Dynamic Security

Imagine you have a requirement to capture the user accounts that log into your cube and based on their username they will only be permitted to see specific data.  This can be accomplished by creating dynamic or table based security in Analysis Services which is much less difficult to setup… Read more

0 comments, 248 reads

Posted in Devin Knight on 3 September 2014

MDX Time Calculations Built to Scale

When creating time calculations in Analysis Services you may take several approaches. For people that have just begin learning SSAS they likely have spent several days writing calculations that return things like year to date, rolling twelve month, and period over period for every measure they have.

For the more… Read more

0 comments, 436 reads

Posted in Devin Knight on 14 August 2014

Writing Parametrized MDX for Reporting Services

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… Read more

0 comments, 7,527 reads

Posted in Devin Knight on 4 August 2014

Understanding Analysis Services Relationships using Dimension Usage

As a part of designing an Analysis Services cube you must define how each dimension is related to each measure group in your cube through the Dimension Usage tab.  The Dimension Usage tab is found when editing the cube in the cube designer.  The screenshot below shows dimensions on rows… Read more

0 comments, 551 reads

Posted in Devin Knight on 15 July 2014

Using PowerShell to Build your Azure VM Environment

In a previous post I wrote about Using a Hyper-V VHD in an Azure VM. Today I’d like to show you what my next steps were.  My goal with using Azure is to create an lab environment for student that fits the following needs:

  • Easy to create new virtual…

Read more

0 comments, 388 reads

Posted in Devin Knight on 23 June 2014

Reducing the Disk Size of a Hyper-V Virtual Machine

Have you ever created a Hyper-V virtual machine and later needed to change the size of the disk on the VM? When you initially create a virtual machine you provide a size for the virtual hard disk (as shown below).

It’s pretty straight forward to expand the size of this… Read more

0 comments, 1,383 reads

Posted in Devin Knight on 19 June 2014

Setting up Automation in Azure

As I’ve started digging deeper into using Azure the need to automate tasks (turn off all VMs, turn on all VMs, automatically resize all VMs, etc…) has becomes very apparent.  In April 2014 Microsoft announced the release of Microsoft Azure Automation to handle such operations. 

Activate Azure Automation

This new… Read more

0 comments, 1,421 reads

Posted in Devin Knight on 18 June 2014

Using a Hyper-V VHD in an Azure VM

I’m in the process of moving some my lab environments that I use for teaching SQL Server classes to Azure. I’m pretty new to the Azure infrastructure world but I thought I could share some of my lessons learned in doing this. My first post will walk you through moving… Read more

0 comments, 306 reads

Posted in Devin Knight on 6 June 2014

Power Pivot as the Core to your Power BI Solution

I’ve noticed a recent trend with many presentations and articles on Power BI and Excel functionality. Many of these presentations show how quickly you can take tools like Power Query to find and discover data and then quickly present it through tools like Power View and Power Map. These are… Read more

0 comments, 375 reads

Posted in Devin Knight on 3 June 2014

Power Query to HDFS – Remote Name Could Not Be Resolved

I wanted to share a quick resolution I had to a problem with connecting Power Query to data stored in HDFS.

Seems easy enough. Launch Excel and through Power Query select From Other Sources –> From Hadoop Files (HDFS)

Next you’re prompted to provide your Hadoop server name then click… Read more

0 comments, 1,025 reads

Posted in Devin Knight on 2 May 2014

Creating Power Map Reporting Solutions Recording and Q&A

I hope you were able to attend my free webinar on Creating Power Map Reporting Solutions on April 17 2014.  If you weren’t you can now watch the recording here.

Following each webinar I like to post a quick Q&A session for everything I was not able to answer in the allotted… Read more

0 comments, 278 reads

Posted in Devin Knight on 18 April 2014

Bringing Power BI Q&A to your Organization Recording and Q&A

I hope you were able to attend my free webinar on Bringing Power BI Q&A to your Organization on April 15 2014.  If you weren’t you can now watch the recording here.

Traditionally following a webinar I try to post a quick Q&A session for everything I was not able… Read more

0 comments, 314 reads

Posted in Devin Knight on 17 April 2014

Introduction to Power BI Recording and Q&A

I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on March 13, 2014. If you weren’t you can now download the recording and slides.

I usually like to post follow up questions and answer that I wasn’t able to address during the webinar. Here’s… Read more

0 comments, 290 reads

Posted in Devin Knight on 14 March 2014

Upcoming Webinar – Creating Power Map Reporting Solutions

Come join me for this webinar on 4/17/2014 at 11:00 AM EST

Creating Power Map Reporting Solutions

Excel 2013 with Office 365 brings many new features to the realm of Self-Service BI. There are now new ways to extract, model and present data all within Excel. One of these newest… Read more

0 comments, 161 reads

Posted in Devin Knight on 13 March 2014

Upcoming Webinar – Bringing Power BI Q&A to your Organization

Come join me for this webinar on 4/15/2014 at 11:00 AM EST

Bringing Power BI Q&A to your Organization

Q&A is an amazing new feature of Power BI that allows you to ask you data question. No longer do you have to write complex SQL queries to get results. Simply… Read more

0 comments, 189 reads

Posted in Devin Knight on 13 March 2014

Older posts