An authoritative guide to designing effective solutions for data cleansing, ETL, and file management with SQL Server 2008 Integration Services
SQL Server Integration Services (SSIS) is the leading tool in the data warehouse industry, used for performing extraction, transformation, and load operations.
After an overview of SSIS architecture, the authors walk you a series of real-world problems and show various techniques for handling them.
* Shows you how to design SSIS solutions for data cleansing, ETL and file management
* Demonstrates how to integrate data from a variety of data sources,
* Shows how to monitor SSIS performance,
* Demonstrates how to avoid common pitfalls involved with SSIS deployment
* Explains how to ensure performance of the deployed solution and effectively handle unexpected system failures and outages
* The companion Web site provides sample code and database scripts that readers can directly implement
This book shows you how to design, build, deploy, and manage solutions to real-world problems that SSIS administrators and developers face day-to-day.

Актуально и для версии 8.1
Язык запросов практически не изменился.
Методические материалы для слушателей сертифицированного курса от фирмы 1С.

Cодержится информация, предназначенная для практического применения скрытых возможностей операционной системы и разнообразных COM-объектов при разработке собственных информационных систем на платформе "1С:Предприятие" версий 7.7 и 8.0. Рассмотрены особенности использования объектов ActiveX, администрирования Windows средствами WMI и WSH, взаимодействия с базами данных посредством интерфейсов ADO и SQL-DMO, применения технологии OLE Automation и многое другое при работе в среде "1С:Предприятие".
Во втором издании книги добавлены новые описания возможностей использования технологии ADO и интеграции с офисными приложениями Microsoft Word, Excel, Visio и Project.
Материал сопровождается большим количеством наглядных и подробно прокомментированных примеров, полные тексты которых приведены на компакт-диске.

SQL Server 2008 is the latest update to Microsoft's flagship database management system. This is the largest update since SQL Server 2005, and it brings increased ability to deliver data across more platforms, and thus many different types of devices. New functionality also allows for easy storage and retrieval of digitized images and video. These attributes address the recent explosion in the popularity of web-based video and server and desktop virtualization.

With Microsoft SQL Server 2008 Reporting Services you can quickly deliver relevant business intelligence data wherever it’s needed–across the entire enterprise, and through the entire reporting lifecycle. SQL Server 2008 Reporting Services Unleashed gives you all the authoritative information you’ll need to make the most of Microsoft’s most powerful reporting platform as a database professional, manager, or user. In-depth coverage makes this book an ideal reference, and its extensive set of practical examples help you address virtually any challenge in deployment, configuration, administration, or report building.

Книга содержит инструкции и советы по использованию функциональных возможностей программы Access 2007: созданию баз данных, хранению данных в таблицах, поиску, обработке, сортировке и анализу больших объемов информации с помощью запросов, созданию отчетов, разработке пользовательского интерфейса с помощью форм, программированию в Access и многому другому. Особое внимание уделено описанию новой панели инструментов - ленты, а также оптимальному выбору инструментов для решения конкретной задачи. Дается беспристрастная оценка их функциональности и корректности работы.

Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improvement. Physical and configuration tuning often gives at most a 25% performance increase.

"For those with a need to know, and those with a desire to learn MySQL, this volume contains nearly everything you would want and expect, not only about MySQL itself but about the software that interacts with it or web servers." — John Suda, Slashdot Contributor

A practical, step-by-step approach to making sense out of data

Making Sense of Data educates readers on the steps and issues that need to be considered in order to successfully complete a data analysis or data mining project. The author provides clear explanations that guide the reader to make timely and accurate decisions from data in almost every field of study. A step-by-step approach aids professionals in carefully analyzing data and implementing results, leading to the development of smarter business decisions. With a comprehensive collection of methods from both data analysis and data mining disciplines, this book successfully describes the issues that need to be considered, the steps that need to be taken, and appropriately treats technical topics to accomplish effective decision making from data.

Основное справочное руководство по организации баз данных различного назначения. Подробно рассмотрены основные направления развития современных систем баз данных, методы их проектирования и эксплуатации.