Описание: 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.
Автор: Jorgensen Название: Microsoft SQL Server 2012 Bible ISBN: 1118106873 ISBN-13(EAN): 9781118106877 Издательство: Wiley Рейтинг: Цена: 7524.00 р. Наличие на складе: Поставка под заказ.
Описание: Harness the powerful new SQL Server 2011 Microsoft SQL Server 2011 is the most significant update to this product since 2005, and it may change how database administrators and developers perform many aspects of their jobs. If you're a database administrator or developer, Microsoft SQL Server 2011 Bible teaches you everything you need to take full advantage of this major release. This detailed guide not only covers all the new features of SQL Server 2011, it also shows you step by step how to develop top-notch SQL Server databases and new data connections and keep your databases performing at peak. The book is crammed with specific examples, sample code, and a host of tips, workarounds, and best practices. In addition, downloadable code is available from the book's Companion website, which you can use to jumpstart your own projects. Serves as an authoritative guide to Microsoft's SQL Server 2011 for database administrators and developers Covers all the software's new features and capabilities, including SQL Azure for cloud computing, enhancements to client connectivity, and new functionality that ensures high-availability of mission-critical applications Explains major new changes to the SQL Server Business Intelligence tools, such as Integration, Reporting, and Analysis Services Demonstrates tasks both graphically and in SQL code to enhance your learning Provides source code from the Companion website, which you can use as a basis for your own projects Explores tips, smart workarounds, and best practices to help you on the job Get thoroughly up to speed on SQL Server 2011 with Microsoft SQL Server 2011 Bible.
Автор: Sarka Dejan, Radivojevic Milos, Durkin William Название: SQL Server 2017 Developer`s Guide ISBN: 1788476190 ISBN-13(EAN): 9781788476195 Издательство: Неизвестно Рейтинг: Цена: 11217.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: This book is your guide to exploring the various developer capabilities offered by SQL Server 2017. Model your data and the complex relationships within it, and integrate SQL Server with R and Python for efficient analytics. The book also covers the performance and troubleshooting aspects to help you develop efficient database applications.
Автор: Korotkevitch, Dmitri Название: Expert sql server transactions and locking ISBN: 1484239563 ISBN-13(EAN): 9781484239568 Издательство: Springer Рейтинг: Цена: 8384.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание:
Master SQL Server’s Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurrency issues in the systems you develop.
SQL Server’s Concurrency Model is one of the least understood parts of the SQL Server Database Engine. Almost every SQL Server system experiences hard-to-explain concurrency and blocking issues, and it can be extremely confusing to solve those issues without a base of knowledge in the internals of the Engine. While confusing from the outside, the SQL Server Concurrency Model is based on several well-defined principles that are covered in this book.
Understanding the internals surrounding SQL Server’s Concurrency Model helps you build high-throughput systems in multi-user environments. This book guides you through the Concurrency Model and elaborates how SQL Server supports transactional consistency in the databases. The book covers all versions of SQL Server, including Microsoft Azure SQL Database, and it includes coverage of new technologies such as In-Memory OLTP and Columnstore Indexes.
What You'll Learn
Know how transaction isolation levels affect locking behavior and concurrencyTroubleshoot and address blocking issues and deadlocksProvide required data consistency while minimizing concurrency issuesDesign efficient transaction strategies that lead to scalable codeReduce concurrency problems through good schema designUnderstand concurrency models for In-Memory OLTP and Columnstore IndexesReduce blocking during index maintenance, batch data load, and similar tasks
Who This Book Is For
SQL Server developers, database administrators, and application architects who are developing highly-concurrent applications. The book is for anyone interested in the technical aspects of creating and troubleshooting high-throughput systems that respond swiftly to user requests.
Автор: Wilson Derek Название: Tabular Modeling with SQL Server 2016 Analysis Services Cook ISBN: 1786468611 ISBN-13(EAN): 9781786468611 Издательство: Неизвестно Рейтинг: Цена: 11217.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Автор: Kehayias Jonathan, Krueger Ted Название: Troubleshooting SQL Server - A Guide for the Accidental DBA ISBN: 1906434786 ISBN-13(EAN): 9781906434786 Издательство: Неизвестно Цена: 4964.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Get SQL Server up and running on the Linux operating system and containers. No database professional managing or developing SQL Server on Linux will want to be without this deep and authoritative guide by one of the most respected experts on SQL Server in the industry. Get an inside look at how SQL Server for Linux works through the eyes of an engineer on the team that made it possible. Microsoft SQL Server is one of the leading database platforms in the industry, and SQL Server 2017 offers developers and administrators the ability to run a database management system on Linux, offering proven support for enterprise-level features and without onerous licensing terms. Organizations invested in Microsoft and open source technologies are now able to run a unified database platform across all their operating system investments. Organizations are further able to take full advantage of containerization through popular platforms such as Docker and Kubernetes. Pro SQL Server on Linux walks you through installing and configuring SQL Server on the Linux platform. The author is one of the principal architects of SQL Server for Linux, and brings a corresponding depth of knowledge that no database professional or developer on Linux will want to be without. Throughout this book are internals of how SQL Server on Linux works including an in depth look at the innovative architecture. The book covers day-to-day management and troubleshooting, including diagnostics and monitoring, the use of containers to manage deployments, and the use of self-tuning and the in-memory capabilities. Also covered are performance capabilities, high availability, and disaster recovery along with security and encryption. The book covers the product-specific knowledge to bring SQL Server and its powerful features to life on the Linux platform, including coverage of containerization through Docker and Kubernetes. What You'll Learn
Learn about the history and internal of the unique SQL Server on Linux architecture.
Install and configure Microsoft's flagship database product on the Linux platform
Manage your deployments using container technology through Docker and Kubernetes
Know the basics of building databases, the T-SQL language, and developing applications against SQL Server on Linux
Use tools and features to diagnose, manage, and monitor SQL Server on Linux
Scale your application by learning the performance capabilities of SQL Server
Deliver high availability and disaster recovery to ensure business continuity
Secure your database from attack, and protect sensitive data through encryption
Take advantage of powerful features such as Failover Clusters, Availability Groups, In-Memory Support, and SQL Server's Self-Tuning Engine
Learn how to migrate your database from older releases of SQL Server and other database platforms such as Oracle and PostgreSQL
Build and maintain schemas, and perform management tasks from both GUI and command line
Who This Book Is For Developers and IT professionals who are new to SQL Server and wish to configure it on the Linux operating system. This book is also useful to those familiar with SQL Server on Windows who want to learn the unique aspects of managing SQL Server on the Linux platform and Docker containers. Readers should have a grasp of relational database concepts and be comfortable with the SQL language.
Описание: Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You'll learn exactly what happens under the hood when you run a DAX expression, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services. Want to leverage all of DAX's remarkable capabilities? This no-compromise "deep dive" is exactly what you need.
Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel - Master core DAX concepts, including calculated columns, measures, and calculation groups - Work efficiently with basic and advanced table functions - Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions - Perform time-based calculations - Use calculation groups and calculation items - Use syntax of variables (VAR) to write more readable, maintainable code - Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters - Master advanced optimization techniques, and improve performance in aggregations - Optimize data models to achieve better compression - Measure DAX query performance with DAX Studio and learn how to optimize your DAX
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru
