Migrating to SQL Server 2008 & 2008 R2
Congratulations on making the decision to migrate to SQL Server 2008 or 2008 R2! The SQL Server 2008 & 2008 R2 Migration Project Plan will assist you every step of the way through the process via hands on, how-to articles and videos. Migrating to SQL Server 2008 or 2008 R2 requires a good amount of planning, from choosing the right SQL Server license for your needs to installing the required hardware and software before you migrate. After you’ve planned out your SQL Server 2008 or 2008 R2 environment, you’re ready to migrate.
This SQL Server Pro Project Plan will walk you through the process of the actual migration from previous versions of SQL Server, such as SQL Server 2000, and other database offerings such as Microsoft Access. When your migration is complete, you’ll want to take your database environment to the next level by implementing SQL Server2008 or 2008 R2’s new features, such as new data types, encryption, and PowerPivot for Excel 2010. Our expert content will show you how to implement SQL Server 2008 or 2008 R2’s administration, development, and business intelligence features in your environment.
Not finding what you're looking for? Email our editors, and let us know how we can help.
Planning
|
SQL Server 2008 R2 Requirements
SQL Server Version Build Numbers |
SQL Server 2008 R2 New Features |
Migrating
|
Upgrading to SQL Server 2008 R2
Migrating to SQL Server 2008
How to Upgrade to SQL Server 2008 |
Tools for Migrating Access to SQL Server
|
Fine Tune Your Migration
|
Backup and Recovery |
|
|
Database Mirroring in SQL Server 2008 R2 and SQL Server 2008
Advanced BACKUP and RESTORE Options |
Step-by-Step Approach to Differential Backup and Recovery |
|
Security and Auditing |
|
|
Hardening SQL Server
SQL Server 2008 Boosts Built-in Encryption
SQL Server Ecryption |
|
|
Virtualization |
|
|
Optimizing SQL Server Performance in a Virtual Environment |
7 Best Practices for Running SQL Server on Hyper-V |
|
T-SQL |
|
|
Upgrading Clusters to SQL Server 2012 When AlwaysOn Availability Groups Will Be Used
Planning and Implementing a SQL Server Cluster
More SQL Server 2008 T-SQL Improvements
SQL Server 2008’s T-SQL Development and Debugging Features |
Parallelism Enhancements in SQL Server 2008
Date and Time Support in SQL Server 2008
Using SQL Server 2008 FILESTREAM Storage
Using SQL Server 2008's FILESTREAM Data Type
Simplifying Spatial Data
|
|
Business Intelligence |
|
|
Introducing PowerPivot for SharePoint
SQL Server 2008 Change Data Capture |
|
|
SharePoint and SQL Server Integration |
|
|
5 Considerations for Setting up a SQL Server 2008 Backend for SharePoint 2010 |
SSRS 2008 R2 and SharePoint 2010 Integration |
|
PowerPivot and Excel |
|
|
How to Create PowerPivot Applications in Excel 2010
A Walkthrough of PowerPivot for Excel 2010 |
Integrating SQL Server 2008 Spatial Capabilities with Microsoft Virtual Earth
|
|
SQL Server Reporting Services |
|
|
Unlock the Secrets of SQL Server 2008 Reporting Services |
A Candid Look at Report Builder 3.0 |
|
SQL Server Integration Services |
|
|
Use Checkpoints to Restart Failed SSIS Packages |
SSIS Novices’ Guide to Data Warehouses: Moving Data into the Data Warehouse |
|
SQL Server Analysis Services |
|
|
Backup Basics for SQL Server Analysis Services |
|