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

  • Best SQL Server products of 2005

    The editors of SearchSQLServer.com sat down this past fall to assess the 2005 crop of products. Here are the winners in the General Database Utilities category.  Special Report

  • Testing old SQL Server 7 app on a free version of SQL Server 2005

    Whether or not it's "enough" to use a free version of SQL Server 2005 to test compatibility with a Visual Basic application on SQL Server 7 really depends on how closely your testing environment mirrors production.  Ask the Expert

  • Can I restore a SQL Server 7.0 backup in SQL Server 2005?

    Adam Machanic explains if SQL Server 2005 supports backup and restore from previous versions  Ask the Expert

  • Working with multiple versions of SQL Server

    A typical SQL Server shop has some combination of newer and older database versions running, posing a challenge to application functionality. This tip discusses the expiration of older version support and how to integrate multiple versions effectivel...  Tip

  • FAQ: SQL Server 2005 features and functions

    SQL Server 2005 is full with new features and functions. Get the answers to 10 frequently asked questions on the minds of DBAs and developers about major DBMS changes and new functionality.  FAQ

  • Moving from SQL Server 7.0 to SQL Server 2005

    Skipping right over SQL Server 2000? Get insights from SQL Server 2005 expert Adam Machanic on making this move.  Ask the Expert

  • Query Analyzer's replacement in SQL Server 2005

    What will replace the beloved and greatly-needed Query Analyzer tool in SQL Server 2005? Expert Adam Machanic explains.  Ask the Expert

  • Converting logins after an upgrade

    SQL Server 2005 expert Adam Machanic clarifies some misunderstandings about login conversion after an upgrade.  Ask the Expert

  • Overcoming SQL Server's 8060-byte row limit

    SQL Server 2005 expert Adam Machanic discusses an important feature called row overflow, which greatly relaxes the 8060-byte restriction.  Ask the Expert

  • Database mirroring in SQL Server 2005

    Have you heard rumors that database mirroring was removed from SQL Server 2005? In this expert response, SQL Server 2005 expert Adam Machanic assures you that it has not been removed, but it needs to be turned on and can only be used in development e...  Ask the Expert

Back to top