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 (https://blog.sqlauthority.com)