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…

SQL Server 2008 Administration in Action

SQL Server 2008 Administration in Action

SQL Server 2008 Administration isn’t a standard SQL Server tutorial-there are dozens of those to choose from. Instead, this book breaks down the role of “SQL Server Administrator” into its key focus areas and tasks and details the techniques and best practices that make an administrator effective. In…

Pro SQL Server on Microsoft Azure

Pro SQL Server on Microsoft Azure

Learn the basics of Microsoft Azure and see how SQL Server on Azure VMs (Infrastructure-as-a-Service) and Azure SQL Databases (Platform-as-a-Service) work. This concise book shows you how to deploy, operate, and maintain your data using any one or a combination of these offerings along with your on-premise environment….

Beginning SQL Queries

Beginning SQL Queries, Second Edition

Anyone who does any work at all with databases needs to know something of SQL. This is a friendly and easy-to-read guide to writing queries with the all-important – in the database world – SQL language. The author writes with exceptional clarity.

579a95cf713dd.jpg

Microsoft Tabular Modeling Cookbook

Business Intelligence Semantic Models (BISM) is a technology that is designed to deliver analytical information to users through a variety of mechanisms that include model structure, definition, and design. This book demonstrates how to create BISM models so that information can be presented to users in an intuitive…

Microsft Reporting Services in Action

Microsft Reporting Services in Action

Serving as a guide to the functionality provided by Reporting Services, this book teaches developers to add reporting to any Internet or web services-capable application, regardless of its targeted platform and development language. Following the report life cycle’s logical path, the book explains how to author, manage, and…

iBATIS in Action

iBATIS in Action

iBATIS in Action teaches Java developers and architects how to use the iBATIS framework to map relational databases to object-oriented programs. Written by the creator of iBATIS, this practical book presents patterns and solutions that readers can apply immediately. iBATIS in Action shows Java developers how to tackle…

Inside the SQL Server Query Optimizer

Inside the SQL Server Query Optimizer

The SQL Server Query Optimizer is perceived by many to be a magic black box, transforming SQL queries into high performance execution plans in the blink of an eye through some unknowable process. The truth is that, while the Query Optimizer is indeed the highly-complex result of decades…