SQL Server Installation & Upgrade Links

Tuesday, May 21, 2013 Login | Register

Home

Resources

Storage

Hardware

Installation & Upgrades

Clustering

Security

Configuration Settings

Policy Based Management

Data Management

Backup & Restore

Database Mirroring

Indexing

Monitoring & Automation

Data Collector

Resource Governor

Performance Tuning

Corruption & DBCC

Replication

Development

Data Warehousing & BI

Links

sqlCrunch Feed

rodcolledge.com

SQL Server MVP

My Book

Popular Downloads

SQL 2008 SP2
SQL Migration Assistant
R2 Management Pack
R2 Feature Pack
Consolidation Planning

Installation

Pre-Installation Checklist

Brent shares his pre-installation checklist containing best practices for preparing for a SQL Server installation. This post also links to a follow up blog entry on post installation tasks ... Source : BrentOzar.com - Blog Post

Fixing setup prior to running it

Bob walks us through the new slipstream setup process whereby service packs and cumulative updates can be included in the one installation ... Source : Bob Dorr - CSS SQL Server Engineers - Blog Post

Editions & Features

Features available in each edition of SQL Server 2008 ... Source : Microsoft.com - Article

Licensing Overview

This downloadable word document explains key licensing considerations for SQL Server 2008 installations ... Source : Microsoft.com - Download

Running SQL Server 2008 on Windows Server 2008

This paper highlights the performance, scale and security benefits achieved by combining SQL 2008 and Windows 2008 ... Source : Microsoft.com - Whitepaper

Patching the SQL Server 2008 RTM Setup Process

There are some known issues with the 2008 RTM setup process that are fixed in CU1. In this post, Bob Ward explains how the new 2008 setup architecture allows the rtm setup process to be patched prior to execution ... Source : Microsoft PSS SQL Server Engineers - Blog Post

SQL Server 2005 Deployment Guidance for Web Hosting Environments

This paper provides best practices for configuring SQL Server 2005 to optimize security, tenant isolation, and the performance of your hosted SQL Server 2005 deployment. Sample scripts for provisioning users and databases for use in shared hosting are included ... Source : Microsoft.com - Technet Article

Port Numbers and Named Instances

If you supply a port number in a connection string, what effect does including the instance name have? Read on for Grant's first hand experience ... Source : Grant Fritchey - Blog Post

Windows Server 2008

This 36 page word document covers the major benefits of the Windows Server 2008 platform including Virtualization, Server Management, Security and Compliance, and High Availability ... Source : Microsoft.com - Downloadable Word Document

Upgrade

Server Migration Checklist

What's involved in making sure a SQL Server migration goes smoothly? Lots ….. Merrill presents us with his checklist ... Source : Merrill Aldrich - SQLBlog.com

SQL Server 2008 Upgrade Technical Reference

The Upgrade Bible. Essential reading before any upgrade ... Source : Microsoft.com - Downloadable Word Document

Microsoft Assessment and Planning (MAP) Toolkit

Version 3.2 of the MAP tool now includes a SQL Server Instance Discovery module, a fantastic tool for planning an Enterprise consolidation or upgrade project ... Source : Ward Pond - Technet.com - Blog Post

Upgrading to SQL Server 2008

Rob shares his powerpoint presentation on Upgrading to SQL Server 2008 ... Source : Rob Carrol - Technet.com - Blog Post

SQL Server Instance Inventory

In this article, Sakthivel lists a number of tools that can be used to generate an inventory of SQL Server instances. He then provides a step by step example of the usage of one of the listed tools (SQLping) ... Source : Sakthivel Chidambaram - SQLServerCentral.com

Upgrading the SQLServerCentral Servers - Part 1

Brad walks us through the upgrade process for the SQLServerCentral and Simple-Talk.com websites ... Source : Brad McGehee - SQLServerCentral.com - Blog Post

Evaluation Edition Upgrade

Jonathan walks us through a known problem when upgrading an expired evaluation edition of SQL Server 2008 ... Source : Jonathan Kehayias - SQLBlog.com

Microsoft Assessment and Planning Toolkit

Useful for a variety of purposes from upgrade preparation through to security audits, the Microsoft Assessment and Planning Toolkit (MAP) has a component to automatically discover SQL Server instances on the network and report back with a variety of information. As Mike shows us in this blog post, this tool is both easy to use and extremely valuable ... Source : Mike Walsh - SQLServerPedia.com - Blog Post

Upgrading to SQL 2005 at Microsoft

This article covers the process followed by Microsoft to upgrade their internal database systems to SQL Server 2005 ... Source : Microsoft.com - Technet Article

2005 Upgrade Technical Reference

Comprehensive upgrade guide to upgrading to SQL Server 2005 ... Source : Microsoft.com - Download

Oracle to SQL Server Data Migration

The SQLCat team reveal the various methods and corresponding results of moving 200GB of data from a Unix based Oracle 9i system to SQL Server 2005 with a 2 hour duration target ... Source : SQLCat.com - Technical Note

How can I limit the number of reboots when applying hotfixes ?

This Technet Q A article discusses the need for reboots when installing SQL Server hotfixes and service packs and how to avoid them ... Source : Microsoft.com - Technet Article