SQL Homework – November 2019 – SSMS built in reports


November 4, 2019 by Kenneth Fisher

Time for some homework again. I know Pass Summit is this week so you may be a bit busy but regardless this is an important one. Did you know that SSMS (SQL Server Management Studio) has a bunch of built in reporting?

Get familiar with these reports. Make sure you understand what’s available in them. Spend some time on this. Run the report, run some tests that you think will affect the report, run the report again. Move on to the next report.

Why do I think you need to spend some time here? There is a lot of valuable information, and it’s laid out in a very easy to read manner. You can waste a lot of time searching for some of this information (or not even realize it’s available) if you don’t spend a bit of time getting familiar with what’s available.

Have fun!

One thought on “SQL Homework – November 2019 – SSMS built in reports

  1. […] default trace and the system health extended events session. Last month I had you looking at the built in reports in SSMS because they have a ton of great information and can be really convenient. Well these have even […]

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 )

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: