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

Consuming News Through Social Media and Read It Later With Pocket

These days the fastest way, not always the most accurate, to get news is through social media.  Technology, sports, politics, and breaking news will always be found first on social media outlets like Twitter. 

For example, I’m a huge fan of American Football or most known as the NFL.  Every… Read more

0 comments, 518 reads

Posted in Devin Knight on 20 March 2013

Getting Started with Microsoft Data Explorer

What is Data Explorer

Data Explorer simplifies the data discovery phase for Excel users that are creating self-service Business Intelligence solutions.  It does this by provided straightforward methods for connecting to data previously unheard of, without a developer, in Excel.  It also provides a basic ETL tool for those involved… Read more

0 comments, 558 reads

Posted in Devin Knight on 6 March 2013

Excel 2013 Inquire Add-in

What is Inquire

The Inquire Add-in for Excel 2013 helps you analyze and review your workbooks for things like relationships, invalid formulas, and to compare .xlsx files for differences.  Let’s take some time to review how to enable the add-in and then how to use it.

Enabling the Add-in

If… Read more

0 comments, 772 reads

Posted in Devin Knight on 8 February 2013

New Book: Knight’s SSIS 2012 24-Hour Trainer

I’m very excited to announce that you can now purchase my latest release book:Knight’s Microsoft SQL Server 2012 Integration Services 24-Hour Trainer. The 24-Hour series of books offered by Wrox is a great way to get kick started into learning a new tool. Not only are the lessons… Read more

0 comments, 1,621 reads

Posted in Devin Knight on 30 November 2012

PASS Summit 2012 Recordings Available

Did you attend PASS Summit and miss out on some sessions because there were so many or you were busy networking?  Good news!  The recordings are now available for free to watch streaming for all those who attended the conference now here.

If you weren’t an attendee you can… Read more

0 comments, 800 reads

Posted in Devin Knight on 21 November 2012

PASS Summit 2012 Review

Life is finally returning to normal after a great week in Seattle for PASS Summit 2012.  The entire year is basically other smaller events (still great events!) that occur to pass the time until Summit arrives.  Like Ted Kummert said in the keynote on Wednesday PASS Summit is like a… Read more

0 comments, 1,051 reads

Posted in Devin Knight on 13 November 2012

Building Dynamic SSRS Reports with Analysis Services Recording and Code

Thanks to all who attended my webinar last Thursday on Building Dynamic Cube Reports.  You can find my code

Recording:

http://pragmaticworks.com/LearningCenter/FreeTrainingWebinars/WebinarDetails.aspx?ResourceId=470

Code:

http://sdrv.ms/RqxbcF

There are several reports in here that step you through the changes I made throughout the webinar.

Also, look for my upcoming SSRS Master Classes that will… Read more

0 comments, 720 reads

Posted in Devin Knight on 30 October 2012

Upcoming Webinar: Building Dynamic SSRS Reports with Analysis Services

Join me next week for a really fun presentation on building Dynamic SSRS
reports using Analysis Services cubes as a data source.  This webinar will
demonstrate how you can use one of the underutilized features of Analysis
Services called Dynamic Management Views.

Session details:

Designing
Dynamic SSRS Reports using an…

Read more

0 comments, 963 reads

Posted in Devin Knight on 18 October 2012

24 Hours of PASS Recordings Available

If you missed any of the great 24 hour of PASS sessions from September you
can now watch the recordings. 

http://www.sqlpass.org/UserLogin.aspx?returnurl=%2fLearningCenter%2fSessionRecordings%2f24HoursFall2012.aspx

Details on my session can be found below:

Session 01 - Choosing the Right Reporting Platform
Presenters: Brian Knight, Devin Knight
Download presentation slides (PDF) Read more

0 comments, 591 reads

Posted in Devin Knight on 12 October 2012

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, 554 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, 738 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, 687 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, 580 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, 843 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, 522 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, 655 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, 1,058 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, 916 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,980 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,212 reads

Posted in Devin Knight on 17 July 2012

Newer posts

Older posts