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

  • What's new with T-SQL in SQL Server 2005

    When asked what the most valuable new features are in the soon-to-be-released SQL Server 2005, users commonly refer to its T-SQL enhancements. Edgewood Solutions' Jeremy Kadlec explains the significant enhancements in error handling, transferring row...  Tip

  • Backup and recovery enhancements in SQL Server 2005

    The backup and restore capabilities of SQL Server 2005 are largely unchanged from SQL Server 2000, but there are several new features worthy of your attention. Edgewood Solutions' Greg Robidoux explains the pros and cons of using these features -- fr...  Tip

  • Load-balancing enhancements in SQL Server 2005

    SQL Server 2005 still does not support load balancing out of the box, but it does offer some useful new features to help you distribute transaction load and achieve high availability. Contributor Baya Pavliashvili identifies several significant load-...  Tip

  • Aggregate functions in SQL Server 2005

    SQL Server 2005 expert Adam Machanic answers a commonly asked question regarding aggregate functions in SQL Server 2005.  Ask the Expert

  • Storing business objects as a SQL CLR user-defined type

    Thinking of storing business objects as SQL CLR user-defined types? SQL Server 2005 expert Adam Machanic discusses why you shouldn't.  Ask the Expert

  • Writing stored procedures without knowing T-SQL

    T-SQL may be phased out soon, but it still remains an integral part of SQL Server. Expert Adam Machanic discusses the benefits of using of T-SQL.  Ask the Expert

  • Difficulty storing XML data in SQL Server 2005

    Expert Adam Machanic discusses the ramifications of storing XML data in SQL Server 2005 using the new XML data type.  Ask the Expert

  • Tools to migrate data to SQL Server 2005

    SQL Server 2005 expert Adam Machanic discusses the benefits of using Microsoft's migration tool – the SQL Server 2005 Upgrade Advisor.  Ask the Expert

  • Benefits of upgrading to SQL Server 2005

    SQL Server 2005 expert Adam Machanic discusses the benefits of upgrading to SQL Server 2005.  Ask the Expert

  • Index types in SQL Server 2005

    While SQL Server 2005 does not introduce any new index types, it does include indexing enhancements. SQL Server 2005 expert Adam Machanic discusses these enhancements in this tip.  Ask the Expert

Back to top