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).

Why do you attend sessions? – Survey Results

Several weeks ago I posted a quick survey on my blog that asked how you choose a session to attend when you have so many options at conferences.  Thought I’d share the results of the survey today. 

I don’t think there’s anything surprising about it.  Most people overwhelmingly responded that… Read more

0 comments, 523 reads

Posted in Devin Knight on 3 October 2012

Excel 2013 – Trouble Installing Silverlight for Power View

Last week during my 24 Hours of PASS session on Choosing a Reporting Platform I fielded a question that appeared multiple times during the Q&A so I thought it would be worth post.

When using Power View in Excel 2013 the first thing you may notice is a screen like… Read more

0 comments, 688 reads

Posted in Devin Knight on 26 September 2012

24 Hours of PASS

Tomorrow Brian Knight and I will kick off 24 hours of PASS with a session on Choosing a Microsoft Reporting Platform.  I hope you’re able to join use and indulge in the all day learnathon that PASS is putting on with great list of amazing speakers.

If you’ve never attended… Read more

0 comments, 634 reads

Posted in Devin Knight on 19 September 2012

Why do you attend sessions?

Many of you have attended sessions by technical speakers at conferences and mini-conferences like SQL Saturday, SQL Rally, 24 Hours of PASS, PASS Summit and many other non-PASS affiliated conference.

You all have different reasons for attending a particular session so I thought it would be interesting to take a… Read more

0 comments, 539 reads

Posted in Devin Knight on 12 September 2012

September 2012 Speaking Events

September is another busy month of speaking events for me and I thought I’d share them with you so maybe I can see you at one of the events.

Date: 09/08/2012

Group: SQL Saturday #167 Columbus, GA

Topic: Adapting Your ETL Solution to use SSIS 2012

With all the great… Read more

0 comments, 812 reads

Posted in Devin Knight on 29 August 2012

JSSUG Speaker Idol 2012 Review

Last Wednesday at Jacksonville SQL Server User Group (JSSUG) we held our annual Speaker Idol event.  Read more about what the events all about here.  The event was a success and the speakers all got some great feedback from our panel of experienced speakers (Eric WisdahlJorge… Read more

0 comments, 485 reads

Posted in Devin Knight on 21 August 2012

JSSUG Speaker Idol 2012

The Jacksonville SQL Server User Group (JSSUG) has always encouraged new talent to be added to the pool of local speakers.  That’s why tomorrow we will be hosting an annual event called Speaker Idol (I know the name isn’t very original don’t kill me!), which is for anyone that’s interested… Read more

0 comments, 616 reads

Posted in Devin Knight on 15 August 2012

Visio 2010 Forward Engineer Add-in

Somehow I missed this gem that’s been around for quite a while so I thought I would share it in case anyone else has yet to see it.  The Forward Engineer add-in is a really great open source project that allows Visio database diagrams you create to easily be converted… Read more

0 comments, 947 reads

Posted in Devin Knight on 8 August 2012

OLAP PivotTable Extensions Update

OLAP PivotTable Extensions is a really cool free add-in for Excel that’s been around for quite a while now.  It allows you to have some exposure to what’s going on under the covers (Among many other features) while you browse a cube using an Excel PivotTable. This weekend there has… Read more

0 comments, 878 reads

Posted in Devin Knight on 31 July 2012

SSRS – Using Lookup Function for Multiple Column Join

When SQL Server 2008 R2 was released several new Reporting Services expressions were made available that would help join multiple datasets together.  Those functions were the Lookup FunctionLookupSet Function and the MultiLookup Function.  My general recommendation for these function is not to use them when you have… Read more

0 comments, 1,795 reads

Posted in Devin Knight on 27 July 2012

Office 2013 Preview – Enabling PowerPivot in Excel

With the Office 2013 announcements today I was excited to download and get my hands on the tools.  Because this is still a customer preview we’re bound to find things here and there that aren’t functioning as expected when experimenting with the Office tools.

The things I had on my… Read more

0 comments, 2,140 reads

Posted in Devin Knight on 17 July 2012

Building Your First Power View Report

This has been reposted from a guest blog post I wrote on the Microsoft Business Intelligence team blog.

Fulfilling User Needs

Developing a Power View report has been touted as being so simple that within a handful of clicks you can add rather impressive elements, like effective visualizations, to… Read more

0 comments, 618 reads

Posted in Devin Knight on 16 July 2012

SQL Lunch #68 – Designing Your First Power View Report

Next week I will be speaking on designing your first Power View report for SQL Lunch.  Be sure to join me for the event and as always “No fluff, just stuff”.

Add To Outlook: Add To Calendar

Date and Time: 7/18/2012 11:30:00 AM CST

Topic: #68-Designing Your First Power… Read more

0 comments, 616 reads

Posted in Devin Knight on 11 July 2012

Identifying Long Running SQL Agent Jobs Script

I’m usually pretty hesitant to share scripts I write because inevitably it will get torn to pieces, but in this case I’d actually like some feedback so I can continue to grow this solution.
This script spawned from Jorge Segarra (@SQLChicken) and I working on a project together that had… Read more

0 comments, 1,865 reads

Posted in Devin Knight on 8 July 2012

Using Excel Macro (.xlsm) Enabled Files in SSIS

Recently while working for a client that was running SQL Server 2008 R2 I was tasked with loading an Excel Macro (.xlsm) enabled workbook. If you have ever tried this yourself you may have tried using the default Excel provider, which does not work. In fact, this is the error… Read more

0 comments, 2,616 reads

Posted in Devin Knight on 29 June 2012

Speaking at PASS Summit 2012

Today I’m thrilled and humbled to announce that I will be speaking 3 times at PASS Summit in November 6-9!  This is my favorite of all conferences to attend and I hope you can make it too.  Go register now here.

A really fun way you can browse all… Read more

0 comments, 486 reads

Posted in Devin Knight on 19 June 2012

Command Line Prompts for Checking Active Directory Membership

Using Active Directory groups are a great way to manage and maintain security for a solution.  Think about if you had to manually add users to your Analysis Services roles each time someone new wanted access to your cube.  Ideally, you would have an AD group in the SSAS role… Read more

0 comments, 734 reads

Posted in Devin Knight on 13 June 2012

New SSIS 2012 Expressions

SSIS 2012 has added a few new expression functions and I thought I’d spend a short time detailing each.


The LEFT function believe it or not is a new function.  In past versions of SSIS you had a RIGHT function available but no LEFT.  Well SSIS expression haters you… Read more

0 comments, 1,116 reads

Posted in Devin Knight on 5 June 2012

SSIS Project Connection Managers

With the new Project Deployment Model in SSIS developers are gaining the benefit of a new design time only feature called Project Connection Managers.  If you’ve developed in SSIS previously Connection Managers require no further detailing, but for those new this is how SSIS connections to data that’s used as… Read more

0 comments, 1,615 reads

Posted in Devin Knight on 31 May 2012

Converting to the SSIS 2012 Project Deployment Model

The new project deployment model in SSIS 2012 is the new standard for how packages are created, configured and deployed.  Any new packages that are created in SSIS will default to using the new deployment model. 

The most basic way of describing this change is now instead of deploying packages… Read more

0 comments, 3,825 reads

Posted in Devin Knight on 22 May 2012

Newer posts

Older posts