Email Alerts
-
Working with schemas in SQL Server 2005
If you're managing too many databases with too many objects, it may be time to take advantage of SQL Server 2005's ANSI SQL feature: schemas. Tip
-
SQL Server 2005 SP1 ships
SQL Server 2005's database mirroring functionality is finally here with the release of SQL Server SP1. Article
-
Resources for business intelligence and data mining in SQL Server 2005
SQL Server expert Eric Brown provides some helpful resources on business intelligence and data mining in SQL Server 2005. Ask the Expert
-
SQL Server 2005: When and how to use Database Snapshots
Database Snapshots, a new feature in SQL Server 2005, lets you easily create a read-only copy of your database. Edgewood Solutions' Greg Robidoux explains the pros and cons of using this feature. Tip
-
Beginning T-SQL: Creating and managing database objects
You can do only three things with any database object, other than actually use it; you can create it, alter it, or drop it to get rid of it. This chapter download covers the use of database objects related to tables, views, stored procedures, and use... Book Chapter
-
Step 3: SQL Server 2005 migration options
Get an overview of common SQL Server 2005 migration options, with corresponding resources to help you execute each option. Step-by-Step Guide
-
Step 2: SQL Server 2005 upgrade prerequisites
Get an overview of considerations and resources you need to migrate to SQL Server 2005. Step-by-Step Guide
-
Step 1: What to upgrade to SQL Server 2005
Consider these SQL Server components when migrating to SQL Server 2005. Step-by-Step Guide
-
Step 4: Key SQL Server 2005 migration considerations
Get technical considerations that are key to a successful SQL Server 2005 migration. Step-by-Step Guide
-
Programming and Extending SSIS: Chapter 14 of Professional SQL Server 2005 Integration Services
This chapter download demonstrates how to build, add and debug components in SQL Server Integration Services, which is SQL's new database management tool. Book Chapter