Automating "Save DTS package"

MAK examines how to save all of the DTS packages from SQL Server to a structured storage file automatically.

Optimized ADO.NET

This article contains guidelines compiled by examining the .NET implementations of shipping .NET applications and analyzing the common performance mistakes that we found. The guidelines discuss selecting .NET objects and methods, designing .NET applications, retrieving data, and updating data.

SQL Server 2000 Report Pack for Microsoft CRM

The SQL Server 2000 Report Pack for Microsoft CRM is a set of six Microsoft SQL Server 2000 Reporting Services reports that work with the Microsoft CRM 1.2 sample database.

With the Report Pack, you have the choice of using the sample reports either as-is or as templates for designing new reports using the SQL Server Reporting Services Report Designer.

Extending Microsoft SQL Server 2000 Reporting Services with Custom Cod

In this article, I will show you how to leverage the Reporting Services unique extensible architecture to supercharge your report capabilities. First, I will explain how embedded and custom code options work. Next, I will show you how you can leverage custom code to author an advanced report with sales forecasting features.

SQL Server: Blocking Problems

This article focuses on a common problem associated with conflicting locks: blocking. When blocking occurs, a single connection blocks all other connections from reading or modifying a particular piece of data. Learn here how to resolve these issues.

Introduction to MSSQL Server 2000 Analysis Services: Basic Storage Des

This article looks at the basics of storage design for cubes using Analysis services. A good starting point for those getting into the use of analysis services.

Free SQL Book!!!

Akeel Din has written an introductory SQL book that is available for free in PDF form. It's also available in print from Amazon if you like holding something real in your hands.

Dimensional Databases: Building A Data Warehouse

A basic look at how you can start to build a data warehouse. This has some basics you need to do the design of the various fact and dimension tables.

Not All SQL Server Indexes Are Created Equal

Just because a column has an index doesn't mean the SQL Server Query Analyzer will use it. Learn how to create indexes SQL Server will use.

Systems Thinking

J.D. Edwards was big on Systems Thinking, a way of looking at your systems and improving their functions. It was applied it to IT to become one of the top IT organizations to work for. Read some of these articles for an overview of how this works.