Community Scripts

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. 😀

Community Scripts Preview

PDF available in the link below

CommunityScriptsV08


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…