Microsoft SQL Server 2012 Administration

Microsoft SQL Server 2012 Administration

Implement, maintain, and repair SQL Server 2012 databases As the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether you manage and administer SQL Server 2012 or are planning to get your MCSA: SQL Server 2012 certification,…

Building a Data Warehouse

Building a Data Warehouse

Here is the ideal field guide for data warehousing implementation. This book first teaches you how to build a data warehouse, including defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Coverage then explains how to populate the data warehouse…

SQL Server AlwaysOn Revealed, 2nd Edition

SQL Server AlwaysOn Revealed, 2nd Edition

Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This second edition is newly-updated to cover the 2016 editions of both SQL Server and Windows Server. Also in this edition is all-new content on troubleshooting and metadata. The book provides a solid…

Learning SQL Server 2008 Reporting Services

Learning SQL Server 2008 Reporting Services

Microsoft SQL Server Reporting Services 2008 is the third generation Microsoft reporting software that is more tightly integrated with SQL Server 2008 than ever before. It provides a complete server-based platform that is designed to support a wide variety of reporting needs, including managed enterprise reporting, special purpose…

Learning SQLite for iOS

Learning SQLite for iOS

The ability to use SQLite with iOS provides a great opportunity to build amazing apps. Apple’s iOS SDK provides native support for SQLite databases. This combination offers the potential to create powerful, data-persistent applications. This book starts with the architecture of SQLite database and introduces you to concepts…

Pro SQL Server Always on Availability Groups

Pro SQL Server Always on Availability Groups

This book is your field guide to planning, deploying, managing, and troubleshooting Always On Availability Groups. The Always On Availability Groups feature is an enterprise-level solution for high availability and disaster recovery. Always On provides a rich set of options that reduce overhead and resource usage and enable database…

The Language of SQL, 2nd Edition

The Language of SQL, 2nd Edition

Many SQL texts attempt to serve as an encyclopedic reference on SQL syntax — an approach that is often counterproductive, because that information is readily available in online references published by the major database vendors. For SQL beginners, it’s more important for a book to focus on general…

Pro SQL Server 2005 Service Broker

Pro SQL Server 2005 Service Broker

This book explains why Microsoft introduced Service Broker and describes its big advantages over prior message technologies. Rich with practical examples, this volume offers complete, incisive coverage on this important new technology. Focused on best practices, the book explains in detail how Service Broker supports and enhances database…