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

  • Step 2: Choose your hardware and software

    In this Step-by-Step Guide learn the components to consider when choosing hardware for your upgrade to SQL Server 2005.  Step-by-Step Guide

  • Step 1: Plan your migration

    Before migrating to SQL Server 2005, have a plan in place as detailed in this Step-by-Step Guide.  Step-by-Step Guide

  • Step-by-Step Guide: Migrating to SQL Server 2005 with Copy Database Wizard

    The Copy Database Wizard offers a point-and-click interface to easily migrate a single SQL Server database and its objects from SQL Server 2000 to 2005. Edgewood Solutions' Jeremy Kadlec explains how in this step-by-step guide.  Step-by-Step Guide

  • 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

  • Checklist: Getting ready for SQL Server 2005

    It's never too soon to start planning your upgrade to SQL Server 2005. Edgewood Solutions' Greg Robidoux helps you get up to speed on SQL Server 2005 new features and upgrade planning essentials.  Checklist

  • SQL Server 2000 to 2005 upgrade checklist

    Upgrading from SQL Server 2000 to 2005 involves key planning considerations. Before you upgrade to SQL Server 2005, review this checklist.  Checklist

  • Migrating from ADO to ADO.NET

    This chapter is an introduction to ADO.NET 2.0 for Visual Basic 6 developers who've decided to bite the bullet and move to Microsoft .NET Framework 2.0, Visual Studio 2005 (VS 2005) or Visual Basic Express (VBX) and Visual Basic 2005 (VB 2005).  Book Excerpt

  • Creating basic ADO.NET data objects with SqlClient

    Get typical Visual Basic 2005 code for defining and opening an SqlConnection object, specifying a SqlCommand object and invoking the command's ExecuteReader and ExecuteXmlReader.  Book Excerpt

  • 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

Back to top