When you modify the security of a custom dimension in Microsoft SQL Server 2000 Analysis Services, you may intermittently receive an error message that is similar to the following: Dimension Security Syntax Error: Set name 48818.79 is not valid. Do you still want to use this expression for di

When working with SQL 2005, there are times when you need to perform several aggregate functions, or to define a view that needs to be stored only during the execution of a particular query. A Common Table Expression (CTE) does just that; it helps in the definition and manipulation of query related

In Microsoft SQL Server 2000 Analysis Services, an access violation occurs and the Analysis Services service unexpectedly quits during the Startup process. This problem occurs after you install SQL Server 2000 Analysis Services hotfix build 8.0.1028 or SQL Server 2000 Analysis Services hotfix build

(Brian Walker) I have written previous articles in support of surrogate keys, but they were mainly rebuttals to ridiculous comments by others. This technical advice feature goes beyond rhetoric and describes a proposed surrogate key architecture. It also provides several T-SQL tools to support the a

In Microsoft SQL Server 2000 Analysis Services, a fatal exception may occur, and Event ID 117 may be logged in the Application event log. You experience this problem when the following conditions are true: • Lazy aggregation is running. • A dimension that is used as the basis for multiple virtu

(Rodney Landrum) Watching a product grow over the years is kind of like watching a child grow to maturity, adding skills and capabilities to his or her repertoire. I’ve been working with SQL Server Reporting Services since its infancy as a bouncing baby beta born into SQL Server 2000. At the tim

(Muhammad Mosa) In this article we will continue our talking about ADO.Net 2.0 Enhancements. Here we will explore: –Bulk copy –Notifications (not SQL Server Notification Services but something else as we will see)

(Scott Mitchell) In early November 2005, Microsoft launched three new product lines: Visual Studio 2005, SQL Server 2005, and the .NET Framework version 2.0 (which includes ASP.NET version 2.0). SQL Server 2005 is the newest version of Microsoft’s database platform, with the last major SQL Server re

(Jeffrey Juday) If you’re familiar with SQL Server 2005 Integration Services (SSIS) you’re probably aware that SSIS includes vast improvements over SQL Server 2000 Data Transformation Services (DTS). Among these improvements is extensive .NET support, which comes in many forms. For example, the SSIS

(Don Schlichting) Included with SQL Server 2005 is a group of interrelated applications, collectively known as SQL Server Reporting Service (SSRS). SSRS includes all the development and management pieces necessary to publish end user reports in HTML, PDF, Excel, and CSV formats. Originally relea