• May 21, 2007 21 May'07

    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.  Continue Reading

  • May 17, 2007 17 May'07

    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 ...  Continue Reading

  • May 17, 2007 17 May'07

    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 ...  Continue Reading

  • May 17, 2007 17 May'07

    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.  Continue Reading

  • May 17, 2007 17 May'07

    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.  Continue Reading

  • May 17, 2007 17 May'07

    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 ...  Continue Reading

  • May 17, 2007 17 May'07

    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 ...  Continue Reading

  • May 17, 2007 17 May'07

    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.  Continue Reading

  • May 17, 2007 17 May'07

    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.  Continue Reading

  • May 17, 2007 17 May'07

    .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 CLR security.  Continue Reading

  • May 17, 2007 17 May'07

    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 this chapter excerpt.  Continue Reading

  • May 17, 2007 17 May'07

    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.  Continue Reading

  • May 14, 2007 14 May'07

    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 ...  Continue Reading

  • May 14, 2007 14 May'07

    '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 fixes for the frequently seen error message in SQL ...  Continue Reading

  • May 10, 2007 10 May'07

    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 options. Microsoft MVP Hilary Cotter explains the new...  Continue Reading

  • May 08, 2007 08 May'07

    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 security specialist Kevin Beaver explains how to secure...  Continue Reading

  • May 03, 2007 03 May'07

    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 methods: breakpoints and data viewers.  Continue Reading

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close