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.
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 (