SQLAuthority News – Three Posts on Reporting – T-SQL Tuesday #005

If you are following my blog, you already know that I am more of “T-SQL and Performance Tuning” type of person. I do have a good understanding of Business Intelligence suit and I also do certain training sessions on the same subject. When I was writing the blog post for T-SQL Tuesday #005 – Reporting, I realized that I have written a post that clearly explains how to generate reports using SQL Server Management Studio.

Here is a quick recap on how one can use SSMS and out-of-the-box reports which can help many developers.

Please note that they can be resource-intensive as well, so please use SSMS carefully.

SQL SERVER – Generate Report for Index Physical Statistics – SSMS

SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS

SQL SERVER – Configure Management Data Collection in Quick Steps – T-SQL Tuesday #005

Junior developers and DBA can use these reports right away and can also start learning and exploring most database performance issues with the help of Sr. DBAs.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s