Описание: Professional SQL Server 2011 Analysis Services with MDX and DAX shows readers how to build sophisticated business intelligence solutions using SQL Server Analysis Services, along with SQL Server Integration and Reporting Services. The authors begin with an overview showing how Analysis Services can be used to build data warehouses and multi-dimensional databases. They then quickly move to a tutorial that describes the development process for building dimensions and cubes from various data sources. The authors show how MDX and the more simplified version of MDX, DAX, can be used to query databases to provide sophisticated analysis of business problems. They will demonstrate a variety of techniques against real-world case scenarios. They will also show how Analysis Services can be used with other components of SQL Server, including Integration Services, Reporting Services, and Data Mining to provide comprehensive, end-to-end solutions. The 2011 book will be more than 50% new and revised to cover new features and enhancements, including: Improved integration with Excel and SharePoint 2010 The new DAX language, which is a more simplified, user-friendly version of MDX. PowerPivot, a new tool for performing simplified analysis of data. Integration of Analysis Services with PowerPivot, plus enhancements to PowerPivot, including Key Performance Indicators. The new Business Intelligence Semantic Model (BISM). Significant enhancements to Business Intelligence Development Studio (BIDS) and SQL Server Management Studio (SSMS) A new BI tool, code-named Crescent, that will revolutionize how data is reported. Integration with the Vertipaq engine for improved performance.
Описание: Contains material on the 2008 release of SQL Server Integration Services (SSIS). This book show developers how to master the 2008 release of SSIS. It covers data warehousing using SSIS, fresh methods for managing the SSIS platform, and improved techniques for ETL operations.
Описание: Professional Microsoft SQL Server 2011 Integration Services An in-depth look at the radical changes to the newest release of SISS Microsoft SQL Server 2011 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this complex topic and provides detailed coverage of the new features of the 2011 product release. In addition to technical updates and additions, the authors present you with a new set of SISS best practices, based on years of real-world experience that have transpired since the previous edition was published. Details the newest features of the 2011 SISS product release, which is the most significant release since 2005 Addresses the keys to a successful ETL solution, such as using the right enterprise ETL tool and employing the right ETL architecture in order to meet the system requirements Includes additional case studies and tutorial examples to illustrate advanced concepts and techniques Professional Microsoft SQL Server 2011 Integration Services is a valuable resource that meets the demands and high expectations of experienced SSIS professionals
Описание: A must-have guide for the latest updates to the new release of Reporting Services SQL Server Reporting Services allows you to create reports and business intelligence (BI) solutions. With this updated resource, a team of experts shows you how Reporting Services makes reporting faster, easier and more powerful than ever in web, desktop, and portal solutions. New coverage discusses the new reporting tool called Crescent, BI semantic model's impact on report design and creation, semantic model design, and more. You'll explore the major enhancements to Report Builder and benefit from best practices shared by the authors. Builds on the previous edition while also providing coverage of the new features introduced with SQL Server 2011 Explains Reporting Services architecture and BI fundamentals Covers advanced report design and filtering techniques, walking you through each design, discussing its purpose and the conditions where it could be more efficient Discusses semantic model design, Report Builder, Crescent, and more Targets business analysts and report designers as well as BI solution developers Professional Microsoft SQL Server 2011 Reporting Services is mandatory reading if you are eager to start using the newest version of SQL Server Reporting Services.
Описание: SQL Server Integration Services (SSIS) is the leading tool in the data warehouse industry, used for performing extraction, transformation, and load operations. This guide to designing effective solutions for data cleansing, ETL, and file management with SSIS 2008 demonstrates how to integrate data from a variety of data sources.
Описание: Best practices for administering SQL Server 2014, from Microsoft MVPs This comprehensive guide teaches the skills needed to successfully administer SQL Server, including change management, security, performance tuning, monitoring, and backups. Written by the leading authorities on Microsoft SQL Server, this book will help you master the latest features of the 2014 release, including greater integration of cloud and on–premises management using SQL Server Management Studio, enhanced performance optimization, new cardinality estimator, and new features for AlwaysOn availability groups. This comprehensive guide will help you improve the efficiency, scalability, and performance of the SQL Server environment so more can be done in less time. Professional Microsoft SQL Server 2014 Administration: Provides an overview of SQL Azure and new features for AlwaysOn availability groups Explains In–Memory OLTP and buffer pool extensions for SSDs and performance optimizations for 2014 Details the new cardinality estimator (Query Optimizer) in SQL 2014 Discusses the separation of duties and important regulatory requirements for security roles Provides real–world case examples and solutions Programmer Forums Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world. Code Downloads Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use. Read More Find articles, e–books, sample chapters, and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.
Автор: Knight, Brian Patel, Ketan Snyder, Wayne Laforte, Название: Professional microsoft sql server 2008 administration ISBN: 0470247967 ISBN-13(EAN): 9780470247969 Издательство: Wiley Рейтинг: Цена: 5225 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, developer, and business intelligence (BI) developer. This book is suitable for developers, DBAs, and casual users who hope to administer or may already be administering a SQL Server 2008 system and its business intelligence features.
Описание: An essential how-to guide for experienced DBAs on the most significant product release since 2005! Microsoft SQL Server 2011 will have major changes throughout the SQL Server and will impact how DBAs administer the database. With this book, a team of well-known SQL Server experts introduces the many new features of the most recent version of SQL Server and deciphers how these changes will affect the methods that administrators have been using for years. Loaded with unique tips, tricks, and workarounds for handling the most difficult SQL Server admin issues, this how-to guide deciphers topics such as performance tuning, backup and recovery, scaling and replication, clustering, and security. Serves as a must-have how-to guide on the new features of the 2011 release of Microsoft SQL Server Walks you through ways to manage and monitor SQL Server and automate administration Guides you through SQL Azure for cloud computing, data replication, and data warehouse performance improvements Addresses client-connectivity enhancements, new features that ensure high availability of mission-critical applications, and tighter integration with Excel and SharePoint for data analysis and reporting Highlights major changes to the suite of SQL Server BI tools, including integration, reporting, and analysis services Includes real-world case examples and best practices from Microsoft insiders If you're a database administrator eager to get started with the newest version of SQL Server, then this book is essential reading.
Описание: Optimize reporting and BI with Microsoft SQL Server 2016 Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a clear, concise tutorial approach.
Описание: What is this book about? (DTS) Data Transformation Services helps you create a transactional system to load and transform your data from and to a wide variety of sources. SQL Server DTS was introduced in the release of SQL Server 7.0; however, SQL Server 2000 sees the functionality and power of this outstanding and incredibly useful tool greatly increased. DTS can be used to maximum effect in data--driven applications, offering rapid and effective solutions to a wide range of common problems. Professional SQL Server 2000 DTS provides a complete introduction to DTS fundamentals and architecture before exploring the more complex data transformations involved in moving data between different servers, applications, and providers. The book then focuses on DTS programming via the DTS object model, enabling developers to incorporate custom transformations and reporting capabilities into their applications. Advanced topics are explained including error handling, dynamic data loading, and data warehouses. With code and case studies, this book gives the reader a complete picture of how to use DTS to its fullest potential. What does this book cover? Here are just a few of the things you'll find covered in this book: A detailed explanation of the seventeen principal DTS tasks Connecting to, querying, and converting heterogeneous data Dynamic configuration of your DTS packages Enhancing your DTS packagwith VBScript and Visual Basic Writing your own custom tasks Using DTS in a data--warehousing environment Employing DTS in other applications Who is this book for? This book is principally aimed at database programmers and administrators who have a working knowledge of SQL Server, and who wish to take DTS beyond its most basic level and tailor it to their needs. It will also appeal to managers and project managers who want to gain an understanding of DTS and how it could benefit their businesses.
Автор: Larson, Brian Название: Microsoft sql server 2008 reporting services ISBN: 0071548084 ISBN-13(EAN): 9780071548083 Издательство: McGraw-Hill Рейтинг: Цена: 4388 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Explains how to create, manage, and deliver traditional and interactive reports with SQL Server 2008 Reporting Services. This guide covers the report-building and distribution process, including data extraction, integration with desktop and Web applications, and end-user access. It contains more than 60 practical, reusable report and code samples.
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru