Nucleus Datakonsult Microsoft articles


About me and Nucleus

Articles, tips etc.
My blog
Microsoft articles

Courses and training

Microsoft Most Valuable Professional


There is a goldmine of articles available at Microsft's website. Below are some URLs that can help you finding an article for the topic and version of SQL Server that you are interested in.

Good starting points:
TechNet: SQL Server TechCenter
TechNet: SQL Server Library
TechNet: SQL Server Best Practices
MSDN: SQL Server Developer Center
MSDN: SQL Server Library
MS Knowledgebase

Some of my favorite articles, in no particular order:
Some papers exists for several versions of SQL Server. I aim at listing the most recent below. The information in a paper is often very much applicable also for older versions, but you can also hunt for the same paper explicitly written for your (older version) of SQL server.

Microsoft server software and supported virtualization environments
5 Tips for a Smooth SSIS Upgrade to SQL Server 2012
Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery
High Availability with SQL Server 2008 R2
Running SQL Server with Hyper-V Dynamic Memory
Understanding and Controlling Parallel Query Processing in SQL Server
Auditing in SQL Server 2008
Data Compression: Strategy, Capacity Planning and Best Practices
Database Encryption in SQL Server 2008 Enterprise Edition
Disk Partition Alignment Best Practices for SQL Server
FILESTREAM Storage in SQL Server 2008
Improving Performance with SQL Server 2008 Indexed Views
Introduction to New T-SQL Programmability Features in SQL Server 2008
Plan Caching in SQL Server 2008
Statistics Used by the Query Optimizer in Microsoft SQL Server 2008
Troubleshooting Performance Problems in SQL Server 2008
Understanding and Using PowerShell Support in SQL Server 2008
Using SQL Server 2008 Extended Events
Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries
An Introduction to SQL Server Service Broker
Comparing Tables Organized with Clustered Indexes versus Heaps
Database Concurrency and Row Level Versioning in SQL Server 2005
Database Mirroring Best Practices and Performance Considerations
Database Mirroring in SQL Server 2005
Forcing Query Plans
How To Diagnose and Correct Errors 17883, 17884, 17887, and 17888 (excellent information about scheduling)
International Features in Microsoft SQL Server 2005
Online Indexing Operations in SQL Server 2005
Partial Database Availability
Partitioned Tables and Indexes in SQL Server 2005
Predeployment I/O Best Practices
Physical Database Storage Design
SQL Server 2005 Row Versioning-Based Transaction Isolation
SQL Server 2005 Waits and Queues
SQL Server I/O Basics, Chapter 2
SQL Writer in SQL Server 2005
TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild
Working with tempdb in SQL Server 2005
SQL Server 2000 I/O Basics