Repo for SQL Server scripts. These are targeted to both SQL DBAs and database developers.
-
SQL Developers
- 119 SQL Code Smells
- Defensive Database Programming (by Alex Kuznetsov)
- Inside the SQL Server Query Optimizer (by Benjamin Nevarez)
-
SQL DBA
- Tribal SQL
- Troubleshooting SQL Server: A Guide for the Accidental DBA (by Jonathan Kehayias and Ted Krueger )
- SQL Server Hardware (by Glen Berry)
-
Security
- SQLMap – The tool for mounting SQL injection attacks tests against a running site)
-
Free Videos
-
Database Podcasts
- SQLServerRadio - (by Guy Glantser and Matan Yungman)
- People Talking Tech - (by Denny Cherry)
- Midnight DBA - (by Sean and Jen McCown)
- Dear SQL DBA - (by Kendra Little)
- SQL Down Under Podcast - (by Greg Low)
-
SQL Code Guard - SQL Code Guard provides fast and comprehensive static analysis of T-SQL code
-
SQL Search - Find fragments of SQL in tables, views, stored procedures, functions and views
-
Apex SQL Refactor - Format SQL with over 160 options
-
ApexSQL Complete - Automatically complete SQL statements
-
SQLQueryStress - Query stress simulator
-
Statistics Parser - Read SQL Server ouput from Statistics IO
-
dbatools - dbatools is a PowerShell module with over 200 SQL Server administration and migration commands included
-
Diskspd - Storage Testing Tool
-
Crystalmark - Disk benchmark software
-
Database Experimentation Assistant - Testing solution for SQL Server upgrades