Category Archives: Reporting
-
Permissions script for Azure Synapse
3October 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 -
SQL Homework – November 2019 – SSMS built in reports
1November 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 -
SQL Homework – January 2019 – Baselines
Leave a commentJanuary 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 -
Default SQL Agent Reports – Top Jobs
3July 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 -
Default Database Reports – Disk Usage by Table
4July 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
SQL Studies 