Links
From time to time, I like to save links to blog posts, articles, and other online documentation that I will need to refer back to. The links below are all content from other sites, and I in no way take any credit for them:
User Groups:
- San Diego SQL Server User Group
- San Diego SQL Business Intelligence Group
- SQL Saturday
- PASS Virtual Chapters
Technical Articles:
- SQL Server Version List
- Recommended updates and configuration options for SQL Server 2017 and 2016 with high-performance workloads
- Microsoft’s Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014
- Microsoft’s Memory Configuration and Sizing Considerations for SQL Server 2012 and later.
- Microsoft’s Index Architecture and Design Guide
- Microsoft’s SQL Server Database Engine Input/Output requirements
- Microsoft’s Top 25 SQL Server Engine Errors Based on support case volumes Documented
- Trace Flags (MS Official List)
- Trace Flags (Unofficial list, including undocumented TFs)
- The Data Loading Performance Guide
- Data Loading Performance Considerations with Clustered Columnstore Indexes
- SSIS Data Flow Performance Features
- MS SQL Server JDBC Driver documentation
- sp_server_diagnostics
- SQL Skills – SQL Server Wait Types Library
- SQL Skills – SQL Server Latch Classes Library
- Solving Connectivity errors to SQL Server (Checklist)
- Troubleshooting AlwaysOn Issues (Checklist)
- Microsoft Showplan Schema (XML Schema documentation for execution plans)
- Architecting Microsoft SQL Server on VMWare VSphere
- Filestream Whitepaper
- SQL Server Execution Plan Reference
- How to Properly Configure DTC for Clustered Instances Of SQL Server
SQL Server Internals:
- SQL Server and Azure SQL index architecture and design guide
- Pages and extents architecture guide
- Query processing architecture guide
- Thread and task architecture guide
- SQL Server transaction log architecture and management guide
- Transaction locking and row versioning guide
- Deadlocks guide
- Memory management architecture guide
- Diagnose and resolve latch contention on SQL Server
- Diagnose and resolve spinlock contention on SQL Server
- Ghost cleanup process guide
Blog Posts:
- Bad Habits Revival – SQL Server anti-patterns (Aaron Bertrand)
- Slow In The Application, Fast In SSMS (Erland Sommarskog)
- Database Corruption Challenge(Steve Stedman)
- When to Break Down Complex Queries (SQL CAT Team)
- SQL Server Central Stairways Series
- A successful Git branching model
Problems?
Videos
- Microsoft Certified Master Readiness Videos (Older by still invaluable)
- MSDN Channel 9 – SQL Server Videos
- PASS TV
- Group By Sessions
- SQL Workbooks (Kendra Little’s video series)
- Columnstore Youtube Channel (Niko Neugebauer)
Leave a Reply