SQL Server Query Tuning and Optimization. Optimize Microsoft SQL Server 2022 queries and applications

Benjamin Nevarez

SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications.This book starts by describing the inner workings of the query optimizer, and will enable you to use this knowledge to write better queries and provide the query engine with all the information it needs to produce efficient execution plans. As you progress, you’ll get practical query optimization tips for troubleshooting underperforming queries. The book will also guide you through intelligent query processing and what is new in SQL Server 2022. Query performance topics such as the Query Store, In-Memory OLTP and columnstore indexes are covered as well.By the end of this book, you’ll be able to get the best possible performance for your queries and applications.

Learning ArcGIS Geodatabases. An all-in-one start up kit to author, manage, and administer ArcGIS geodatabases

Hussein Nasser

Migrating Applications to the Cloud with Azure. Re-architect and rebuild your applications using cloud-native technologies

Sjoukje Zaal, Amit Malik, Sander Rossel, Jason Marston, ...

Whether you are trying to re-architect a legacy app or build a cloud-ready app from scratch, using the Azure ecosystem with .NET and Java technologies helps you to strategize and plan your app modernization process effectively. With this book, you’ll learn how to modernize your applications by using Azure for containerization, DevOps, microservices, and serverless solutions to reduce development time and costs, while also making your applications robust, secure, and scalable.You will delve into improving application efficiency by using container services such as Azure Container Service, Azure Kubernetes Service (AKS), and more. Next, you will learn to modernize your application by implementing DevOps throughout your application development life cycle. You will then focus on increasing the scalability and performance of your overall application with microservices, before learning how to add extra functionality to your application with Azure serverless solutions. Finally, you’ll get up to speed with monitoring and troubleshooting techniques.By the end of this book, you will have learned how to use the Azure ecosystem to refactor, re-architect, and rebuild your web, mobile, and desktop applications.

Android NDK Game Development Cookbook. For C++ developers, this is the book that can swiftly propel you into the potentially profitable world of Android games. The 70+ step-by-step recipes using Android NDK will give you the wide-ranging knowledge you need

Sergey Kosarevsky, Viktor Latypov

Android NDK is used for multimedia applications which require direct access to a system's resources. Android NDK is also the key for portability, which in turn provides a reasonably comfortable development and debugging process using familiar tools such as GCC and Clang toolchains. If your wish to build Android games using this amazing framework, then this book is a must-have.This book provides you with a number of clear step-by-step recipes which will help you to start developing mobile games with Android NDK and boost your productivity debugging them on your computer. This book will also provide you with new ways of working as well as some useful tips and tricks that will demonstrably increase your development speed and efficiency.This book will take you through a number of easy-to-follow recipes that will help you to take advantage of the Android NDK as well as some popular C++ libraries. It presents Android application development in C++ and shows you how to create a complete gaming application. You will learn how to write portable multithreaded C++ code, use HTTP networking, play audio files, use OpenGL ES, to render high-quality text, and how to recognize user gestures on multi-touch devices. If you want to leverage your C++ skills in mobile development and add performance to your Android applications, then this is the book for you.

Instant Microsoft Forefront UAG Mobile Configuration Starter. Everything you need to get started with UAG and its features for mobile devices

Fabrizio Volpe

UAG provides your employees, clients, or partners secure remote access to your vital corporate resources, while delivering a seamless integration with your existing network environment. UAG is able to optimize content for different mobile devices, and is also able to publish complex applications in a simple manner. You are also able to integrate UAG with multiple domains and federated authentications, to give the highest quality service in a mobility scenario. Instant Microsoft Forefront UAG Mobile Configuration Starter is a concise and informative book that allows you to set up and start using UAG without any existing knowledge of the area.This book will start by expertly guiding you through the installation and setup of UAG, and then show you how to publish a simple application for mobile devices, in order to familiarize you with concepts and operations that you will use throughout with UAG.The main body of the book focuses on a series of essential, and incredibly practical, recipes and examples designed to help you in utilizing UAG features for their maximum effect. By the end of Instant Microsoft Forefront UAG Mobile Configuration Starter, you will know all the vital information you need to deploy UAG in a successful and efficient manner, in order to tailor the configuration to your company’s specific requirements.

