May 2007

  • 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 se...31 May 2007

  • Mimic SQL Server Management Studio reports for Reporting Services

    SQL Server Management Studio has standard reports that can be mimicked to appear in Reporting Services. Find out how to get the reports' source code to do so, and also how to add custom reports to ...29 May 2007

  • FAQ: Top 5 SQL Server backup and recovery problems

    Backup and recovery in SQL Server is another one of those 'do or die' areas. We've tallied your page hits and compiled a Top 5 list of frequently asked questions on the topic, so you'd have a quick...23 May 2007

  • Using SQL Profiler for Analysis Services 2005

    SQL Profiler is a "best of" when it comes to SQL Server tools for troubleshooting and tuning relational database applications and can also be applied to Microsoft Analysis Services 2005.21 May 2007

  • 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 existi...17 May 2007

  • 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 ch...17 May 2007

  • 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.17 May 2007

  • User-Defined Functions

    Creating .NET-based user-defined functions (UDFs) is another new feature that's enabled by the integration of the .NET CLR. Learn more about them in this chapter excerpt.17 May 2007

  • 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 advant...17 May 2007

  • 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 exc...17 May 2007

  • 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 c...17 May 2007

  • .NET database object security

    No discussion of the new CLR features would be complete without a description of the security issues associated with using .NET assemblies and the SQL Server CLR. Find out how you can improve your ...17 May 2007

  • User-Defined Types

    Another important new feature in SQL Server 2005 that is enabled by the integration of the .NET CLR is the ability to create true user-defined types (UDTs). Learn the best ways to utilize them in ...17 May 2007

  • 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 ha...17 May 2007

  • 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.17 May 2007

  • 'Out-of-range datetime value' error in SQL Server when working with dates

    Have you ever been stumped by this error message: "conversion of char data type to datetime data type resulted in an out of range datetime value"? Contributor Serdar Yegulalp shares causes and fixe...14 May 2007

  • 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 ...14 May 2007

  • Disaster recovery features in SQL Server 2005

    Database administrators must have a reliable backup and recovery plan for their SQL Server databases. After five years in development, see how SQL Server 2005 provides greater backup and recovery o...10 May 2007

  • Protecting your database: Who's looking at your sensitive data?

    Methods to protect your SQL Server database include database authentication and logging, which track who has touched your data. But how do you know if someone has simply looked at your data? IT sec...08 May 2007

  • Debugging SSIS packages in SQL Server

    Debugging SSIS packages is a feature in SQL Server 2005 that offers many methods for finding causes of problems. Contributor Eric Johnson takes you through a step-by-step process for two of these m...03 May 2007