Автор: LaRock Название: Pro SQL Server 2022 Wait Statistics ISBN: 1484287703 ISBN-13(EAN): 9781484287705 Издательство: Springer Рейтинг: Цена: 7317.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You'll learn to identify precisely why your queries are running slowly. And you'll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest improvements first. This edition is updated to cover analysis of wait statistics current with SQL Server 2022. Whether you are new to wait statistics, or already familiar with them, this book provides a deeper understanding on how wait statistics are generated and what they mean for your SQL Server instance’s performance. The book goes beyond the most common wait types into the more complex and performance-threatening wait types. You’ll learn about per-query wait statistics and session-based wait statistics, and the types of problems they can help you solve. The different wait types are categorized by their area of impact, including CPU, IO, Latching, Locking, and many more. Clear examples are included to help you gain practical knowledge of why and how specific wait times increase or decrease, how they impact your SQL Server’s performance, and what you can do to improve performance. After reading this book, you won’t want to be without the valuable information that wait statistics provide regarding where you should be spending your limited tuning time to maximize performance and value to your business. What You'll Learn * Understand how the SQL Server engine processes requests * Identify resource bottlenecks in a running SQL Server instance * Locate wait statistics information inside DMVs and Query Store * Analyze the root cause of sub-optimal performance * Diagnose I/O contention and locking contention * Benchmark SQL Server performance * Improve database performance by lowering overall wait time Who This Book Is For Database administrators who want to identify and resolve performance bottlenecks, those who want to learn more about how the SQL Server engine accesses and uses resources inside SQL Server, and administrators concerned with achieving—and knowing they have achieved—optimal performance
8. Data Protection Patterns with Check Constraints and Triggers
9. Patterns and Anti-Patterns
10. Database Security and Security Patterns
11. Data Structures, Indexes, and Their Applications
12. Matters of Concurrency
13. Coding Architecture
14. Appendix A: Scalar Datatype Reference.
Автор: Guay Paz, Jose Rolando Название: Microsoft azure cosmos db revealed ISBN: 1484233506 ISBN-13(EAN): 9781484233504 Издательство: Springer Рейтинг: Цена: 5487.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Learn the main features of Azure Cosmos DB and how to use Microsoft’s multi-model database service as a data store for mission-critical applications. The clear examples help in writing your own applications to take advantage of Cosmos DB’s multi-model, globally distributed, elastic database. Simple step-by-step instructions show how to resolve common and uncommon scenarios involving Azure Cosmos DB, and scenarios such as delivering extremely low response times (in the order of milliseconds), and scaling rapidly and globally.
Microsoft Azure Cosmos DB Revealed demonstrates a multitude of possible implementations to get you started. This book guides you toward best practices to get the most out of Microsoft’s Cosmos DB service. Later chapters in the book cover advanced implementation features, helping you master important elements such as securing the database, querying, and using various APIs.
What You'll Learn
Set up a development environment to work with Azure Cosmos DBConfigure Azure Cosmos DB in a production environment with multi-region distributionQuery using all APIs, including SQL, JavaScript, MongoDB, and GraphWork with the Azure Cosmos DB.NET SDK in an application you builtAccess Cosmos DB from web applications created in .NET
Who This Book Is For
Developers who build applications to be hosted in Microsoft Azure, whether they use PaaS or IaaS. No previous knowledge of Azure Cosmos DB is assumed, but readers must be familiar with developing applications in Microsoft Visual Studio.
Описание: As the cloud version of SQL Server, Azure SQL Database differs in key ways when it comes to management, maintenance, and administration. It`s important to know how to administer SQL Database to fully benefit from all of the features and functionality that it provides. This book addresses important aspects of an Azure SQL Database instance such ...
Описание: Know how to track changes and key events in your SQL Server databases in support of application troubleshooting, regulatory compliance, and governance. This book shows how to use key features in SQL Server ,such as SQL Server Audit and Extended Events, to track schema changes, permission changes, and changes to your data. You’ll even learn how to track queries run against specific tables in a database. Not all changes and events can be captured and tracked using SQL Server Audit and Extended Events, and the book goes beyond those features to also show what can be captured using common criteria compliance, change data capture, temporal tables, or querying the SQL Server log. You will learn how to audit just what you need to audit, and how to audit pretty much anything that happens on a SQL Server instance. This book will also help you set up cloud auditing with an emphasis on Azure SQL Database, Azure SQL Managed Instance, and AWS RDS SQL Server. You don’t need expensive, third-party auditing tools to make auditing work for you, and to demonstrate and provide value back to your business. This book will help you set up an auditing solution that works for you and your needs. It shows how to collect the audit data that you need, centralize that data for easy reporting, and generate audit reports using built-in SQL Server functionality for use by your own team, developers, and organization’s auditors. What You Will Learn * Understand why auditing is important for troubleshooting, compliance, and governance * Track changes and key events using SQL Server Audit and Extended Events * Track SQL Server configuration changes for governance and troubleshooting * Utilize change data capture and temporal tables to track data changes in SQL Server tables * Centralize auditing data from all your databases for easy querying and reporting * Configure auditing on Azure SQL, Azure SQL Managed Instance, and AWS RDS SQL Server Who This Book Is For Database administrators who need to know what’s changing on their database servers, and those who are making the changes; database-savvy DevOps engineers and developers who are charged with troubleshooting processes and applications; developers and administrators who are responsible for generating reports in support of regulatory compliance reporting and auditing
Описание: Updated to include coverage of the latest `DBPro` extension for database professionals this book is the only reference needed to get started with Visual Studio 2005 Team System. If you are a developer, you will learn how to write higher-quality code, and ensure that the code works and performs well.
Автор: Roberts, Rosie Название: Ongoing mobility trajectories ISBN: 9811331634 ISBN-13(EAN): 9789811331633 Издательство: Springer Рейтинг: Цена: 10366.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: This book explores the complex category of the ‘skilled migrant,’ drawing on multi-sited narrative interviews with migrants who have all lived in Australia at some point in their lives (as an origin and/or destination). Developing the more nuanced concept of the ‘mobile settler’, it shows how becoming a skilled migrant is not just a political and economic determination of knowledge and human capital but a complex negotiation of contexts – immigration contexts, social locations, qualifications and skills, as well as personal ties. Belying the simple binaries of official visa categories, these diverse contexts of migrant experience are central to the ways migrants construct their personal histories and negotiate their shifting attachments to home and belonging over time and space. By highlighting how migrants imagine their own complex social, cultural, national, professional and linguistic identities and pathways, this book extends the agent-centred approaches to global mobility and transnationalism that have emerged in cultural studies and social and cultural geography in recent years, according greater recognition to the individualised, local and lived experiences of global migration and thus engaging more deeply with global concerns about increased mobility and the challenges it represents.
Автор: Lloyd Название: Infrastructure Leader`s Guide to Google Cloud ISBN: 148428819X ISBN-13(EAN): 9781484288191 Издательство: Springer Рейтинг: Цена: 5487.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Making fast and accurate technology decisions is critical to staying relevant to your customers. And technology needs to add value back to your organization quicker than ever. Google Cloud offers IT leaders the answer to today’s technology challenges. However, to realize its benefits you must navigate your journey without hitting common pitfalls that lead to stalled and unsuccessful cloud adoption. This book distills the lessons learned from guiding and working with hundreds of organizations on their journey to the cloud. Its goal is to give aspiring and current IT leaders the knowledge required to be an infrastructure leader. That is the term author Jeremy Lloyd uses for the person who can lead your organization's Google Cloud adoption strategy. Of course, cloud adoption isn’t a solo endeavor. Jeremy covers the different generations of IT leaders, the team structure, and the skills required for a successful migration to Google Cloud. This book also covers why you should choose Google Cloud, how to build a business case for the cloud, and defining your adoption/migration/modernization strategies and cloud operating model. Finally, the book covers how to empower your developers to deploy cloud-native applications and how to support day two operations once you have moved to Google Cloud. What You Will Learn * Use Google Cloud to add value to your organization * Define and lead your Google Cloud adoption strategy * Migrate and modernize your workloads * Operate workloads once in Google Cloud and avoid antipatterns * Understand how the infrastructure team can be enablers for cloud-native development Who This Book Is For Current infrastructure/IT/technology leaders who need guidance for their Google Cloud adoption, migration, and modernization journey; IT managers, IT team leads and IT professionals aspiring to be the next IT leaders who must learn to navigate more than just technical complexity.
Автор: Sherif Talaat Название: Pro PowerShell for Microsoft Azure ISBN: 1484206665 ISBN-13(EAN): 9781484206669 Издательство: Springer Рейтинг: Цена: 5482.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание:
Chapter 1: Introduction to Microsoft Azure Architecture and Services
Chapter 2: Getting Started with Azure PowerShell
Chapter 3: Managing and Maintaining Azure Storage
Chapter 4: Virtual Machine Management
Chapter 5: Configuring an Azure Virtual Network
Chapter 6: Deploying Azure Web Sites
Chapter 7: Administering Azure Cloud Services
Chapter 8: Configuring the Azure Resource Manager
Chapter 9: Automating Azure Services and Workloads
Chapter 10: Working with Azure SQL Database
Chapter 11: Hadoop in the Cloud with Azure HDInsight
Chapter 12: Azure Identity and Access
Автор: Rouleau, Derek J. Название: Beginning entity framework core 2.0 ISBN: 1484233743 ISBN-13(EAN): 9781484233740 Издательство: Springer Рейтинг: Цена: 4877.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание:
Use the valuable Entity Framework Core 2.0 tool in ASP.NET and the .NET Framework to eliminate the tedium around accessing databases and the data they contain.
Entity Framework Core 2.0 greatly simplifies access to relational databases such as SQL Server that are commonly deployed in corporate settings. By eliminating tedious data access code that developers are otherwise forced to use, Entity Framework Core 2.0 enables you to work directly with the data in a database through domain-specific objects and methods.
Beginning Entity Framework Core 2.0 is a carefully designed tutorial. Throughout the book you will encounter examples that you can use in your day-to-day coding, and you will build a solid foundation on which to create database-backed applications. If you are looking for a way to get started without getting buried under details you are only going to forget, then this is the book for you.
The author aims to leave you comfortably able to connect to, access, modify, and delete data from a relational database. The book provides a clear, straightforward approach and includes code that you can look back at months later and understand.
What You'll Learn
Study easy-to-follow, real-world examples you can use every dayFocus on DbContext and the Database First approachUnderstand how to work with single and multiple tablesUse the LINQ query language to manipulate data
Who This Book Is For
C# and ASP.NET programmers looking for an easier way of accessing data in a relational database than writing in SQL—a way that meshes better into object-oriented application development
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru
