SQL Server 2022 Query Performance Tuning, 6th Edition
Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan correction, and other advanced features now available in SQL Server. These modern features are covered while still providing the necessary fundamentals to better understand how statistics and indexes affect query performance.
The book gives you knowledge and tools to help you identify poorly performing queries and understand the possible causes of that poor performance. The book also provides mechanisms for resolving the issues identified, whether on-premises, in containers, or on cloud platform providers. You'll learn about key fundamentals, such as statistics, data distribution, car ...
Power Platform and Dynamics 365 CE for Absolute Beginners
This is your complete guide to less-code and no-code theories, along with practical application of Microsoft Power Apps and Dynamics 365 CE/CRM Apps.
The book covers topics including the configurations, customizations, and enhancements in Microsoft Power Apps and Dynamics 365 CE/CRM Apps. You will start by learning Microsoft Dataverse concepts followed by Microsoft Canvas Apps, model-driven apps, and PowerApps Portals. You will understand how to work with Power Virtual Agent, Power BI, and Power Automate, and how to use AI in Power Apps. The book provides important integration concepts for Power Apps, Dynamics 365 CE/CRM Apps, and Microsoft Azure. You will know how to customize Dynamics 365 CE/CRM Apps and Power Apps using OOTB capabilities.
After reading this book, you will understand how Microsoft Power Apps and Dynamics 365 CE/CRM Apps can be used, configured, and customized for your business needs using customer data. You will be able to increase efficiency in customer data m ...
The Essential Guide to HTML5, 3rd Edition
You'll begin at an introductory level with the focus on technical features as well as programming techniques. Each chapter features a familiar game such as Rock-Paper-Scissors, Craps, Memory, and Blackjack or generic examples such as working with Mazes. Other projects include constructing and saving a maze; a basic word guessing game; ballistic games (Cannonball and Slingshot); a quiz requiring items to be put in order; and an animation demonstration featuring a ball, photo or video clip bouncing within a rectangle.
The Appendix contains examples of advanced techniques such as Scalar Vector Graphics progra ...
Workload Automation Using HWA
Apply best practices for deploying and administering HCL Workload automation (HWA) to meet the automation requirements of the digitally transformed platform. This book will provide detailed architecture and deployment options to achieve this goal.
Workload automation focuses on real-time processing, predefined event-driven triggers, and situational dependencies. It offers centralized control of managing multiple tasks, making it possible to schedule enterprise-wide tasks. You'll see how it supports the timely completion of tasks and is beneficial for processes that need to happen at a specific time or need to occur as a result of another event.
HWA increases efficiency, reduces the turnaround time for workflows, and reduces errors along with delays in end-to-end processes. You'll review proven ways to deliver batch optimization and modernization requirements, and see how solutions can be aligned with the DevSecOps delivery model. Workload Automation Using HWA presents informatio ...
Sound and Music for Games
Grasp the fundamentals of digital audio work in the context of video games, including the basics of middleware such as Fmod and Wwise. We will review software such as Apple's Logic and Garageband, Paul Davis's Ardour, and many other popular digital audio workstations.
We will start with an introduction to the basic terminology of digital audio work while also getting acquainted with current generation audio hardware. We will then discuss the basics of the venerable Musical Instrument Digital Interface (MIDI) and how it relates to music composition as well as the tools and techniques for writing tracker music/chiptunes. The book also covers plug-in software, soundproofing at home, and voice work.
The book takes a practical approach while tackling both hardware and software components used in cutting edge audio engineering, composition, and audio monitoring. ...
Master the fundamental programming skills needed to create your own computer games in GameMaker. This book shows how to use GameMaker to build and publish cross-platform games.
Each chapter covers a certain programming element, including layers, variables, and so on. You will also learn how to design levels in your games, draw sprites to populate your virtual worlds, and build GUIs for your menus and game interfaces. GameMaker Fundamentals also provides a thorough introduction to the GameMaker Language (GML). Practical example projects reinforce the concept discussed in each chapter.
On completing this book, you will have a thorough understanding of how to create games from scratch using game design and programming principles using GameMaker and GML. ...
Modern Concurrency on Apple Platforms
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.
Using the new async/await APIs in Swift, this book will explain how your code can abstract a lot of the complexity with a simpler interface so you never have to deal with concurrency primitives such as semaphores, locks, and threads yourself. This will allow you to write concurrent code that is easier to read, easier to write, and easier to maintain. These new APIs are deeply ingrained into Swift, offering compile-level features that will keep you from writing dangerous concurrent code.
You'll start by exploring why concurrency is hard to implement in a traditional system. Explaining the definition of concurrency and what its pri ...
Practical MATLAB Deep Learning, 2nd Edition
Harness the power of MATLAB for deep-learning challenges. Practical MATLAB Deep Learning, Second Edition, remains a one-of a-kind book that provides an introduction to deep learning and using MATLAB's deep-learning toolboxes. In this book, you'll see how these toolboxes provide the complete set of functions needed to implement all aspects of deep learning. This edition includes new and expanded projects, and covers generative deep learning and reinforcement learning.
Over the course of the book, you'll learn to model complex systems and apply deep learning to problems in those areas. Applications include: Aircraft navigation; An aircraft that lands on Titan, the moon of Saturn, using reinforcement learning; Stock market prediction; Natural language processing; Music creation usng generative deep learning; Plasma control; Earth sensor processing for spacecraft; MATLAB Bluetooth data acquisition applied to dance physics. ...
Beginning Spring Boot 3, 2nd Edition
Learn the Spring Boot 3 micro framework and build your first Java-based cloud-native applications and microservices. Spring Boot is the lightweight, nimbler cousin to the bigger Spring Framework, with plenty of "bells and whistles." This updated edition includes coverage of Spring Native, which will help you speed up your Spring Boot applications, as well as messaging with Spring Boot, Spring GraphQL, Spring Data JDBC and reactive relational database connectivity (R2DBC) with SQL.
This new edition also covers enhancements to actuator endpoints, MongoDB 4.0 support, layered JAR and WAR support, support to build OCI images using Cloud Native Build Packs, changes to the DataSource initialization mechanism, and how bean validation support has moved to a separate spring-boot-validation-starter module. This book will teach you how to work with relational and NoSQL databases for data accessibility using Spring Boot with Spring Data, how to persist data with the Java Persistence APIs (JPA), ...
Modern Full-Stack Development, 2nd Edition
Explore what React, Node, Python, Django, TypeScript, Webpack, and Docker have to offer individually, and how they all fit together in modern app development. This updated version will show you how to build apps with React, Node.js or Django, and TypeScript, and how Webpack can be used to optimize and organize your code for deployment.
You'll begin by building a solid foundation of knowledge and quickly expand it by constructing three different real-world apps. These aren't just simple, contrived examples but real apps that you can choose to install on your servers and use for real. You'll also understand how Docker can be used to run the apps you build in a clear and well-defined way, all of which will be able to springboard you into creating more advanced apps on your own.
Here is your perfect companion for learning about and developing React applications. This book introduces concepts innovatively, using real-world examples based on the most recommended practices to help you establish a firm foundation. This comprehensive approach provides a strong focus on building components by using React hooks.
You'll then take an in depth look at React hooks and see how to create a custom hook. There is also a penultimate chapter that explores important concepts such as routing and authentication. The book concludes with a review of some ex ...