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…

Microsoft SQL Server 2008 R2 Master Data Services

Microsoft SQL Server 2008 R2 Master Data Services

Microsoft SQL Server Master Data Services (MDS) enables organizations to manage and maintain business data used to make critical business decisions. MDS is a Master Data Management (MDM) application, which standardizes and streamlines the critical data entities of an organization, essentially centralizing your master data. A focused, practical…

MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook

MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook

MDX-related books often dedicate a significant part of their content to explaining the concepts of multidimensional cubes, the MDX language and its functions, and other specifics related to working with Analysis Services. And that’s perfectly fine, there should be books like that, the tutorials that teach the concepts….

Dynamic SQL

Dynamic SQL

This book is an introduction and deep-dive into the many uses of dynamic SQL in Microsoft SQL Server. Dynamic SQL is key to large-scale searching based upon user-entered criteria. It’s also useful in generating value-lists, in dynamic pivoting of data for business intelligence reporting, and for customizing database…

Practical Maintenance Plans in SQL Server

Practical Maintenance Plans in SQL Server

This book is a complete guide to setting up and maintaining maintenance plans for SQL Server Database Administrators. Maintenance plans too often consist of a backup task and that’s it, but there is so much more that can and must be done to ensure the integrity of your…

Microsoft SQL Server 2008 For Dummies

Microsoft SQL Server 2008 For Dummies

If you’re a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get up to speed on SQL Server 2008, impress your boss, and improve your company’s data management — read “Microsoft SQL Server 2008 For Dummies!” SQL Server 2008 lets you build powerful databases…

Beginning SQL Queries: From Novice to Professional

Beginning SQL Queries: From Novice to Professional

Beginning Queries with SQL is a friendly and easily read guide to writing queries with the all-important ― in the database world ― SQL language. Anyone who does any work at all with databases needs to know something of SQL, and that is evidenced by the strong sales…

Android SQLite Essentials

Android SQLite Essentials

SQLite is an open source relational database management system. Android uses the SQLite database to store and retrieve data persistently. The driving force behind the platform is the database, enabling a myriad of choices for developers making cutting-edge applications. Android SQLite Essentials focuses on the core concepts behind…