Creating Dot Net Stored Procedures in SQL Server 2005

The CLR in SQL Server 2005 is quite the topic of debate and whether it is a good thing or not. No matter which side you are on, the reality is that you will need to understand how to create, manage, and work with stored procedures based on assemblies in SQL Server 2005. New author Yelena Varshal brings us a basic article and a sample that you can use.

MSDN TV: Report Authoring Tips and Tricks

Getting started with SQL Server 2005 Reporting Services or the new report controls in Visual Studio 2005? Brian Welcker demonstrates some tips and tricks that you can use to add interactive features to your own reports.

MSSQL Server Reporting Services: Mastering OLAP Reporting: Percent of

An important consideration, when designing a Business Intelligence system within any environment, is a consideration for "where to put the intelligence" among the various "layers" within the system. I have stated many times in the past, in both articles and presentations, that "multi-layered reporting solutions require multi-layered architects," and nowhere is this truer than within the design and implementation of the Microsoft integrated business intelligence solution. This article provides an excellent example of such considerations: the option for placing a needed calculation at either the Analysis Services level (within the cube structure) or the Reporting Services level.

What is the best method to check whether...

Using CROSS APPLY in SQL Server 2005

My interest in writing this article was started by an MSDN article titled SQL Server 2005: The CLR Enters the Relational Stage. The article shows how to write a function that returns the top three countries per category. That's always been something that was difficult to do in SQL so I was curious about the approach. The article started out well but I was very unhappy by the end. It's just soooo much easier to do this in SQL Server 2005 using the new CROSS APPLY clause in Transact-SQL. So I'm going to write a query to return the top 3 orders for each customer and I'm going to do it in about 10 lines of SQL. (UPDATE: An alert reader found an even better approach!)

Usage Scenarios for SQL Server 2005 Native Web Services

Get a detailed look at how to set up SQL Server 2005 for Web service access in a heterogeneous environment, and learn more about key scenarios for Web services in SQL Server 2005.

Processing XML Showplans Using SQLCLR in SQL Server 2005

Build an application to extract a query's estimated execution cost from its XML showplan. Users can submit only those queries costing less than a predetermined threshold to a server running SQL Server 2005, thereby ensuring it is not overloaded with costly, long-running queries.

What is the fifth rule of database normalization?

Using Ranking and Windowing Functions in SQL Server 2005

SQL Server 2005 is chock full of new features. You may have heard that you can write stored procedures in a CLR language like C# or VB .NET, but TSQL is here to stay. One new great feature adds the functionality of a Ranking expression that can be added to your result set that is based on a ranking algorithm being applied to a column that you specify. This will come in handy in .NET applications for paging and sorting in a grid as well as many other scenarios. We are going to take a look at the Ranking functions new to SQL Server 2005 using the new AdventureWorks database on the February 2005 Community Tech Preview.

Extending Microsoft SQL Server 2000 Reporting Services with Custom Cod

This article presents an excerpt from the book, Microsoft Reporting Services in Action, by Teodor Lachev. Learn how to implement advanced report functionality using custom code.