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

  • Upgrading to SQL Server 2005: Six migration tips

    When upgrading to SQL Server 2005, there are a number of things to consider. It starts with getting to know SQL Server 2005 before the actual upgrade and ends with optimizing your new SQL Server setup. Serdar Yegulalp outlines six points to be aware ...  Tip

  • Debugging CLR database objects

    One significant feature found in the integration of .NET Framework, Visual Studio 2005, and SQL Server 2005 is the ability to debug the CLR database objects that you create. Find out more in this chapter excerpt.  Tutorial

  • CLR architecture

    The .NET Framework CLR is very tightly integrated with the SQL Server 2005 database engine. In fact, the SQL Server database engine hosts the CLR. This gives SQL Server 2005 several distinct advantages over the .NET integration that's provided by DB2...  Tutorial

  • Developing CLR database objects: 10 tips, 10 minutes

    The integration of the .NET Framework's Common Language Runtime (CLR) with SQL Server 2005 is arguably the most significant new development featured in the SQL Server 2005 release. In this book excerpt, you'll learn about capabilities to create datab...  Book Excerpt

  • CLR aggregates

    The CLR aggregate is another new type of .NET database object that was introduced in SQL Server 2005. Learn more in this chapter excerpt.  Tutorial

  • CLR triggers

    In addition to stored procedures and user-defined functions, the new .NET integration capabilities found in SQL Server 2005 also provide the ability to create CLR triggers. Find out how in this chapter excerpt.  Tutorial

  • CLR stored procedures

    Stored procedures are one of the most common database objects that you'll want to create using one of the managed .NET languages. One of the best uses for CLR stored procedures is to replace existing extended stored procedures. Learn the best method...  Tutorial

  • Creating CLR database objects

    Get an overview of the process to manually create a CLR database object. Then go further and learn how to use the Visual Studio 2005 Professional, Enterprise, and Team System Editions, which all have tools that help create CLR database objects as wel...  Tutorial

  • CLR assemblies in SQL Server 2005

    If you're familiar with ADO.NET, you may wonder exactly how CLR database objects connect to the database. Find out in this chapter excerpt, along with how to code to create a SQL Server assembly.  Tutorial

  • FAQ: SQL Server comparison features

    In this FAQ, our SQL Server experts answer your questions about comparison features in both SQL Server 2000 and SQL Server 2005. Have you wanted to know which data type to use, nvarchar or varchar when storing character information? Or, are you wonde...  FAQ

Back to top