SQL Server DBA Scripts

SQL Server administration scripts.

Usage

File names indicate topics. Find the .sql file you need.

Note

Mixed sources: my scripts + collected from various places over the years. Original authors often unknown. Use at your own risk.

If you're the original author of a script and want attribution, open an issue or PR.

License

Unlicense

Name		Name	Last commit message	Last commit date
Latest commit History 20 Commits
.gitattributes		.gitattributes
.gitignore		.gitignore
AUDIT - Examples.sql		AUDIT - Examples.sql
BULK.sql		BULK.sql
Backups.sql		Backups.sql
CLR.sql		CLR.sql
Collation.sql		Collation.sql
Compression.sql		Compression.sql
Configuration.sql		Configuration.sql
Constraints - Untrusted.sql		Constraints - Untrusted.sql
Constraints.sql		Constraints.sql
Credentials.sql		Credentials.sql
DAC.sql		DAC.sql
DMVs (notes).sql		DMVs (notes).sql
Database Mail.sql		Database Mail.sql
Deadlocks.sql		Deadlocks.sql
Decommission and Cleanups.sql		Decommission and Cleanups.sql
Execution Plans.sql		Execution Plans.sql
Extended Events (notes).sql		Extended Events (notes).sql
FILLFACTOR.sql		FILLFACTOR.sql
Files.sql		Files.sql
Glenn Berry - Azure SQL Database Diagnostic Information Queries.sql		Glenn Berry - Azure SQL Database Diagnostic Information Queries.sql
Glenn Berry - SQL Managed Instance Diagnostic Information Queries.sql		Glenn Berry - SQL Managed Instance Diagnostic Information Queries.sql
Glenn Berry - SQL Server 2025 Diagnostic Information Queries.sql		Glenn Berry - SQL Server 2025 Diagnostic Information Queries.sql
Indexes.sql		Indexes.sql
Jobs - long running.sql		Jobs - long running.sql
Jobs.sql		Jobs.sql
LICENSE		LICENSE
Logins.sql		Logins.sql
Logman - examples.sql		Logman - examples.sql
Objects.sql		Objects.sql
Partitions.sql		Partitions.sql
Performance - CPU.sql		Performance - CPU.sql
Performance - General.sql		Performance - General.sql
Performance - Memory 1.sql		Performance - Memory 1.sql
Performance - Memory 2.sql		Performance - Memory 2.sql
Performance - Replication Agent Waits.sql		Performance - Replication Agent Waits.sql
Performance - Resource Governor.sql		Performance - Resource Governor.sql
Performance - Space Used.sql		Performance - Space Used.sql
Performance - THREADPOOL.sql		Performance - THREADPOOL.sql
Performance - TempDB.sql		Performance - TempDB.sql
Performance - Tests.sql		Performance - Tests.sql
README.md		README.md
Recompile.sql		Recompile.sql
Replication Errors.sql		Replication Errors.sql
Replication.sql		Replication.sql
Restore - Examples.sql		Restore - Examples.sql
Restore - General.sql		Restore - General.sql
Restore - System DBs (notes).sql		Restore - System DBs (notes).sql
SCRIPT - Move DB files v1.1.sql		SCRIPT - Move DB files v1.1.sql
SCRIPT - TempDB settings check.sql		SCRIPT - TempDB settings check.sql
SCRIPT - Waitsnow.sql		SCRIPT - Waitsnow.sql
SCRIPT - copy procedures from database.sql		SCRIPT - copy procedures from database.sql
SCRIPT - who_is_active_v11_32.sql		SCRIPT - who_is_active_v11_32.sql
Security - Logins.sql		Security - Logins.sql
Security - Objects.sql		Security - Objects.sql
Security - Read-Only example.sql		Security - Read-Only example.sql
Security - Roles.sql		Security - Roles.sql
Service Broker.sql		Service Broker.sql
Trace.sql		Trace.sql
Tricks - Miscellaneous.sql		Tricks - Miscellaneous.sql
Tricks - Page.sql		Tricks - Page.sql
Tricks - xp_cmdshell and network shares.sql		Tricks - xp_cmdshell and network shares.sql
Triggers.sql		Triggers.sql
VLFs1.sql		VLFs1.sql
VLFs2.sql		VLFs2.sql
XACT_STATE.sql		XACT_STATE.sql
sa.sql		sa.sql

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Repository files navigation

SQL Server DBA Scripts

Usage

Note

License

About

Uh oh!

Languages

License

mg0x7BE/sql-server-dba-scripts

Folders and files

Latest commit

History

Repository files navigation

SQL Server DBA Scripts

Usage

Note

License

About

Topics

Resources

License

Uh oh!

Stars

Watchers

Forks

Languages