Book Description

Microsoft SQL Server is an enterprise database platform that contains a multitude of technologies, Analysis Services being one of them. SQL Server Analysis Services (SSAS) provides OLAP and data mining capabilities and allows users to analyze multidimensional data stored in cubes using the MDX query language.

This cookbook contains over 80 practical, task-based recipes that show how Microsoft SQL Server 2008 R2 Analysis Services solutions can be taken further by enriching them with high-performance MDX calculations and flexible MDX queries.

Packed with immediately usable, real-world recipes, the book starts with elementary techniques that lay the foundation for designing further MDX calculations and queries. Here you will find topics such as iterations on a set, Boolean logic, and dissecting and optimizing MDX calculations.

In the first half of the book you will learn how to efficiently work with time, strings, metadata, Read More ...

Book Description

A hands-on resource for SQL Server 2008 troubleshooting methods and tools

SQL Server administrators need to ensure that SQL Server remains running 24/7. Authored by leading SQL Server experts and MVPs, this book provides in-depth coverage of best practices based on a deep understanding of the internals of both SQL Server and the Windows operating system.

You’ll get a thorough look at the SQL Server database architecture and internals as well as Windows OS internals so that you can approach troubleshooting with a solid grasp of the total processing environment. Armed with this comprehensive understanding, readers will then learn how to use a suite of tools for troubleshooting performance problems whether they originate on the database server or operating system side.

Topics Covered:

• SQL Server Architecture
• Understanding Memory
• SQL Server Waits and Extended Events
• Working with Storage
• CPU Read More ...

Book Description

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 tutorial, this book will show you how to manage and maintain your organization’s master data and improve data quality with Microsoft SQL Server 2008 R2 Master Data Services. Using credible techniques and an end-to-end approach, this book will take you through the steps required to implement Master Data Management, enabling business users to standardize and streamline their business data.

This book will enable you to manage and maintain your organization’s master data with Microsoft SQL Server 2008 R2 Master Data Services, covering each feature in a step-by-step manner. The book starts with an overview of Master Data Read More ...

Book Description

Microsoft SQL Server is a powerful relational database engine, widely used to store and maintain data in Enterprises of various levels – be they small, medium, or large. SQL Server delivers a rich set of integrated services and reporting features that enable you to do more with your data such as query, search, synchronize, report, and analyze. SQL Server 2008 R2 accelerates the capabilities to scale database operations and is a highly scalable data platform.

This practical cookbook will show you the advanced administration techniques for managing and administering a scalable and high-performance SQL Server 2008 R2 system. It contains over 85 practical, task-based, and immediately useable recipes covering a wide range of advanced administration techniques for administering a high-performance SQL Server 2008 R2 system and solving specific administration problems. It shows how the SQL Server 2008 R2 system can be taken further.

Packed with reusable, real-world Read More ...

Book Description

SQL Server 2008 Transact–SQL Recipes: A Problem–Solution Approach is an example–based guide to the Transact–SQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author Joseph Sack takes common Transact–SQL tasks and breaks them down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.

• Focused on solutions: Look up what you need to do. Learn how to do it. Do it.
• Current: Newly updated for SQL Server 2008.
• Comprehensive: Covers 30 different Transact–SQL problem domains.

What you’ll learn

• Create databases, tables, and indexes.
• Query and manipulate data.
• Store and manage XML inside the database.
• Move business logic into the database.
• Encrypt data and capture changes for compliance Read More ...

Book Description

This book is designed to teach application developers all of the skills they need to use SQL to work with a Microsoft SQL Server 2008 database. But it’s also a great first book for developers who are on the path to becoming a DBA.Unlike most SQL Server 2008 books, this one starts by showing you how to use SQL queries to extract and update the data in a database, because that’s what every application developer needs to know first. Then, it shows how to design and implement a database, how to use powerful backend database features like views, stored procedures, functions, triggers, cursors, transactions, locking, security, and how to work with BLOB and XML data. Finally, it shows how to use the CLR integration feature to create database objects using a .NET language such as C# or Visual Basic.

From the publisher
The SQL book that most developers don’t even know they need that’s how I think of this book.To be an effective application developer, you Read More ...