SQL Server

Repo for SQL Server scripts. These are targeted to both SQL DBAs and database developers.

Free SQL Server eBooks

• 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)

Web Resources

• Security

  • SQLMap – The tool for mounting SQL injection attacks tests against a running site)

• Free Videos

  • SQLbits
  • BrentOzar
  • SQLPASSTV

• 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)

Free Tools:

• 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