The SQL Community has created fantastic resources, all…for…you!
Check them out and let me know if you think I have missed any that should be included.
Community Scripts Preview:
In case you want to check out some of these links individually, I’ve added a list of the contributors, resource name, and the bitly link.
| Contributor | Resource | Bitly Link |
| Adam Machanic | sp_WhoIsActive | http://bit.ly/sp_WhoIsActive |
| Andy Mallon | Shortcuts Cheat Sheet | http://bit.ly/ssmsshortcuts |
| Brent Ozar Unlimited | Paste The Plan | http://bit.ly/pastetheplan |
| sp_Blitz | http://bit.ly/BOUblitz | |
| sp_BlitzCache | http://bit.ly/BOUblitzcache | |
| sp_BlitzFirst | http://bit.ly/BOUblitzfirst | |
| sp_BlitzIndex | http://bit.ly/BOUblitzindex | |
| Daniel Janik | How’s My Plan | http://bit.ly/howsmyplan |
| dbatools | dbatools | http://bit.ly/dbatools |
| Glenn Berry | SQL Server Diagnostic Information Queries | http://bit.ly/DMVQueriesJune2017 |
| Greg Low | SDU Tools | http://sqldownunder.com/resources/sdutools |
| Kenneth Fisher | sp_SrvPermissions | http://bit.ly/sp_srvpermissions |
| sp_DBpermissions | http://bit.ly/spdbpermissions | |
| Kimberly Tripp | sp_SQLskills_helpindex | http://bit.ly/sphelpindex |
| sp_SQLskills_CheckPlanCache | http://bit.ly/sp_SQLskills_CheckPlanCache | |
| Mike Fal | PowerShell Toolbox | http://bit.ly/PowerShellToolbox |
| Niko Neugebauer | Columnstore Indexes Scripts Library | http://bit.ly/ColumnstoreISL |
| Paul Randal | Wait Statistics (please, tell me where it hurts) | http://bit.ly/2oMjbi0 |
| Waits Library | http://bit.ly/waitlibrary | |
| Raul Gonzalez | sqlg_securityAuditServerLogins | http://bit.ly/sqlg_securityAuditServerLogins |
| sqlg_ExtendedEventFileReader | http://bit.ly/sqlg_ExtendedEventFileReader |
Scripts PDF:
PDF’s are so much prettier than hard-to-edit WordPress tables, aren’t they? Here’s a preview of what the PDF looks like!
It’s not the very latest version but I leave it in because Andy Mallon is first in this. 😀
PDF available in the link below
N.B.
Bear in mind that this is a work in progress, so I’d be happy to hear your suggestions on layouts, formats, etc. This is a collection of community scripts and tools; I got no problem with the community having a say in the final result.
Standard warnings:
Nearly every script in here has the standard warning. Something along the lines of
WARNING: Script is from the web, the place where bugs, viruses, and sarcasm lives! Use at your own risk and/or peril.
You have been warned…