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
  • SQL Server 2005 backward compatibility issues to consider

    Do you fear a SQL Server 2005 upgrade will break server applications? Contributor Serdar Yegulalp addresses key backward compatibility problems. 

  • 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. 

  • 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. 

  • SQL Server and MSDE version compatibility

    SQL Server 2005 Expert Adam Machanic explains the version compatibility between SQL Server and other servers such as MSDE. 

  • Sysindexes replacement in SQL Server 2005

    SQL Server 2005 has a set of internal tables which functions as SQL Server 2000's sysindexes. However, the user does not have access to the tables, but can get a glimpse of what they do. 

  • 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). 

  • 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. 

  • Q&A: What's new in SQL Server 2005 SP1

    SQL Server 2005 Service Pack 1 offers DBAs production-ready Database Mirroring, SAP NetWeaver Business Intelligence support, Full-Text support and additional features to ease the pains of fully utilizing the new DBMS. We recently asked Microsoft prod... 

  • Procedure to kill Windows process in SQL Server 2005

    Find out how to kill a Windows process in SQL Server 2005 in this expert response. 

  • SQL Server 2005 guide to performance metrics

    SQL Server 2005 allows you to map micro-level data to macro-level metrics by associating SQL Profiler and Performance Monitor in one interface. Edgewood Solutions' Jeremy Kadlec explains how to do this.