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

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,308 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, 342 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, 802 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, 495 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, 424 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, 700 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, 723 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,146 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, 805 reads

Posted in Devin Knight on 7 March 2012

PowerPivot 2012 RTM Release

Somewhat overshadowed, for obvious reasons, by the big RTM release of SQL Server 2012 was the RTM release of PowerPivot 2012.  You can go download the much improved version of PowerPivot for Excel here.

http://www.microsoft.com/download/en/details.aspx?id=29074

To give you a fair warning there are some prerequisites to installing that were not… Read more

0 comments, 716 reads

Posted in Devin Knight on 7 March 2012

Choosing the Right Microsoft Reporting Technology Part 2: Excel

This post is a continuation of a series started to help you understand each of the Microsoft presentation layer tools purpose and when you should choose each for your reporting solution.  The decision to pick the appropriate tool is difficult but so very important as I detailed in part one Read more

0 comments, 926 reads

Posted in Devin Knight on 6 March 2012

Choosing the Right Microsoft Reporting Technology Part 1: Report Services

As Business Intelligence has evolved over the years the number of tools we have to choose from for presenting data has advanced drastically.  With so many tools to choose from it can be rather confusing (especially when your company is just getting their feet wet in BI) to determine which… Read more

0 comments, 634 reads

Posted in Devin Knight on 1 March 2012

SSRS – Creating a Reporting Services Web Farm

Reporting Services performance problems can often be narrowed down to report design or resource constraints and sometimes a combination of the two. In this post I’ll review the process of scaling-out Reporting Services so server resource constraints can be shared across multiple servers instead of relying on a single server… Read more

0 comments, 964 reads

Posted in Devin Knight on 20 February 2012

SSRS – Embedding Refreshable Reports in Office Tools

Have you ever experienced this?

You have developed a set of Reporting Services report that your users love and they often show them off. The most common way users show off the reports is by taking screenshot images of the reports and embedding those images in a PowerPoint slide deck… Read more

0 comments, 2,052 reads

Posted in Devin Knight on 14 February 2012

Whitepaper – Extending Reporting Services with Custom Code

Today Pragmatic Works released a whitepaper I wrote and I thought I would share it with you.  Prepare for Marketing email…

A Whitepaper by Devin Knight

SQL Server Reporting Services is capable of creating eye-popping visualizations that can be consumed by a variety of business users. The tool has built-in…

Read more

0 comments, 1,129 reads

Posted in Devin Knight on 8 February 2012

SQL Saturday Jacksonville and Precon with Kevin Kline

I’m so excited to tell you about SQL Saturday 130 in Jacksonville coming April 28th. This is the 5th year SQL Saturday has been held in Jacksonville and we have some exciting news about the event this year.

If you have never attended a SQL Saturday before… WHERE HAVE YOU… Read more

0 comments, 398 reads

Posted in Devin Knight on 7 February 2012

SSRS – Using Analysis Services Dynamic Management Views to Build Dynamic Reports

Dynamic Management Views are a very powerful tool that are part of Analysis Services in 2008 and 2008 R2. They give you the ability to monitor Analysis Services usage and metadata.

MSDN articles on SSAS DMVs – http://msdn.microsoft.com/en-us/library/ms126079.aspx

Good post on using SSAS DMVs – http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view/

A report developer could… Read more

0 comments, 1,167 reads

Posted in Devin Knight on 1 February 2012

SSRS - Custom Code with External Assemblies

In a previous post I wrote about how you can use embedded custom code to extend the capabilities of Reporting Services.  This week I will show you another method of using custom code but this time with external assemblies.  Ideally when using custom code you would choose to do so… Read more

0 comments, 6,937 reads

Posted in Devin Knight on 26 January 2012

Session Code – Extending Reporting Services with Custom Code

This is my wish list of things I’d like to cover in todays session at 11 AM EST https://www1.gotomeeting.com/register/935071481 but seeing that I know I’ll only get to a third of these thought I would post these for everyone.  If you’re seeing this late the sessions are recorded and can… Read more

0 comments, 1,166 reads

Posted in Devin Knight on 19 January 2012

January 2012 Speaking Events

It has been a quiet past few months while my family has adjusted to having
two new additions (twins!), but I have slowly been working my way back into
several speaking events.  Having said that January is a busy month of events and
I thought I would share them in… Read more

0 comments, 391 reads

Posted in Devin Knight on 10 January 2012

Newer posts

Older posts