Microsoft SQL Server 2005

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

  • Processing: Training data models on SQL Server

    Data mining processes all data models in a structure in parallel on a single data read by creating a compressed cache of the data. Outlined here are several processing options.  Book Excerpt

  • Database mirroring setup in SQL Server 2005

    SQL Server 2005 database mirroring allows you to automatically mirror database contents from one SQL Server database to another. Edgewood Solutions' Greg Robidoux explains how it works, what you need to make it work and how to get it up and running ...  Tip

  • SQL Server 2005 partial backup options

    SQL Server 2005 offers new backup options, including partial backups, to help ease the pain of backing up only changed data. Contributor Serdar Yegulalp compares your options.  Tip

  • Yukon

    Yukon is the code name used for the beta version of Microsoft's SQL Server 2005. SQL Server 2005 is said to provide enhanced flexibility, scalability, reliability, and security to database applications, and to make them easier to create and deploy, t...  Definition

  • SQL Server 2005 Enterprise Edition vs. Standard Edition

    SQL Server expert Adam Machanic highlights the differences to consider when weighing the move to SQL Server 2005 Enterprise and Standard Edtions.  Ask the Expert

  • Online restore feature in SQL Server 2005

    SQL Server 2005's online restore feature eliminates the need to have exclusive access to the database when restoring a backup. Expert Greg Robidoux explains the restore procedure, which requires the Enterprise or Developer Edition for implementation...  Tip

  • Conclusion

    Migrating to SQL Server 2005 is a straightforward process with the Copy Database Wizard, and it will be a common selection for most DBAs when migrating a database and its dependent objects.  Step-by-Step Guide

  • Step 6: Perform post-upgrade tasks

    Immediately following the upgrade to SQL Server 2005, follow this Step-by-Step Guide to ensure the optimizer has the information it needs to access the data in the most efficient manner.  Step-by-Step Guide

  • Step 5: Migrate using the Copy Database Wizard

    When upgrading to SQL Server 2005, refer to this Step-by-Step Guide for the Copy Database Wizard to successfully migrate the needed databases and dependent objects in unison.  Step-by-Step Guide

  • Step 4: Be sure you have a corruption-free environment

    Before upgrading to SQL Server 2005 you must be sure the environment is free from corrupution; Follow this Step-by-Step Guide for instructions.  Step-by-Step Guide

Back to top