Daily Archives: October 20, 2009

AITP Region 18 Conference

This past weekend I attended the AITP Region 18 Conference in Columbus, OH. This was a great opportunity for me to meet and network with several Information Technology Professionals.  If you have never attended a AITP meeting I highly recommend that you do.

The following was our agenda and a brief afterthought of the topics:

  • Ice Breaker – Got to trade name tags and learn a few facts from a new friend.
  • Leadership – Caught up on the leadership changes within AITP on the national level.
  • VMWare – Learned how VMWare is moving into the cloud.  I was very impressed with the ability to move in and out of the VMWare cloud.
  • Cloud Computing – This really makes it easy to do a SaaS startup.  I am looking forward to trying azure out.

Following the technical sessions we had a great dinner and networking session at the Buckeye Hall of Fame.  Unfortunately, it looked like my presence cursed Ohio State.

Reporting Service Statistics

Question:
How do I obtain statistics for the utilization of SSRS reports?

Solution:

With a little research I found a great sample application on codeplex that provides statistics for SSRS.  The Server Management Sample Reports are available for both SQL Server 2005 & 2008.

The following solution provides answers to the following questions.  What are the top 10 most executed reports? What reports have the longest average execution time?  Who is accessing the reports?

SSRS Analytics

To implement this solution all you have to is download the sample solution and follow the installation guide.  If you have any questions post them here and I will do my best to help you out.