ADO.NET revolutionized the way data was accessed through SQL Server, Oracle, and MySQL. Packed with sample code and recommended practices for using ADO.NET 2, this book explores various data types that are available in the 2.0 Framework and discusses the appropriate time and way to use them.

Serving as both a tutorial and a reference guide to the MDX (Multidimensional Expressions) query language, this book shows data warehouse developers what they need to know to build effective multidimensional data warehouses. It covers such advanced techniques like aggregation, query templates, and MDX optimization.

Shows you how to create and implement data mining applications that find the hidden patterns from your historical datasets. This book explores the core concepts of data mining and the trends. It reveals the best practices in the field, utilizing innovative features of SQL Server 2005 so that you can begin building your own data mining projects.

Helps you get started using SSIS to transform data, create a workflow, or maintain your SQL Server. This book also helps you learn: how to configure various aspects of SSIS; how to interface SSIS with web services and XML; techniques to scale the SSIS and make it more reliable; and, how to migrate DTS packages to SSIS.

Useful for IT professionals, this guide introduces the various facets of SQL Server 2005, which is Microsoft's next-generation data management and analysis solution. Explaining its various features, it shows how they can help conquer a variety of data challenges. It also teaches how to reduce the complexity of managing database applications.

Covering the fundamentals of SQL Server 2005, this developer-oriented guide begins with an exploration of the foundation objects of SQL. Each chapter builds on the previous one, gradually progressing to increasingly advanced topics.