SQL Server Resources

Wednesday, August 27, 2008

SQL Home

Events

Discussions

Articles

Scripts/Tools

Tips & Tricks

Resources

Community

Job Board

You Are Here: »

SQL Community Portal

SQL Community Home
SQL Tips & Tricks

SQL Blogs
SQL Discussion Forums
SQL Automation Central
SQL Community Articles

SQL TechNet Articles

SQL Upgrade Central

SQL Laboratory

SQL Wikipedia

SQL Server RADIO

SQL World Wide Events

SQL Job Listings

SQL Clinics

Recently Submitted Articles

BEST PRACTICES FOR WRITING BETTER SQL

Multiple INSERTS using Row Constructors in SQL Server 2008

Estimate Disk Space Needed for SQL Server Installation

How to Layout Disk LUNS for SQL Server

How to Configure Memory for SQL Server

Recent SQL Clinic Articles

Configuring DBM on a Low-Bandwidth Networks

Achieving Geo-redundancy with Database Mirroring

Best Practices when performing maintenance in a DBM environment

How to read data from a Mirror database using Database Snapshots

Comparing Failover Clustering with Database Mirroring

SQL Server FAQ's and Resources Home

Is Pubs database and Northwind database a history? - Monday, December 10, 2007

That is correct. Pubs and Northwind sample databases that were part of SQL Server 7.0 and SQL Server 2000 are no longer a part of SQL Server Sample databases instead Microsoft SQL Server team has added a new sample database called AdventureWorks which is now shipped with SQL Server 2005 and SQL Server 2008.

Where to download AdventureWorks database from?
You can download them from here: http://www.codeplex.com/MSFTDBProdSamples

Where to download Pubs and NorthWind sample databases?
You can download them from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en

Close Move

SQL Server 2000 Downloads

SQL Server 2000 Service Pack 4 (SP4)

SQL Server 2000 Service Pack 3a (SP3a)

SQL Server 2000 Service Pack 2 (SP2)

SQL Server 2000 Service Pack 1 (SP1)

SQL Server 2000 Reporting Services Downloads

Reporting Services Service Pack 2 (SP2)

Reporting Services Service Pack 1 (SP1)

SQL Server 2000 Notification Services SP Downloads

Notification Services 2.0 Service Pack 1 (SP1)

SQL Server 2000 Notification Services, Enterprise Edition 2.0 Service Pack 1 (SP1)

SQL Server 2000 Notification Services, Standard Edition 2.0 Service Pack 1 (SP1)

SQL Server CE Downloads

SQL Server CE Service Pack 1 (SP3)

SQL Server CE 1.1 Service Pack 1 (SP1) Update

SQLXML 3.0 Service Pack Downloads

SQLXML 3.0 Service Pack 3 (SP3)

SQLXML 3.0 Service Pack 2 (SP2)

SQLXML 3.0 Service Pack 1 (SP1)

SQL Server 2000 JDBC Driver

SQL Server 2000 Driver for JDBC Service Pack 3 (SP3)

SQL Server 2000 Driver for JDBC Service Pack 2 (SP2)

SQL Server 2000 Driver for JDBC Service Pack 1 (SP1)

MDAC 2.6 Download

Microsoft Data Access Components (MDAC) 2.6 Service Pack 2 (SP2)

SQL Server 2000 Tools Downloads

Microsoft SQL Server 2005 Upgrade Advisor

Support Tools Available for Stress Testing and Performance Analysis

PSSDIAG Data Collection Utility

Download SQL Server Accelerator for Business Intelligence (BI)

SQL Server 2000 Security Tools

Microsoft SQL Web Data Administrator

SQL Server 2000 Desktop Engine Deployment Toolkit (Sample Application)

SQL Server Management Pack

SQL Server 2000 Best Practices Analyzer 1.0

SQL Server 2000 Driver for JDBC Service Pack 3 (SP3)

MSDEToText Tool for Internet Security and Acceleration (ISA) Server 2004

SQL Server 2000 SP4 Replication Components

SQL Server 2000 Web Services Toolkit

Updated Samples for SQL Server 2000

SQL Server 2000 Report Pack for IIS Logs

SQL Server 2000 Report Pack for Microsoft SharePoint Portal Server

SQL Server 2000 Report Pack for Microsoft Exchange

SQL Server 2000 Report Pack for Financial Reporting

SQL Server 2000 Report Pack for Great Plains

SQL Server Report Pack for Microsoft Customer Relationship Management (CRM)

SQL Server 2000 Report Pack for Microsoft Axapta 3.0

SQL Server 2000 Report Pack for Microsoft SharePoint Portal Server 2003

SQL Server 2000 Report Pack for Internet Information Services (IIS) Logs

SQL Server 2000 Report Pack for Microsoft Business Solutions—Great Plains 8.0

SQL Server 2000 Report Pack for Microsoft Customer Relationship Management (CRM)

SQL Server 2000 Report Pack for Microsoft Exchange

SQL Server 2000 Report Pack for Financial Reporting

Reporting Services for SQL Server 2000 Trial Software

