Next month Mike Davis and myself will be making a epic road trip.  We will be flying into Columbus, OH to deliver a two day (7/16 – 7/17) workshop on advanced Reporting Services techniques.  We will then pack up and drive to Cleveland, OH for another two day (7/18-7/19) workshop… Read more

Thanks everyone for attending my free webinar on Creating Real World PowerPivot Models on June, 18, 2013.  If you were not able join for the live event you can now watch the recording here.

In this webinar we built out a live solution with the Pragmatic Works Marketing Director,… Read more

I’m a little late to the celebration but on Friday some there was some exciting news regarding Power View was announced. You can read about the details of it at the Analysis Services and PowerPivot team blog for Microsoft here. http://blogs.msdn.com/b/analysisservices/archive/2013/05/31/power-view-connectivity-for-multidimensional-models-released.aspx

This is part of a SQL Server Cumulative update… Read more

I hope you were able to attend my free webinar on Ad-hoc Reporting with SharePoint on May 21, 2013.  If you weren’t you can now watch the recording here.

As usual there were many great questions that I wasn’t able to answer and I thought I’d follow up on… Read more

I hope you were able to attend my free webinar on Introduction to Analysis Services on April 2, 2013.  If you weren’t you can now download the recording here. 

Because I covered new material all the way to the end of the webinar i thought I'd also answer some… Read more

Join me tomorrow, April 2. 2013, at 11:00 PM EST for a free webinar which is part of an entire month of Back to Basics themed free training.  This webinar is for anyone trying to understand the basics behind Analysis Services and how to get started design a cube.  With… Read more

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

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

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

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

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

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

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

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

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

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

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

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

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

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