By Russ Whitney – Analysis Services natively supports many aggregation types, but sometimes you need to perform an aggregation that native types can’t handle. Here are some ways you can use non-native aggregation types to solve real-life calculation problems.

by Meredith B. Derby – Erickson, director of product management for SQL at San Jose, Calif.-based NetIQ, Corp., outlined several dos and don’ts for SQL Server management. NetIQ announced its new SQL Server Management Suite on Feb. 4. The suite contains three new products: Configuration Manager, Reco

By Brad M. McGehee – This extensive article discusses how to install the Windows 2000 Cluster Service in preparation for installing SQL Server clustering.

Discover the improvements in cell writeback, a key feature of SQL Server 2000 Analysis Services, and learn how to optimize cell writeback performance.

By John Taschek – One of the most fascinating lectures I’ve attended lately was “How Databases Changed the World,” put on by the Computer History Museum. The event last week featured a panel discussion by the biggies in the database business, including Chris Date, Michael Stonebraker (formerly of Il

Book by Garth Wells – If you want to learn how to write stored procedures and triggers for Microsoft SQL Server, Code Centric: T-SQL Programming with Stored Procedures and Triggers is the book for you. You’ll learn “real-world” coding and how to build non-trivial applications.

By Ellen O’Brien – When managing complex database environments, IT vendors and buyers agree on the three top priorities: integration, integration and integration.The challenge of integrating data is not a new one. However, restrictions on IT spending and staffing in the last year have placed

Many programming languages have supported User Defined Functions for years, but they are new to SQL Server 2000. In this article we will look at some of the many ways functions can be used.

Here are fifteen little known tips that you can use to ensure your Analysis Services are performing in the most efficient manner possible.

SQL Server 2000 Windows CE Edition supports the uniqueidentifier data type. By default, the SQL Server NEWID function is not used in SQL Server CE to generate a unique value for the uniqueidentifier column. However, the ROWGUIDCOL attribute for a column has been overloaded to indicate that a default