LLVM Techniques, Tips, and Best Practices Clang and Middle-End Libraries. Design powerful and reliable compilers using the latest libraries and tools from LLVM

Min-Yih Hsu

Every programmer or engineer, at some point in their career, works with compilers to optimize their applications. Compilers convert a high-level programming language into low-level machine-executable code. LLVM provides the infrastructure, reusable libraries, and tools needed for developers to build their own compilers. With LLVM’s extensive set of tooling, you can effectively generate code for different backends as well as optimize them.In this book, you’ll explore the LLVM compiler infrastructure and understand how to use it to solve different problems. You’ll start by looking at the structure and design philosophy of important components of LLVM and gradually move on to using Clang libraries to build tools that help you analyze high-level source code. As you advance, the book will show you how to process LLVM IR – a powerful way to transform and optimize the source program for various purposes. Equipped with this knowledge, you’ll be able to leverage LLVM and Clang to create a wide range of useful programming language tools, including compilers, interpreters, IDEs, and source code analyzers.By the end of this LLVM book, you’ll have developed the skills to create powerful tools using the LLVM framework to overcome different real-world challenges.

SAP BusinessObjects Dashboards 4.0 Cookbook. Over 90 simple and incredibly effective recipes for transforming your business data into exciting dashboards with SAP BusinessObjects Dashboards 4.0 Xcelsius

Xavier Jean-Marie Hacking, David Lai, XJ Hacking

Xcelsius 2008 was recently included in SAP’s BusinessObjects 4.0 family, rebranding “Xcelsius Enterprise” as “SAP BusinessObjects Dashboards 4.0”. With features like flexible design and what-if scenarios, the powerful dashboarding software allows enterprises to make business decisions at a glance, and this book allows you to go far beyond the basics of these techniques. This cookbook full of practical and applicable recipes will enable you to use the full latest capabilities of Dashboard Design to visually transform your business data. A wide range of recipes will equip you with the knowledge and confidence to perform tasks like configuring charts, creating drill- downs, making component colors dynamic, using alerts in maps, building pop-up screens, setting up What-If scenarios, and many more.The recipes begin by covering best practices for using the Dashboard Design spreadsheet, the data-model, and the connection with the components on the canvas, later moving on to some from-the-trenches tricks for using Excel within Dashboard Design. The book then guides you through the exploration of various data visualization components and dashboard interactivity, as well as offering recipes on using alerts, dashboard connectivity, and making the most of the aesthetics of the dashboard. Finally, the recipes conclude by considering the most important add-ons available for Dashboard Design and enabling you to perform relevant and useful tasks straight away.

Working with Microsoft Forms and Customer Voice. Efficiently gather and manage customer feedback, insights, and experiences

Welly Lee, James Phillips, Ray Smith

Microsoft Forms and Dynamics 365 Customer Voice enable organizations to collect and analyze feedback from employees and customers, helping developers to integrate their feedback and business users to collect feedback that will guide them to develop customer-centric solutions.This book takes a hands-on approach to leveraging Microsoft Forms and Dynamics 365 Customer Voice capabilities for common feedback scenarios and covers best practices and tips and tricks to have your solution up and running in no time. You'll start by exploring common scenarios where organizations collect feedback from employees and customers and implement end-to-end solutions with Forms. You’ll then discover how to create surveys and get to grips with different configuration options commonly used for each scenario. Throughout the book, you'll also find sample questions and step-by-step instructions for integrating the survey with related technology such as Microsoft Teams, Power Automate, and Power BI for an end-to-end scenario.By the end of this Microsoft book, you’ll be able to build and deploy your complete solution using Microsoft Forms and Dynamics 365 Customer Voice, allowing you to listen to customers or employees, interpret their feedback, take timely follow-up action, and monitor results.