sql-server-toolbox

SQL Server Toolbox

Getting Started

A loose assembly of files use for day-to-day administration, performance tuning, troubleshooting and investigation of Microsoft SQL Server databases.

Prerequisites

Many scripts have alternative versions for backwards compatibility with SQL Servers prior to SQL Server 2012, most scripts developed for SQL Server 2012 or higher, many with comments indicating features added in specific versions of SQL Server.

Execution intended with SSMS/VSCode without SQLCMD mode enabled for most scripts, unless otherwise noted.

PowerShell should be supported for PowerShell 3+ unless otherwise noted.

Contributing

Suggestions/corrections welcome. Collaboration limited to Sparkhound SQL DBA team.

Contributors

William Assaf - williamadba
Colby Loupe - cloupe
David Nguyen - davidnguyen2889
Bill Carter - wfc1973

Acknowledgments

Code snippet source documented with URL where appropriate, if lacking, please notify us.

Easy Download

A regularly updated .zip file of the toolbox is available here: https://github.com/williamadba/sql-server-toolbox/blob/master/toolbox.zip for quick download of the entire folder. It is not guaranteed to contain all recent changes, but it usually does.

Name	Name	Last commit message	Last commit date
Latest commit History 686 Commits 686 Commits
.gitattributes	.gitattributes
.gitignore	.gitignore
AG - Am I Primary.sql	AG - Am I Primary.sql
AG - Health_XEvents pre-2016.sql	AG - Health_XEvents pre-2016.sql
AG - Health_XEvents.sql	AG - Health_XEvents.sql
AG - Monitor.sql	AG - Monitor.sql
AG - PerfMon counters.sql	AG - PerfMon counters.sql
AG - alerts.sql	AG - alerts.sql
AG - check owner.sql	AG - check owner.sql
AG - extendedEvents_Create.sql	AG - extendedEvents_Create.sql
AG - failover (in development).ps1	AG - failover (in development).ps1
AG - monitor automatic seeding.sql	AG - monitor automatic seeding.sql
AG - post-zerto failover.ps1	AG - post-zerto failover.ps1
AG - readonly routing urls.sql	AG - readonly routing urls.sql
AG - worker threads diagnostic.sql	AG - worker threads diagnostic.sql
AutomatedFileGrowthV2.sql	AutomatedFileGrowthV2.sql
README.md	README.md
SSHC - Agent-Security-Files-Backups-DBMail.ipynb	SSHC - Agent-Security-Files-Backups-DBMail.ipynb
SSHC - Database.ipynb	SSHC - Database.ipynb
SSHC-HighAvailability.ipynb	SSHC-HighAvailability.ipynb
SSHC-Windows-SQLConfig-BasePerf.ipynb	SSHC-Windows-SQLConfig-BasePerf.ipynb
SSRS rebuild RSExecRole permissions.sql	SSRS rebuild RSExecRole permissions.sql
Stable State Health Checks.ipynb	Stable State Health Checks.ipynb
add database descriptions.sql	add database descriptions.sql
add error event alerts.sql	add error event alerts.sql
agent job history.sql	agent job history.sql
audit setup.sql	audit setup.sql
autogrow change all 1mb growth files.sql	autogrow change all 1mb growth files.sql
autogrow events.sql	autogrow events.sql
automated index rebuild old.sql	automated index rebuild old.sql
automated index rebuild.sql	automated index rebuild.sql
avg disk secwrite.png	avg disk secwrite.png
azure 15min dtu usage.sql	azure 15min dtu usage.sql
azure 15sec dtu usage.sql	azure 15sec dtu usage.sql
azure sql db scale.ps1	azure sql db scale.ps1
backup database master keys.sql	backup database master keys.sql
backup history oldest latest.sql	backup history oldest latest.sql
backup history.sql	backup history.sql
backup progress.sql	backup progress.sql
backup readonly copy restore.sql	backup readonly copy restore.sql
backup restore progress.sql	backup restore progress.sql
backup service master key.sql	backup service master key.sql
backup to azure blob tsql script for legacy SQL.sql	backup to azure blob tsql script for legacy SQL.sql
bad clustered indexes.sql	bad clustered indexes.sql
basic diff backup to URL.sql	basic diff backup to URL.sql
basic full backup to URL system dbs.sql	basic full backup to URL system dbs.sql
basic full backup to URL.sql	basic full backup to URL.sql
basic log backup to URL.sql	basic log backup to URL.sql
blocked processes report xevents.sql	blocked processes report xevents.sql
capture login info xevent.sql	capture login info xevent.sql
change tracking autocleanup diagnostic.sql	change tracking autocleanup diagnostic.sql
checksum vs hashbytes.sql	checksum vs hashbytes.sql
collect connections.sql	collect connections.sql
compress indexes.sql	compress indexes.sql
configuration changes history.sql	configuration changes history.sql
cpu utilization.sql	cpu utilization.sql
database mail diag.sql	database mail diag.sql
database mail profiles.sql	database mail profiles.sql
database ownership.sql	database ownership.sql
database settings info.sql	database settings info.sql
dbatools.Copy-DbaLogin.ps1	dbatools.Copy-DbaLogin.ps1
deadlocks in xevents.sql	deadlocks in xevents.sql
defrag columnstore.sql	defrag columnstore.sql
defrag.sql	defrag.sql
dependencies.sql	dependencies.sql
deprecated usage counter.sql	deprecated usage counter.sql
dimdate.sql	dimdate.sql
dm_exec_query_memory_grants.sql	dm_exec_query_memory_grants.sql
dm_exec_session_wait_stats.sql	dm_exec_session_wait_stats.sql
dm_os_performance_counters.sql	dm_os_performance_counters.sql
dm_os_wait_stats.sql	dm_os_wait_stats.sql
dm_os_waiting_tasks.sql	dm_os_waiting_tasks.sql
easy passwords.sql	easy passwords.sql
endpoint owners.sql	endpoint owners.sql
error log.sql	error log.sql
failover cluster force quorum.ps1	failover cluster force quorum.ps1
filtered index opportunities.sql	filtered index opportunities.sql
find duplicate indexes.sql	find duplicate indexes.sql
find memory mini dumps.sql	find memory mini dumps.sql
firstByte (working).sql	firstByte (working).sql
fix orphaned sid.sql	fix orphaned sid.sql
fk drop recreate.sql	fk drop recreate.sql
fk untrusted or disabled check.sql	fk untrusted or disabled check.sql
fulltext index demo.sql	fulltext index demo.sql
fulltext index status.sql	fulltext index status.sql
gather log events - remoting.ps1	gather log events - remoting.ps1
gather log events.ps1	gather log events.ps1
generate error tables.sql	generate error tables.sql
get disk block allocation size.ps1	get disk block allocation size.ps1
guest permissions.sql	guest permissions.sql
hypothetical cleanup.sql	hypothetical cleanup.sql
index ALLOW_PAGE_LOCKS.sql	index ALLOW_PAGE_LOCKS.sql
index_usage_stats.sql	index_usage_stats.sql
indirect checkpoints enable.sql	indirect checkpoints enable.sql
install failover clustering features.ps1	install failover clustering features.ps1
instant_file_initialization.sql	instant_file_initialization.sql
job - Backup Failure Notifications.sql	job - Backup Failure Notifications.sql
job - File Growth Management.sql	job - File Growth Management.sql
job - Space in Files Monitoring.sql	job - Space in Files Monitoring.sql
job - Volume Stats Monitoring for Production.sql	job - Volume Stats Monitoring for Production.sql

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

sql-server-toolbox

Getting Started

Prerequisites

Contributing

Contributors

Acknowledgments

Easy Download

About

Uh oh!

Uh oh!

Contributors

Uh oh!

Languages

Search code, repositories, users, issues, pull requests...

Folders and files

Latest commit

History

Repository files navigation

sql-server-toolbox

Getting Started

Prerequisites

Contributing

Contributors

Acknowledgments

Easy Download

About

Topics

Resources

Uh oh!

Stars

Watchers

Forks

Uh oh!

Contributors

Uh oh!

Languages