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

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, 664 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, 657 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, 2,198 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,798 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, 515 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, 809 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,200 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,786 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, 4,195 reads

Posted in Devin Knight on 22 May 2012

Upgrading Packages to SSIS 2012

Many of you may now or in the future have the need to upgrade your SSIS packages to the new SQL Server 2012 SSIS.  Luckily, upgrading from SSIS 2005 or 2008 isn’t nearly as painful as you may have experienced upgrading old DTS (SQL Server 2000) packages.  If you’re considering… Read more

0 comments, 8,181 reads

Posted in Devin Knight on 16 May 2012

SQL Rally Wrap Up

Another SQL Rally has wrapped up in Dallas, TX and it was great event.  My favorite part about these larger events is being able to meet new people and see old friends that I haven’t seen for months. 

Unfortunately, I did not attend any of the precons this year but… Read more

0 comments, 718 reads

Posted in Devin Knight on 11 May 2012

Choosing the Right Microsoft Reporting Technology Part 6: Making the Decision

We’ve completed reviewing the major Microsoft tools and now you have to make “The Decision”.  Which tool(s) is the best fit for the reporting needs?  Remember just picking one tool and using it for all reports may not be the best decision because you are missing out on a lot… Read more

0 comments, 1,360 reads

Posted in Devin Knight on 2 May 2012

OPASS April Meeting Recap

Last Thursday I had the pleasure of speaking in Orlando, FL at the OPASS monthly meeting.  I spoke on Extending SSRS with Custom Code and you can find the presentation material here.

What I’d really like to share with you about the event is what a fantastic group this… Read more

0 comments, 369 reads

Posted in Devin Knight on 24 April 2012

Choosing the Right Microsoft Reporting Technology Part 5: Power View

In part five of this on going series about choosing the right reporting tool we will discuss the newest of tools called Power View.  While Power View is part of Reporting Services in SQL Server 2012 I’ve decided to split it as it’s own topic to help understand when you… Read more

0 comments, 904 reads

Posted in Devin Knight on 17 April 2012

SQL Rally Schedule

In case you didn’t see the email come through for PASS this week the SQL Rally schedule is now available.  The event will be in Dallas May 10-11 with lots of great session so be sure to check it out.  Here’s a link to the PDF or I’ve included screenshots here… Read more

0 comments, 566 reads

Posted in Devin Knight on 13 April 2012

April 2012 Speaking Events

This month I’ll be out and about quite a bit with speaking events.  Thought I’d detail them quickly in case you’re in Florida or interested in attending a free webinar.  Most topics on reporting of some nature this month.

Date: 04/11/2012

Group: Microsoft Webinar Series: Twelve Days of SQL 2012 Read more

0 comments, 470 reads

Posted in Devin Knight on 6 April 2012

SQL Saturday #130 Jacksonville Schedule Posted

SQL Saturday Jacksonville is just under a month away (April 28) and I’m happy to announce the we recently released the schedule for the event. We have a great line up of speakers with a variety of topics for both DBAs and Business Intelligence developers. You can register to attend… Read more

0 comments, 753 reads

Posted in Devin Knight on 30 March 2012

Choosing the Right Microsoft Reporting Technology Part 4: PerformancePoint

If you’ve followed this blog series from the beginning then you may have started thinking about which tools would be best for your environment.  If so that’s great and I’m glad I got you thinking, but I encourage you to keep an open mind as we go through the last… Read more

0 comments, 788 reads

Posted in Devin Knight on 21 March 2012

Choosing the Right Microsoft Reporting Technology Part 3: PowerPivot

Today I’ll be continuing in a blog series designed to help you decide which presentation tool is best for your reporting needs.  So far I’ve discussed in previous posts:

You learned how these two tools are almost opposites of… Read more

0 comments, 2,214 reads

Posted in Devin Knight on 16 March 2012

SQL Server 2012 Data Mining add-in for Excel 2010 Released

Another release that went without much trumpeting was the SQL Server 2012
Data Mining add-in for Excel 2010.  This has been a much awaited release for
those vested in Data Mining. 

The current release was only available for Excel 2007 and if you tried to use
it in Excel 2010… Read more

0 comments, 872 reads

Posted in Devin Knight on 7 March 2012

Newer posts

Older posts