Wow! eBook – Blog

Book Description

An in-depth look at the radical changes to the newest release of SISS

Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this complex topic and provides detailed coverage of the new features of the 2012 product release. In addition to technical updates and additions, the authors present you with a new set of SISS best practices, based on years of real-world experience that have transpired since the previous edition was published.

• Details the newest features of the 2012 SISS product release, which is the most significant release since 2005
• Addresses the keys to a successful ETL solution, such as using the right enterprise ETL tool and employing the right ETL architecture in order to meet the system requirements
• Includes additional case studies and tutorial examples to illustrate advanced concepts and techniques

Professional Microsoft SQL Server 2012 Integration Services is a valuable resource that meets the demands and high expectations of experienced SSIS professionals.

From the Back Cover Download Now »

Book Description

IBM DB2 LUW is a leading relational database system developed by IBM. DB2 LUW database software offers industry leading performance, scale, and reliability on your choice of platform on various Linux distributions, leading Unix Systems like AIX, HP-UX and Solaris and MS Windows platforms. With lots of new features, DB2 9.7 delivers one the best relational database systems in the market.

IBM DB2 9.7 Advanced Administration Cookbook covers all the latest features with instance creation, setup, and administration of multi-partitioned database.

This practical cookbook provides step-by-step instructions to build and configure powerful databases, with scalability, safety and reliability features, using industry standard best practices.

This book will walk you through all the important aspects of administration. You will learn to set up production capable environments with multi-partitioned databases and make the best use of hardware resources for maximum performance.

With this guide you can master the different ways to implement strong databases with a High Availability architecture.

What you will learn from this book

• Learn to make best use of scalability with multi-partitioned databases Download Now »

Book Description

phpmyAdmin is one of the most widely used open source applications, which is written in PHP. phpMyAdmin supports a wide range of operations with MySQL. Currently, it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges, export data into various formats and is available in 52 languages.

phpMyAdmin is a web-based front-end to manage MySQL databases and has been adopted by a number of Open-Source distributors.

Mastering phpMyAdmin 3.4 for Effective MySQL Management is an easy-to-read, step-by-step practical guide that walks you through every facet of this legendary tool—phpMyAdmin—and takes you a step ahead in taking full advantage of its potential. This book is filled with illustrative examples that will help you understand every phpMyAdmin feature in detail.

This is the official guide to this popular MySQL web interface. It starts with installing and configuring phpMyAdmin, including the phpMyAdmin Configuration Storage, which is the key to its advanced features. This is followed by configuring authentication in phpMyAdmin and setting parameters that influence the interface as a whole.

You will also learn some advanced features such as defining inter-table relations with the advanced Designer module. You will practice synchronizing databases on different servers and managing MySQL replication to improve performance and data security. Moreover, you will also store queries as bookmarks for their quick retrieval. Download Now »

Book Description

Ace your preparation for the skills measured by MCTS Exam 70-448—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

Maximize your performance on the exam by learning to:

• Create SSIS packages; troubleshoot data flow and control flow
• Configure, debug, and deploy SSIS solutions
• Develop SSAS cubes for OLAP and data mining services
• Implement custom logic with MDX
• Optimize storage design and query performance
• Create SSRS reports; enable interactivity; write custom code
• Manage the report environment
• Configure security features for SSIS, SSAS, and SSRS

Table of Contents
Chapter 1. Developing SSIS Packages
Chapter 2. Debugging and Error Handling in SSIS
Download Now »

Book Description

Ace your preparation for the skills measured by MCTS Exam 70-433—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.
Maximize your performance on the exam by learning to:

• Create and manage database objects
• Query and modify data; implement subqueries and CTEs * Optimize table structures and data integrity
• Create stored procedures, functions, and triggers
• Manage transactions, error handling, and change tracking
• Tune query performance
• Implement database mail, full-text search, Service Broker, scripts
• Work with XML and SQLCLR

Table of Contents
Chapter 1. Data Retrieval
Chapter 2. Modifying Data—The INSERT, UPDATE, DELETE, and MERGE Statements
Chapter 3. Tables, Data Types, and Declarative Data Integrity
Chapter 4. Using Additional Query Techniques Download Now »

Book Description

Ace your preparation for the skills measured by MCTS Exam 70-432—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

Maximize your performance on the exam by learning to:

• Configure, manage, back up, and restore databases
• Create a partitioned table, index, or indexed view
• Configure services and components to manage your environment
• Help prevent unauthorized access at each security infrastructure layer
• Design and deploy high-availability solutions
• Manage SQL Server Agent jobs, alerts, and operators
• Identify service, concurrency, and job execution problems

Table of Contents
Chapter 1. Installing and Configuring SQL Server 2008
Chapter 2. Database Configuration and Maintenance
Chapter 3. Tables
Download Now »