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

Uh oh!

Repository files navigation

sql-server-toolbox

Getting Started

Prerequisites

Contributing

Contributors

Acknowledgments

Easy Download

About

Uh oh!

Contributors 4

Uh oh!

Languages

TMZ Celebrity News – Breaking Stories, Videos & Gossip

🎥 Watch TMZ Live

SparkhoundSQL/sql-server-toolbox

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

Contributors 4

Uh oh!

Languages

TMZ Celebrity News – Breaking Stories, Videos & Gossip

🎥 Watch TMZ Live