Managers are in constant struggle to make the right decision. One
of the tools that managers depend on is timely and accurate
reports provided by an efficient and well designed data
warehouse application. This book is a comprehensive and concise
guide to designing and building data warehouse applications
using the newly introduced Microsoft product SQL Server 2008.
This book provides the reader
techniques and tips on how to implement SQL Server 2008
efficiently and exploits its features to produce high
performance and intelligent business applications. The book
presents in details all phases of data warehouse development
cycle showing the reader step by step examples for each phase.
This book guides the reader on how to extract, transform and
load data through the use of SQL and Transact-SQL and
demonstrates all related data warehouse features of SQL Server
This book is the first of it's kind for managing very large
databases in SQL Server 2008. This is the first book
dedicated to managing large volumes of data using SQL Server
2008. Using real-world techniques from a practicing SQL Server DBA, this book show how to leverage SQL Server’s data management
features for very large databases.
This is a comprehensive book showing all phases of data
warehouse design and implementation with SQL Server, from
preliminary analysis to the working data warehouse. Showing
never before published secrets, Sam Afyouni guides you through
the use of TSQL for SQL Server Extract, transformation and load
The book also shows tools and techniques for SQL Server
optimization for the data warehouse including clickstreams, data
replication and OLAP services. This comprehensive handbook is a
indispensable aid to building successful SQL Server database
Microsoft SQL Server 2008 is a
new version introduced recently to the database market.
Microsoft is expecting this version to claim more market share
than ever especially with the new features that have hooks to
the Microsoft dot net and other development platforms. Similarly
data warehouse applications are on the rise providing businesses
with more intelligent reports to assist managers make better
decisions. This book combines both technologies together in a
context to provide a sure resource for any IT professional.
• Demonstrates all SQL Server
2008 features related to data warehousing
• Provides SQL code used to extract data from data mart
• Provides Transact SQL used to perform data transformation
and data warehouse population.
• Get step-by-step demonstrations using SQL Server 2008
• See Real life scenarios to illustrate all concepts
presented in each chapter
• Includes Real life case studies that demonstrate all
concepts presented in the book
* Comes with online code depot with dozens of new performance
Demonstrates all SQL Server 2008 features related to data
* Provides SQL code used to extract data from data mart
* Provides Transact SQL used to perform data transformation
and data warehouse population.
* Presents step-by-step
demonstrations using SQL Server 2008
* All examples presented in the
book are real life scenarios to illustrate each concept.
* Includes Real life case
studies that demonstrate all concepts presented in the book