Introducing Microsoft® SQL Server® 2012 explores the exciting enhancements and new capabilities engineered into SQL Server, ranging from improvements in operation to those in reporting and management. This book is for anyone who has an interest in SQL Server 2012 and wants to understand its capabilities, including database administrators, application …

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 …

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 to manage …

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 Card Industry (PCI) …

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 performance of queries …

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 a …

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 are described …

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 mean some …

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 book, …

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 of …