Tools
- tsqllint: Configurable linting for TSQL. Install with
$ dotnet tool install --global TSQLLint or brew tap tsqllint/homebrew-tsqllint; brew install tsqllint for macOS/Linux or npm install tsqllint -t for npm. Supports the creation of custom plugins (implemenent an interface in CLR code).
- TSQL-Smells: "TSQL Smells Finder". Last meaningful activity in 2016/2018.
Reading
- Best of SQLServerCentral.com Vol 7 *(RedGate, By SQLServerCentral Authors)
- Brad's Sure Guide to SQL Server Maintenance Plans - Brad McGehee (PDF) (email address requested)
- Defensive Database Programming - Alex Kuznetsov (PDF)
- Fundamentals Of SQL Server 2012 Replication - Sebastian Meine (PDF) (email address requested)
- How to Become an Exceptional DBA, Second edition - Brad McGehee (PDF)
- Inside the SQL Server Query Optimizer - Benjamin Nevarez (PDF) (email address requested)
- Introducing Microsoft SQL Server 2008 R2
- Introducing Microsoft SQL Server 2012
- Introducing Microsoft SQL Server 2014
- Mastering SQL Server Profiler - Brad McGehee (PDF)
- Microsoft SQL Server Notes for Professionals - Compiled from StackOverflow Documentation (PDF)
- Performance Tuning with SQL Server Dynamic Management Views - Tim Ford, Louis Davidson (PDF)
- Protecting SQL Server Data - John Magnabosco (PDF)
- SQL Server 2012 Tutorials: Reporting Services
- SQL Server 2017 Administrator's Guide - Marek Chmel, Vladimír Mužný (Packt account required)
- SQL Server Backup and Restore - Shawn McGehee (PDF) (email address requested)
- SQL Server Execution Plans, Third Edition - Grant Fritchey (PDF)
- SQL Server for C# Developers Succinctly - Sander Rossel
- SQL Server Hardware - Glenn Berry (PDF)
- SQL Server Internals: In-Memory OLTP - Kalen Delaney (PDF)
- SQL Server Metadata Succinctly - Joseph D. Booth
- SQL Server Source Control Basics - Rob Sheldon, Rob Richardson, Tony Davis (PDF)
- SQL Server Statistics - Holger Schmeling (PDF)
- SQL Server Stumpers Vol.5 (PDF)
- SQL Server Tacklebox - Rodney Landrum (PDF)
- SQL Server Transaction Log Management - Tony Davis, Gail Shaw (PDF)
- The Art of SQL Server FILESTREAM - Jacob Sebastian, Sven Aelterman (PDF)
- The Art of XSD - Jacob Sebastian (PDF)
- The Best of SQLServerCentral.com Vol 7 (PDF)
- The Redgate Guide to SQL Server Team-based Development - Phil Factor, Grant Fritchey, Alex Kuznetsov, Mladen Prajdić (PDF)
- Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias, Ted Krueger (PDF)
Tags:
storage
relational
windows
clr
Last modified 22 January 2025