Nucleus Datakonsult SQL Server and database links


About me and Nucleus

Articles, tips etc.
My blog
Microsoft articles

Courses and training

Microsoft Most Valuable Professional


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.

Official documentation
How to get a functional SQL Server 2014 Books Online
SQL Server Transact-SQL reference, all versions
SQL Server Product Documentation, all versions

Miscellaneous SQL Server web sites
Brad M. McGehee's SQL Server Performance Tuning And Optimization Tips site
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
SQL Server Updates
Version history,
SQL Release Services Blog, find recent releases

Monitoring tools, comparsions etc
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
5 Reasons You Must Start Capturing Baseline Data
Back to Basics: Capturing Baselines on Production SQL Servers
Capturing Baselines on SQL Servere: Where's My Space?
Capturing Baselines on SQL Server: Wait Statistics

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 - Douglas Laudenschlager's blog and website
Jamie Thomson's blog
Matt Masson's blog
Handling Slowly Changing Dimensions in SSIS - By Darren Green and Allan Mitchell
SSIS forum on MSDN
Understanding Integration Services Package Configurations

SSRS related
SSRS Map Gallery on CodePlex
Report Surfer, community site for sharing sample reports
Sharepoint and SQL Server Reporting Services
SQL Server 2008 R2 Reporting Services Integration in SharePoint 2010

SQL Server Magazine
Database Journal
Intelligent Enterprise

3:rd party products
Cleardata: Cleartrace, aggregate and present SQL Server traces
Embarcadero: DBA Tools
OfficeRecovery: Recover data from corrupted SQL Server database files
Red-Gate: SQL compare and SQL Data Compare
xSQL, object and data compare. SDK also available.

Tools: Retrieve data from the transaction log
ApexSQL: ApexSQL Log
Redgate: SQL Log Rescue

SQL Server e-book gallery
SQL Server virtual labs
SQL Server Licensing
Microsoft SQL Server Home
Connect: Microsoft SQL Server Feedback
Events and Errors Message Center
Database Engine Permission Basics

General databases
Library of Free Data Models
Mimer SQL Validator
Database Debunkings
The Data Administration Newsletter ( Foyer
The Data Warehousing Institute
Intelligent Versus Surrogate Keys

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
ACM Association for Computing Machinery
ACM Digital Library
NIST Dictionary of Algorithms, Data Structures, and Problems
Sysinternals utilities
Dependency walker