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.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
