Links

Below you find my most valuable SQL Server and database related links. To make it a bit easier to find what you are looking for, I have categorized the links. Click on a category to display the links.


Give feedback, report bugs etc (connect.microaoft.com is gone as of 2018, btw):
SQL Server feedback forum

Miscellaneous SQL Server web sites
Contribute changes to Books Online
Brent Ozar, sp_BLITZ – SQL Server Takeover Script
Free deadlock collector and parser, by Andreas Wolter
Erland Sommarskog's in-depth articles about dynamic SQL, arrays in SQL, error handling etc.
Glenn Berry's SQL Server Performance, including DMV diagnostics queries
Essential SQL, good basic into of SQL (the language), normalization, etc.
Lots of connection string examples
Ola Hallengren's solution for SQL Server backup, integrity check and index optimization
PASS - The Professional Association for SQL Server
Query store custom SSMS performance dashboard
Trace flag list
SQL Server Updates
Version history, sqlserverbuilds.blogspot.com
SQL Release Services Blog, find recent releases

Monitoring tools, comparsions etc
Periodically collect performance data and visualize it using Brent Ozar's solution
Database Health Monitor from Steve Stedman
SQL Server Tiger Team's performance monitoring solution
SQL Server performance monitoring tools comparsion
"The Ultimate list of Top SQL Monitoring Tools"
Erin Stellato's performance logging solution


SQLskills

Home page (check out the blogs from the members)
Wait Types Library
Latch Classes Library

SSIS related
Alternative to Slowly Changing Dimension Wizard
Component listing on Codeplex
Jamie Thomson's blog
Matt Masson's blog
Handling Slowly Changing Dimensions in SSIS
SQLIS.com - By Darren Green and Allan Mitchell
Understanding Integration Services Package Configurations

Magazines
SQL Server Magazine
Database Journal

Tools: Retrieve data from the transaction log
ApexSQL: ApexSQL Log

Microsoft
SQL Server e-book gallery
SQL Server virtual labs
SQL Server Licensing
Microsoft SQL Server Home
Connect: Microsoft SQL Server Feedback
Database Engine Permission Basics

General databases
Library of Free Data Models
Mimer SQL Validator
Database Debunkings
The Data Administration Newsletter (TDAN.com) Foyer
Intelligent Versus Surrogate Keys

ANSI SQL
SQL Book Reviews and how to get ANSI SQL documents (Ocelot)
Whitemarsh readings about ANSI SQL
Buy standard papers at ANSI (I suggest you compare proces before buying)
Buy standard papers at TechStreet (I suggest you compare proces before buying)
Buy standard papers at Global Engineering (I suggest you compare proces before buying)

General stuff
NIST Dictionary of Algorithms, Data Structures, and Problems
Sysinternals utilities
Dependency walker