Monthly Archives: October 2009

AITP Region 18 Conference

Posted on October 20, 2009 by | 4 comments

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.

4 Comments

Posted in Events

Tagged , ,

Reporting Service Statistics

Posted on October 20, 2009 by | Leave a comment

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.

Leave a comment

Posted in SQL Server, SQLServerPedia Syndication

Tagged

When was that object modified?

Posted on October 6, 2009 by | 1 comment

Yes, every once in a while when I am deploying an application I ask myself the following question.  What database objects (tables, stored procedures, functions etc..) did I modify with this release?  

Ideally this is documented in the release plan but I will admit I have been known to slip every once in a while.  Therefore, I am showcasing a query that can provide help.  This query was written by Gordon Bell and it can be found here.   It uses the sys.objects DMV that are included in SQL 2005 & 2008. 

I will defiantly throw this script into my bag of tricks. 

select name, modify_date,
case when type_desc = 'USER_TABLE' then 'Table'
when type_desc = 'SQL_STORED_PROCEDURE' then 'Stored Procedure'
when type_desc in ('SQL_INLINE_TABLE_VALUED_FUNCTION', 'SQL_SCALAR_FUNCTION', 
'SQL_TABLE_VALUED_FUNCTION') then 'Function'
end as type_desc
from sys.objects
where type in ('U', 'P', 'FN', 'IF', 'TF')
and is_ms_shipped = 0
order by 2 desc

1 Comment

Posted in Scripts, SQLServerPedia Syndication

Tagged ,