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