Reporting Services for SQL Server 2000 Books Online Update

Developing Applications Using SQL Server 2000 Reporting Services

SQL Server 2000 Health and History Tool (SQLH2) Reports

SQL Server CE 2.0

SQL Server CE 2.0 Books Online

SQL Server CE 2.0 Update for Use with IIS and SQL Server 2000 SP4

Important Information for SQL Server 2000 SP3 and SP3a Users

Notification Services Events

Close Move

SQL Server 7.0 and 6.x Downloads

SQL Server 7.0 Books Online

SQL Server 7.0 Service Pack 4 (SP4)

SQL Server 7.0 Security Update for Service Pack 4

SQL Server 7.0 Service Pack 3 for Intel Platforms

SQL Server 7.0 OLAP Services SP3

SQL Server 7.0 Service Pack 2 (Intel)

SQL Server 7.0 Service Pack 1 for Intel

SQL Server 7.0 Security Patch MS03-031

Fix: Service Pack Installation May Save Standard Security Password in File

SQL Server 6.5 Service Pack 5a (SP5a)

SQL Server 7.0 Tools Downloads

Migrating Sybase Applications to SQL Server 7.0

SQL Server Management Pack

SQL Server DataSizer Tool

OLAP Manager Add-In Kit

Office 2001 Data Access Update

SQL Server 7.0 Samples

OLAP Services: Web Browser Sample

Active Server Pages Sample Application

Visual Basic Sample Application

Visual C++ Sample Application

OLAP Services Sample

Close Move

SQL Server 2005 & SQL Server 2000 Best Practices

· Database Snapshot Performance Considerations under I/O-Intensive Workloads

· Best Practices for Migrating Non-Unicode Data Types to Unicode

· Database Mirroring and Log Shipping Working Together

· Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques

· The Impact of Changing Collations and of Changing Data Types from Non-Unicode to Unicode

· Precision Considerations for Analysis Services Users

· Scale-Out Querying with Analysis Services Using SAN Snapshots

· Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services

· XML Best Practices for Microsoft SQL Server 2005

· Performance Optimizations for the XML Data Type in SQL Server 2005

· SQL Server 2005 Security Best Practices - Operational and Administrative Tasks

· SQL Server 2005 Full-Text Queries on Large Catalogs: Lessons Learned

· Scale-Out Querying with Analysis Services

· SQL Server 2005 Analysis Services Processing Best Practices

· Pre-deployment I/O Best Practices

· Partial Database Availability

· Comparing Tables Organized with Clustered Indexes versus Heaps

· SQL Server 2005 Deployment Guidance for Web Hosting Environments

· Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios

· Implementing Application Failover with Database Mirroring

· OLAP Design Best Practices for Analysis Services 2005

· DBCC SHOWCONTIG Improvements and Comparison between SQL Server 2000 and SQL Server 2005

· TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild

· Loading Bulk Data into a Partitioned Table

· Database Mirroring Best Practices and Performance Considerations

· SQL Server 2005 Performance Tuning using Waits and Queues

· Analysis Services 2005 Performance Guide

· SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Performance, and Scalability

· Microsoft SQL Server 2005 Tuning Tips for PeopleSoft 8.x

· Troubleshooting Performance Problems in SQL Server 2005

· SQL Server 2005 Best Practices Analyzer

· DMV Stats

Scripts and Tools for Performance Tuning and Troubleshooting SQL Server 2005

· Buffer Cache

· CPU and Optimization

· Indexes and Indexing

· Input/Output

· Performance

· Query Plan Re-Use

· Retrieving SQL Text and XML Plans

· SQLOS: Schedulers, Runnable Queue, Waiter List

· Tempdb

· Transactions and Locking

· Wait Statistics

SQL Server 2000 Best Practices

· SQL Server 2000 SP3 Security Features and Best Practices: Security Best Practices Checklist

· Microsoft SQL Server 2000 Index Defragmentation Best Practices

· Best Practices Analyzer Tool for Microsoft SQL Server 2000

Close Move

Email:
Name:
Message:
Send Copy?
Cancel Send

Community Sharing Central

Submit SQL Articles

Submit SQL Scripts

Submit SQL Tips

Submit SQL Resources

Submit SQL Events

Submit SQL Bug

Submit Your Resume

Submit Your SQL Wish

Submit Job Posting

Submit Your FEEDBACK

Recently Submitted SQL Tips

Finding An Occurrence of a Column

List Indexes for all Tables in a Database

UPDATE Based Off of A Table

Configuring Virtual Memory for SQL Server System

Using the REPLICATE Method

Recently Submitted Scripts

SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization

Create All Secondary Indexes 2005

Dynamically Generate Delete Statement for Child Tables

Automatically Create and Analyze Trace for Worst Queries

Script to obtain Database Mirroring connection details

Subscribe to newsletter

Close Move

Subscribe to SQL Server Technical Newsletters

FREE Subscription to SQL Server Technical Newsletter SQL Tips, SQL Scripts, SQL Articles, SQL Job Opportunities, SQL News, SQL Technical Interviews, etc.

Your Email Address
Select Your Country