Category Archives: Reporting

  1. Permissions script for Azure Synapse


    October 15, 2020 by Kenneth Fisher

    I was recently asked to add on to my permissions stored procedures (sp_SrvPermissions, sp_DBPermissions and sp_AzSQLDBPermissions) and create one for …
    Continue reading

  2. 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 …
    Continue reading

  3. SQL Homework – January 2019 – Baselines

    Leave a comment

    January 2, 2019 by Kenneth Fisher

    Happy New Year! Every year for New Years we all make a big deal of coming up with New Years …
    Continue reading

  4. Default SQL Agent Reports – Top Jobs


    July 24, 2017 by Kenneth Fisher

    Looking at what a job has been doing is important. Particularly if something is going wrong. Now there are several …
    Continue reading

  5. Default Database Reports – Disk Usage by Table


    July 19, 2017 by Kenneth Fisher

    Every now and again you need to know how big a table is. Or several tables. Or all of the …
    Continue reading

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

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013