MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook

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

 

Microsoft SQL Server 2008 R2 Master Data Services

This is a practical, step-by-step guide to managing and maintaining your master data and improving data quality with Microsoft SQL Server 2008 R2 Master Data Services, with practical examples on how to use each feature. If you are a business and systems analyst or database administrator who wants

 

Pro SQL Server 2008 Policy-Based Management

Pro SQL Server 2008 Policy-Based Management is in direct response to audit and regulatory pressure on database administrators to manage all databases across an enterprise in a provably consistent manner.

Government and industry regulations such as the Health Insurance Portability and Accountability Act (HIPAA) and the Payment

 

SQL Server DMVs in Action: Better Queries with Dynamic Management Views

Every action in SQL Server – queries, updates, whatever – leaves a set of tiny footprints; SQL Server records all that valuable data and makes it visible through Dynamic Management Views, or DMVs. A DBA or developer can use this incredibly detailed information to significantly improve the

 

Two Minute SQL Server Stumpers

Challenge you in a variety of ways about the different aspects of SQL Server. Some of the questions are arcane, some very common, but you\’ll learn something and the wide range of questions will help you get your mind agile and ready for some quick thinking. This version is

 

Practical SQL Queries for Microsoft SQL Server 2008 R2

Learn powerful techniques for surfacing and delivering actionable business intelligence using SQL. Practical SQL Queries for Microsoft SQL Server 2008 R2 contains more than 400 downloadable SQL queries you can use to extract meaningful insights from large amounts of data. The application, syntax, and results of each query

 

The Red Gate Guide to SQL Server Team-based Development

Only small projects, relevant to very few people, are built by the sweat and toil of a lone developer. Larger projects, affecting whole organizations, will invariably require a team of people to design and develop the application and its storage layer, or database. In some cases, this will

 

The SysAdmin Handbook

Over the past two years, Simple-Talk has published many articles on a variety of SysAdmin topics, from Exchange to Virtualization, and including everything from Powershell to Unified Messaging. We’ve brought together the very best of these articles to form `The SysAdmin Handbook’. With over fifty articles packed into this

 

SQL Server MVP Deep Dives

This is not an ordinary SQL Server Book. SQL Server MVP Deep Dives brings together the world’s most highly-regarded SQL Server experts to create a masterful collection of tips, techniques, and experience-driven best practices for SQL Server development and administration. These SQL Server MVPs-53 in all-each selected a topic

 

Microsoft SQL Server Reporting Services Recipes

Have you mastered the “how-tos” of Reporting Services? Can you confidently design simple reports—but now you need help with meeting the demands of more complex and advanced types of reports? If so, this is the ideal resource for you. Packed with proven design practices, this book serves as a