Top 10 Lists

Everyone loves a good Top 10 list, so we challenged our volunteers to build a few, and we're hoping you'll consider adding one of your own. Pick a topic that we haven't covered and come up with 10 good links, send them to us and we'll take a look! It's okay to include something you authored on the list, but we recommend it be limited to no more than one of the items.

 

Top 10 Articles on SQL Server Clustering: Hemantgiri S. Goswami

  1. How to Create SQL Server 2005 Clustering with Virtual Server 2005
  2. Introduction to SQL Server 2005 Clustering Basics
  3. Inside SQL Server Cluster Setup and Troubleshooting Techcniques
  4. Busting 6 SQL Server Failover Clustering Myths
  5. SQL Server 2000 and 2005 Clustering
  6. Preparing the SQL Server 2005 Clustering Infrastructure
  7. Should I Upgrade my Current Clustering to SQL Server 2005 Cluster
  8. SQL Server 2008 Failover Clustering White Paper
  9. SQL Server 2005 Multi-Site Clustering with Windows Server 2008
  10. SQL Server Clustering Best Practices

Top 10 Profiler Links: Jack Corbett

  1. How to Track Down Deadlocks Using SQL Server 2005 Profiler
  2. Introduction to SQL Server Profiler Part 1 / Part 2
  3. Profiler Trace Templates
  4. Combining SQL Server Profiler and Windows Performance Logs and Alerts to Monitor Performance Issues
  5. Custom User Configurable SQL Server Profiler Events
  6. Enhancements in SQL Server Profiler 2005
  7. SQL Server Performance Statistics Using a Server Side Trace
  8. SQL Server Profiler – Basic Concepts
  9. Default Trace - a Beginner’s Guide
  10. SQL Server Profiler Trace Parsing Tool – Build Performance Reports Based on Profiler Traces Only

Top 10 Execution Plan Links: Grant Fritchey

  1. Spool Operators in query plan…
  2. Execution Plan Basics
  3. SQL Server Query Execution Plan Analysis
  4. Find Top N Costly Query Plans in Adhoc Batches or Modules
  5. Back To Basics: What’s the difference between a Scan and a Seek
  6. Subqueries in BETWEEN and CASE Statements
  7. Query Plan Guides – part 1 – tame those wild vendor apps
  8. Reproducing SQL Server Query Execution Plan Performance Problems
  9. How SQL Server Determines an Execution Plan Using Available Indexes and Statistics
  10. Table variable vs. temp table and estimated vs. actual query plan

Top 10 Web Resources to Learn SQL Server Reporting Services (SSRS): Jessica Moss

  1. Beginning SQL Server 2005 Reporting Services Part / Part 2
  2. SSRS Books Online
  3. Robert Bruckner’s Advanced Reporting Services Blog
  4. Chris Hays’s Reporting Services Sleazy Hacks Weblog
  5. Musings on Reporting Services and Notification Services
  6. ReportViewer control in Visual Studio 2008
  7. Microsoft SSRS online resources
  8. Microsoft SQL Server 2005: Reporting Services
  9. Prologika Forums
  10. Direct Reports

Top 10 Web Resources to Learn SQL Server Analysis Services (SSAS): Jessica Moss

  1. SQL Server Analysis Services Tutorial
  2. Microsoft OLAP and Microsoft Analysis Services
  3. Chris Webb’s BI Blog
  4. Microsoft Analysis Services Community Site
  5. Richard Tkachuk's Analysis Services Page
  6. Analysis Services Resource Hub
  7. MDX at First Glance
  8. Jesse Orosz: SQL Server Analysis Services Blog
  9. Darren Gosbell [MVP] – Random Procrastination
  10. Getting Started with SQL Server Analysis Services

Top 10 Web Resources to Learn SQL Server Integration Services (SSIS): Jessica Moss

  1. SQL Server Integration Services an Introduction Part 1 / Part 2
  2. SSIS Junkie
  3. BIDSHelper
  4. SSIS Connectivity WIKI
  5. SSIS Books Online
  6. SQLIS
  7. SSIS Team Blog
  8. SSIS Design Pattern - ETL Instrumentation
  9. Kirk Haselden
  10. BI Thoughts and Theories

Top 10 Links About SQL Statistics: Andy Warren

  1. Statistics Used by the Query Optimizer in Microsoft SQL Server 2005
  2. SQL Server Statistics
  3. SQL Server UPDATE STATISTICS
  4. NORECOMPUTE Option of UPDATE STATISTICS in SQL Server
  5. Statistical Maintenance Functionality (Autostats) in SQL Server
  6. Auto update statistics and auto create statistics - should you leave them on and/or turn them on?
  7. How SQL Server Index Statistics works - Part 1 / Part 2
  8. UPDATE STATISTICS Undocumented Options
  9. Filtered Indexes and Statistics in SQL 2008
  10. How It Works: Statistics Sampling for BLOB Data

Top 10 Links About Security: K. Brian Kelley

  1. SQL Server 2005 Security Best Practices: Operational and Administrative Tasks
  2. Security Overview for Administrators
  3. Center for Internet Security benchmark for SQL Server 2000 and 2005
  4. Common SQL Server Security Issues and Solutions
  5. SQL Injection Attacks by Example
  6. Server level permissions for SQL Server 2005 and 2008
  7. Database level permissions for SQL Server 2005 and 2008
  8. SQL Server Database Forensics presentation
  9. SQL Security website by Chip Andrews
  10. SQL Server Security blog

Top 10 Articles for Learning About Spatial Data: Grant Fritchey

  1. Bob Beauchemin: Using the spatial index diagnostic stored procedures
  2. Isaac Kunen: Basic Multi-Level Grids
  3. Bob Beauchemin: Spatial Indexes in SP1, almost no hints required
  4. Boston GIS: Bringing in Towns as Geography
  5. Ed Katibah: Loading GeoNames Data into SQL Server 2008 (the PowerShell, bcp way)
  6. SharpGIS: SQL Server 2008 Spatial Tools
  7. Steve Wright: How to load spatial data into SQL Server 2008 from .Net
  8. Paul Randal: SQL Server 2008: Spatial indexes
  9. Dave Does Data: SQL Spatial: How to get Spatial data. (FREE Maps ‘n Demographics)
  10. Alastair Aitchison: Beginning Spatial

Top 10 List for SQL Server Memory: Sankar Reddy

  1. Maciej Palecki: Where Is My Memory? Understanding Microsoft SQL Server Memory Usage and Management (DAT404)
  2. Christian Bolton: A walk down memory lane
  3. Jonathan Kehayias: Understanding the VAS Reservation (aka MemToLeave) in SQL Server
  4. Jonathan Kehayias: Troubleshooting the SQL Server Memory Leak (or Understanding SQL Server Memory Usage)
  5. Slava Oks: SQL Server Memory Management
  6. Glenn Berry: SQL Server 2008 Diagnostic Information Queries
  7. Paul Randal: Inside the Storage Engine: What's in the buffer pool?
  8. Bob Ward: Come on 64bit so we can leave the mem..
  9. How to use the DBCC MEMORYSTATUS command to monitor memory usage on SQL Server 2005
  10. Glenn Berry: Suggested Max Memory Settings for SQL Server 2005/2008