Professional and Applied Computing (R0)

Here is a practical guide for analyzing and troubleshooting SQL Server performance using wait statistics. Learn to identify precisely why your queries are running slowly. Measure the amount of time consumed by each bottleneck so that you can focus attention on making the largest improvements first. This edition is updated to cover analysis of wait statistics inside Query Store, the CXCONSUMER wait event, and to be current with SQL Server 2019. 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 can mean for your SQL Server instance’s performance. 

Pro SQL Server 2019 Wait Statistics 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 each can help you solve. The different wait types are categorized by their area of impact, including CPU, IO, Lock, and many more.

The book presents clear examples to help you gain practical knowledge of why and how specific wait times increase or decrease, and how they impact your SQL Server’s 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

• 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
  
• Lower the wait time of the most popular wait types
  

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

You will start off learning basic concepts and get a bird's-eye view of the enabling technologies to ensure that you feel comfortable with the tools and terminology. From there, you will learn about some of the more popular options in the .NET ecosystem, understand their attributes and shortcomings, and learn why the Uno Platform is ideal for building a cross-platform application that targets Android, iOS, Windows, WASM (Web Assembly), Linux, and MacOS.

Then, you will follow a product release timeline that takes you through building an application, introducing key concepts at every step of the way. Each section of the book is chock full of tips and edge case documentations for the different platforms.

What You Will Learn

• Manage multi-targeting solutions: specifically, how to handle the different project heads
• Effectively write cross-platform software and handle the edge cases of the different platforms
• Understand the fundamentals of working with Uno Platform WinUI apps
• Explore enterprise-grade application architecture using MVVM
• Understand Dependency Injection and how it applies to application architecture

Who This Book Is For

Developers who understand some basics of C# and object-oriented programming

Build solid software with modern and safe concurrency features. Concurrency is one of the hardest problems in computer science. For years, computer scientists and engineers have developed different strategies for dealing with concurrency. However, the original concurrency primitives are complicated and difficult to understand, and even harder to implement.

You’ll start by exploring why concurrency is hard to implement in a traditional system. Explaining the definition of concurrency and what its primitives are will help you understand why they are hard to use correctly. These concepts will become clearer as you work through the sample projects. The book’s focus then shifts exclusively to the new APIs, helping you understand how the integration of the system with the language itself makes it easier for you to write concurrent code without overstepping the bounds of the concurrency safe zone.

By the end of the book, you’ll have a solid foundation for working safely with concurrent code using the new async/await APIs.

What You'll Learn

• Understand concurrency and its traditional problems
• Work with the new async/await API and all its features, from the basic usage and await keywords, to task groups and async sequences.
• Implement modern and safe concurrent code that you can start using right away

Who This Book Is For 

Experienced iOS developers at a semi-senioror senior level. Knowledge on the Grand Central Dispatch is a bonus, but not required.

Examine the working details for real-world Java programs used for system integration with IBM Software, applying various API libraries (as used by Banking and Insurance companies). This book includes the step-by-step procedure to use the IBM FileNet Case Manager 5.3.3 Case Builder solution and the similar IBM System, IBM Business Automation Workflow to create an Audit System. 

You'll learn how to implement the workflow with a client Java Message Service (JMS) java method developed with Workflow Custom Operations System Step components. Using IBM Cognos Analytics Version 11.2, you'll be able to create new views for IBM Case Manager Analytics for custom time dimensions. The book also explains the SQL code and procedures required to create example Online Analytical Processing (OLAP) cubes with multi-level time dimensions for IBM Case Manager analytics.

IBM Software Systems Integration features the most up to date systems software procedures using tested API calls.

What You Will Learn

• Review techniques for generating custom IBM JMS code
• Create a new custom view for a multi-level time dimension
  
• See how a java program can provide the IBM FileNet document management API calls for content store folder and document replication
• Configure Java components for content engine events
  

Who This Book Is For

Learn how to use the Processing programming language and environment to create Android applications with ease. This book covers the basics of the Processing language, allowing users to effectively program interactive graphics in 2D, 3D, and Extended Reality (XR). It also details the application of these techniques to different types of Android devices (smartphones, tablets, wearables, and smartwatches). 

This updated edition walks you through the entire process of creating an app, from the initial idea to release of the final app via the Google Play App Store. Over the course of the book, you’ll learn to write engaging apps driven by user interaction and sensor data. A comprehensive series of hands-on projects, ranging from simple sketches to more complex projects involving shaders, VR, and AR will give you the firsthand experience you need to begin developing your own projects.

And once you have your Processing projects completed, you’ll be able to upload them to the Google Play store to be shared with the world!

What You Will Learn

• Write apps and live wallpapers for smartphones and tablets
• Design and implement interactive watch faces
• Create Extended Reality (VR/AR) experiences
• Incorporate GLSL shaders into your Processing apps
• Integrate Processing sketches into larger apps and Android Studio
• Learn how to write your own libraries to share with the community
• Export projects as completed apps ready to distribute through Google Play Store

Who This Book Is For

Supercomputers and High Performance Computing (HPC) clusters are not so exotic as people imagine these days. They give companies the power of computation like no one server can give alone.  They make new drugs and materials discoveries, universe modeling and AI training, crash simulations and market research possible – all thanks to HPC clusters. Building or renting a HPC cluster is not so difficult either as cloud providers can give you resources to build one cheap and performative enough to use yourself, so If you are or want to become HPC cluster Sysadmin or manager, this book is for you.

Supercomputers for Linux SysAdmins delves into the world of modern HPC cluster architecture, hardware, software and resources management using a Linux/UNIX based approach. The number of HPC clusters is growing with an estimated 30 billion by 2030 but there are not enough sysadmins to run and manage them, this book serves to bridge this gap to help more Sysadmins and managers to transition into the exiting world of HPCs. 

This book helps those with a strong foundational knowledge in Linux, to deal with supercomputers and HPC clusters. We start with the basic principles of supercomputer management, fundamentals of Linux and UNIX, Shell Scripting and systemd and well as other open source tools and frameworks, taking you thorough the security, monitoring and hardware requirements for supercomputers and HPC clusters.

You Will Learn:

• How to plan new supercomputers
• The main principles and technologies used in supercomputers and HPC clusters
• How to set up the software environments on new supercomputers 
• To set up supercomputer and HPC cluster resources and jobs management
• To manage accounts, resource sharing and many more.

Who is it for: 

The main audience of this book are regular UNIX/Linux sysadmins and managers, who should deal with HPC clusters on-prem or in cloud and those who are interested in supercomputers and HPC clusters and how to utilize them in their projects and teams.