SQLServer
SQLServer copied to clipboard
Scripts, links, tools and best practices for Microsoft SQL Server
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
-
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