- Table View
- List View
Pro Spring Boot 3 with Kotlin: In-Depth Guide to Best Practices for Cloud-Native and Microservices Development
by Peter Späth Felipe GutierrezQuickly and productively build complex Kotlin-based Spring applications and microservices out of the box, with minimal concern over things such as configurations. This revised edition will show you how to fully leverage the Spring Boot 3 micro-framework and apply it to create enterprise-ready Kotlin-based cloud-native applications, microservices, and web applications that just work. The book covers what has been added to the new Spring Boot 3 release, including improved support for the Kotlin programming language, changes to Stream Editor UI, Maven Preemptive Authentication, building Docker images using cloud-native build packs, building layered jars for optimized Docker images, E2E traceability for configuration properties, many dependency upgrades, support for Spring Data, and much more. This book is your in-depth pragmatic guide for increasing your enterprise Kotlin and cloud application productivity while decreasing development time. It is a no-nonsense guide with case studies of increasing complexity throughout the book. The main author, a senior solutions architect and Principal Technical instructor at Pivotal, the company behind the Spring Framework, shares his experience, insights, and first-hand knowledge about how Spring Boot technology works, and best practices. This is an essential book for your Kotlin-based Spring learning and reference library. What You Will Learn Build cloud-native apps and microservices with the Spring Boot 3 framework Persist and access your data using and integrating with Spring Data Message with Kafka, RabbitMQ, and WebSockets Explore Spring Cloud projects Extend Spring Boot by creating your own Spring Boot Starter and @Enable feature Test and deploy Spring Boot with best practices Effectively use Kotlin as a programming language for Spring applications Who This Book Is For Experienced Spring, Java, and Kotlin developers seeking increased productivity gains and decreased complexity and development time in their applications and software services
Pro Spring MVC with WebFlux: Web Development in Spring Framework 5 and Spring Boot 2
by Marten Deinum Iuliana CosminaExplore the designs of the Spring MVC and WebFlux frameworks, and apply similar designs and techniques to your own code. Along with detailed analysis of the code and functionality, this book includes numerous tips and tricks to help you get the most out of Spring MVC, WebFlux, and Java-based web application development in general using Spring. You’ll see how Spring MVC is a modern web application framework built upon the latest Spring Framework 5 and Spring Boot 2. Spring MVC is suitable for building reusable web controller modules that encapsulate rich page navigation rules.Pro Spring MVC with WebFlux takes great care in covering every inch of Spring MVC with WebFlux to give you the complete picture. Along with all the best-known features of these frameworks, you’ll discover some new hidden treasures. You’ll also learn how to correctly and safely extend the frameworks to create customized solutions. This book is for anyone who wishes to write robust, modern, and useful web applications with the Spring Framework. After reading and using this book, you'll become proficient with Spring MVC and be able to apply it to your own Java web applications and microservices. What You Will LearnUse Spring MVC with WebFlux to build Java-based web applicationsEmploy the various Spring MVC architecturesWork with controllers and routing functionsBuild microservices and web services using Spring MVC and RESTCreate reactive web applications using Spring WebFluxSecure Spring MVC and Spring WebFluxDeploy your Spring MVC application to the cloud Who This Book Is For Those with at least some prior experience with Java web application development. Some previous experience with Spring Boot or the Spring Framework is recommended.
Pro Spring Security: Securing Spring Framework 6 and Boot 3-based Java Applications
by Massimo Nardone Carlo ScarioniBuild and deploy secure Spring Framework and Spring Boot-based enterprise Java applications with the Spring Security Framework. This book explores a comprehensive set of functionalities to implement industry-standard authentication and authorization mechanisms for Java applications.Pro Spring Security, Third Edition has been updated to incorporate the changes in Spring Framework 6 and Spring Boot 3. It is an advanced tutorial and reference that guides you through the implementation of the security features for a Java web application by presenting consistent examples built from the ground up.This book also provides you with a broader look into Spring security by including up-to-date use cases such as building a security layer for RESTful web services and JSON Web Token applications.What You Will LearnExplore the scope of security and how to use the Spring Security FrameworkMaster Spring security architecture and design Secure the web tier in Spring Work with alternative authentication providersTake advantage of business objects and logic securityExtend Spring security with other frameworks and languagesSecure the service layerSecure the application with JSON Web TokenWho This Book Is ForExperienced Spring and Java developers with prior experience in building Spring Framework or Boot-based applications
Pro Spring Security: Securing Spring Framework 5 and Boot 2-based Java Applications
by Carlo Scarioni Massimo NardoneBuild and deploy secure Spring Framework and Spring Boot-based enterprise Java applications with the Spring Security Framework. This book explores a comprehensive set of functionalities to implement industry-standard authentication and authorization mechanisms for Java applications.Pro Spring Security, Second Edition has been updated to incorporate the changes in Spring Framework 5 and Spring Boot 2. It is an advanced tutorial and reference that guides you through the implementation of the security features for a Java web application by presenting consistent examples built from the ground up.This book also provides you with a broader look into Spring security by including up-to-date use cases such as building a security layer for RESTful web services and Grails applications.What You Will LearnExplore the scope of security and how to use the Spring Security FrameworkMaster Spring security architecture and design Secure the web tier in Spring Work with alternative authentication providersTake advantage of business objects and logic securityExtend Spring security with other frameworks and languagesSecure the service layerWho This Book Is ForExperienced Spring and Java developers with prior experience in building Spring Framework or Boot-based applications.
Pro SQL Server 2019 Administration: A Guide for the Modern DBA
by Peter A. CarterUse this comprehensive guide for the SQL Server DBA, covering all that practicing database administrators need to know to get their daily work done. Updated for SQL Server 2019, this edition includes coverage of new features such as Memory-optimized TempDB Metadata, and Always Encrypted with Secure Enclaves. Other new content includes coverage of Query Store, resumable index operations, installation on Linux, and containerized SQL.Pro SQL Server 2019 Administration takes DBAs on a journey that begins with planning their SQL Server deployment and runs through installing and configuring the instance, administering and optimizing database objects, and ensuring that data is secure and highly available. Finally, readers will learn how to perform advanced maintenance and tuning techniques.This book teaches you to make the most of new SQL Server 2019 functionality, including Data Discovery and Classification. The book promotes best-practice installation, shows how to configure for scalability and high workloads, and demonstrates the gamut of database-level maintenance tasks such as index maintenance, database consistency checks, and table optimizations. What You Will LearnInstall and configure SQL Server on Windows through the GUI and with PowerShell Install and configure SQL Server on Linux and in ContainersOptimize tables through in-memory OLTP, table partitioning, and the creation of indexesSecure and encrypt data to protect against embarrassing data breachesEnsure 24x7x365 access through high-availability and disaster recovery featuresBack up your data to ensure against loss, and recover data when neededPerform routine maintenance tasks such as database consistency checks Troubleshoot and solve performance problems in SQL queries and in the database engineWho This Book Is ForSQL Server DBAs who manage on-premise installations of SQL Server. This book is also useful for DBAs who wish to learn advanced features such as Query Store, Extended Events, Distributed Replay, and Policy-Based Management, or those who need to install SQL Server in a variety of environments.
Pro SQL Server 2019 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server
by Enrico van de LaarHere 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 LearnIdentify resource bottlenecks in a running SQL Server instanceLocate wait statistics information inside DMVs and Query StoreAnalyze the root cause of sub-optimal performanceDiagnose I/O contention and locking contentionBenchmark SQL Server performanceLower the wait time of the most popular wait typesWho This Book Is ForDatabase 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
Pro SQL Server 2022 Administration: A Guide for the Modern DBA
by Peter A. CarterGet your daily work done efficiently using this comprehensive guide for SQL Server DBAs that covers all that a practicing database administrator needs to know. Updated for SQL Server 2022, this edition includes coverage of new features, such as Ledger, which provides an immutable record of table history to protect you against malicious data tampering, and integration with cloud providers to support hybrid cloud scenarios. You’ll also find new content on performance optimizations, such as query pan feedback, and security controls, such as new database roles, which are restructured for modern ways of working. Coverage also includes Query Store, installation on Linux, and the use of containerized SQL.Pro SQL Server 2022 Administration takes DBAs on a journey that begins with planning their SQL Server deployment and runs through installing and configuring the instance, administering and optimizing database objects, and ensuring that data is secure and highly available. Readers will learn how to perform advanced maintenance and tuning techniques, and discover SQL Server's hybrid cloud functionality.This book teaches you how to make the most of new SQL Server 2022 functionality, including integration for hybrid cloud scenarios. The book promotes best-practice installation, shows how to configure for scalability and high availability, and demonstrates the gamut of database-level maintenance tasks, such as index maintenance, database consistency checks, and table optimizations. What You Will LearnIntegrate SQL Server with Azure for hybrid cloud scenariosAudit changes and prevent malicious data changes with SQL Server’s LedgerSecure and encrypt data to protect against embarrassing data breachesEnsure 24 x 7 x 365 access through high availability and disaster recovery features in today’s hybrid worldUse Azure tooling, including Arc, to gain insight into and manage your SQL Server enterpriseInstall and configure SQL Server on Windows, Linux, and in containers Perform routine maintenance tasks, such as backups and database consistency checks Optimize performance and undertake troubleshooting in the Database EngineWho This Book Is ForSQL Server DBAs who manage on-premise installations of SQL Server. This book is also useful for DBAs who wish to learn advanced features, such as integration with Azure, Query Store, Extended Events, and Policy-Based Management, or those who need to install SQL Server in a variety of environments.
Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database
by Thomas LaRock Enrico van de LaarUse 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 LearnUnderstand how the SQL Server engine processes requestsIdentify resource bottlenecks in a running SQL Server instanceLocate wait statistics information inside DMVs and Query StoreAnalyze the root cause of sub-optimal performanceDiagnose I/O contention and locking contentionBenchmark SQL Server performanceImprove database performance by lowering overall wait time Who This Book Is ForDatabase 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
Pro SQL Server Administration
by Peter CarterPro SQL Server Administration brings SQL Server administration into the modern era with strong coverage of hybrid cloud environments, In-Memory OLTP, and installation on Server Core. This comprehensive guide to SQL Server Administration for today’s DBA helps you to administer the new and key areas of SQL Server, including Columnstore indexes and the In-Memory OLTP feature set introduced in 2014.You will also be guided through the administration of traditional areas of SQL Server, including how to secure your instance, monitor and maintain your instance, and to use features such as AlwaysOn to make your instance highly available. Also covered is the use of SQL Server features to scale out read-only workloads. Pro SQL Server Administration is an all-new book taking up-to-date and modern approach that you'll want and need to further your career as a SQL Server database administrator.Extensive coverage of hybrid cloud environments involving Azure SQL Database Detailed discussions on all new, key features, including AlwaysOn and in-memory supportComprehensive coverage of key skills, such as monitoring, maintenance and indexing
Pro SQL Server Always On Availability Groups
by Uttam Parui Vivek SanilThis book is your field guide to planning, deploying, managing, and troubleshooting Always On Availability Groups. The Always On Availability Groups feature is an enterprise-level solution for high availability and disaster recovery. Always On provides a rich set of options that reduce overhead and resource usage and enable database administrators to implement and manage high availability and disaster recovery solutions far more easily than by implementing the log-shipping and database-mirroring solutions of the past. Pro SQL Server Always On Availability Groups shows how to reduce downtime, maximize application availability, and provide data protection. The goal is always to have your SQL Server databases up and running whenever you need them, rain or shine, disaster or otherwise. With a focus on real-world experiences and war stories, authors Uttam Parui and Vivek Sanil offer you: Tips, tricks, and best practices for architecting and deploying availability groups. The confidence required to manage and monitor availability groups. Techniques to troubleshoot common issues that you may face during and after deploying availability groups in a mission-critical production environment. What You Will Learn Grasp important concepts underlying high-availability and disaster recovery. Plan and deploy Always On Availability Groups in your corporate environment. Manage Availability Groups to ensure constant readiness and high throughput. Monitor Availability Group performance and troubleshoot problems fast. Build on the cloud and make Windows Azure part of your availability solution. Employ proven techniques and best practices as tested and shared by the authors. Audience Pro SQL Server Always On Availability Groups is aimed at SQL Server architects, database administrators, and IT professionals who are tasked with architecting and deploying a high-availability and disaster recovery solution involving Microsoft SQL Server. This book is also for SQL Server support staff who will be managing and supporting existing availability group deployments.
Pro SQL Server Internals
by Dmitri KorotkevitchPro SQL Server Internals explains how different SQL Server components work "under the hood" and how they communicate with each other. This is the practical book with a large number of examples that will show you how various design and implementation decisions affect the behavior and performance of your systems. Pro SQL Server Internals covers a multiple SQL Server versions starting with SQL Server 2005 all the way up to the recently released SQL Server 2014. You''ll learn about new SQL Server 2014 features including the new Cardinality Estimator, In-Memory OLTP Engine (codename Hekaton), and Clustered Columnstore Indexes. With Pro SQL Server Internals, you have a solid roadmap for understanding the depth and power of the SQL Server database backend, regardless of the version and edition of SQL Server you use. Pro SQL Server Internals does the following: Explains how to design efficient database schema, indexing, and transaction strategies. Shows how various database objects and technologies are implemented internally and when they should or should not be used. Demonstrates how SQL Server executes queries and works with data and transaction logs. What you''ll learn Design and develop efficient database solutions utilizing SQL Server as the database backend. Troubleshoot and address design, concurrency, and performance issues in systems. Choose the right database objects and technologies for the job. Improve system availability and manageability and reduce implementation costs with data partitioning. Design efficient Disaster Recovery and High-Availability strategies for systems. Improve the performance of OLTP and Data Warehouse systems by utilizing new SQL Server 2014 features, such as the In-Memory OLTP Engine and Clustered Columnstore Indexes. Who this book is for Pro SQL Server Internals is a book for developers and database administrators who want to design, develop, and maintain systems in a way that gets the most from SQL Server. This book is an excellent choice for people who prefer to understand and fix the root cause of a problem, rather than applying a ''band aid'' to it. Table of Contents Part 1 - Tables and Indexes * Chapter 1: Data storage internals * Chapter 2: Tables and Indexes - Internal Structure and Access Methods * Chapter 3: Statistics * Chapter 4: Special Indexing and Storage Features * Chapter 5: Index fragmentation * Chapter 6: Designing and tuning the indexes Part 2: Other things that matter * Chapter 7: Constraints * Chapter 8: Triggers * Chapter 9: Views * Chapter 10: Functions * Chapter 11: XML * Chapter 12: Temporary Tables * Chapter 13: CLR * Chapter 14: CLR types * Chapter 15: Data partitioning * Chapter 16: System design considerations Part 3: Locking, Blocking and Concurrency * Chapter 17: Lock types * Chapter 18: Troubleshooting Blocking issues * Chapter 19: Deadlocks * Chapter 20: Lock Escalations * Chapter 21: Optimistic isolation levels * Chapter 22: Application locks * Chapter 23: Schema locks * Chapter 24: Designing transaction strategies Part 4: Query Life Cycle * Chapter 25: Query Optimization and Execution * Chapter 26: Plan Caching Part 5: Practical Troubleshooting * Chapter 27: System Troubleshooting * Chapter 28: Extended events Part 6: Inside the transaction log * Chapter 29: Transaction Log Internals * Chapter 30: Designing a Backup Strategy * Chapter 31: Designing a High Availability Strategy Part 7: In-Memory OLTP Engine * Chapter 32: Hekaton (In Memory OLTP Engine) Part 8: Columnstore Indexes * Chapter 33: In-Memory OLTP Programmability * Chapter 34: Introduction to Columnstore indexes * Chapter 35: Clustered Columnstore indexes
Pro SQL Server Internals
by Dmitri KorotkevitchImprove your ability to develop, manage, and troubleshoot SQL Server solutions by learning how different components work "under the hood," and how they communicate with each other. The detailed knowledge helps in implementing and maintaining high-throughput databases critical to your business and its customers. You'll learn how to identify the root cause of each problem and understand how different design and implementation decisions affect performance of your systems. New in this second edition is coverage of SQL Server 2016 Internals, including In-Memory OLTP, columnstore enhancements, Operational Analytics support, Query Store, JSON, temporal tables, stretch databases, security features, and other improvements in the new SQL Server version. The knowledge also can be applied to Microsoft Azure SQL Databases that share the same code with SQL Server 2016. Pro SQL Server Internals is a book for developers and database administrators, and it covers multiple SQL Server versions starting with SQL Server 2005 and going all the way up to the recently released SQL Server 2016. The book provides a solid road map for understanding the depth and power of the SQL Server database server and teaches how to get the most from the platform and keep your databases running at the level needed to support your business. The book: * Provides detailed knowledge of new SQL Server 2016 features and enhancements * Includes revamped coverage of columnstore indexes and In-Memory OLTP * Covers indexing and transaction strategies * Shows how various database objects and technologies are implemented internally, and when they should or should not be used * Demonstrates how SQL Server executes queries and works with data and transaction log What You Will Learn Design and develop database solutions with SQL Server. Troubleshoot design, concurrency, and performance issues. Choose the right database objects and technologies for the job. Reduce costs and improve availability and manageability. Design disaster recovery and high-availability strategies. Improve performance of OLTP and data warehouse systems through in-memory OLTP and Columnstore indexes. Who This Book Is For Developers and database administrators who want to design, develop, and maintain systems in a way that gets the most from SQL Server. This book is an excellent choice for people who prefer to understand and fix the root cause of a problem rather than applying a 'band aid' to it.
Pro SQL Server on Linux: Including Container-Based Deployment with Docker and Kubernetes
by Bob WardGet 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 LearnLearn about the history and internal of the unique SQL Server on Linux architecture.Install and configure Microsoft’s flagship database product on the Linux platformManage your deployments using container technology through Docker and KubernetesKnow the basics of building databases, the T-SQL language, and developing applications against SQL Server on LinuxUse tools and features to diagnose, manage, and monitor SQL Server on LinuxScale your application by learning the performance capabilities of SQL ServerDeliver high availability and disaster recovery to ensure business continuitySecure your database from attack, and protect sensitive data through encryptionTake advantage of powerful features such as Failover Clusters, Availability Groups, In-Memory Support, and SQL Server’s Self-Tuning EngineLearn how to migrate your database from older releases of SQL Server and other database platforms such as Oracle and PostgreSQLBuild and maintain schemas, and perform management tasks from both GUI and command lineWho This Book Is ForDevelopers 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.
Pro SQL Server on Microsoft Azure
by Amit Banerjee Sourabh Agarwal Pranab MazumdarLearn the basics of Microsoft Azure and see how SQL Server on Azure VMs (Infrastructure-as-a-Service) and Azure SQL Databases (Platform-as-a-Service) work. This concise book shows you how to deploy, operate, and maintain your data using any one or a combination of these offerings along with your on-premise environment. Pro SQL Server on Microsoft Azure is a quintessential book for any IT professional who is planning to host their data on Microsoft Azure. This book will not only equip you with the tips, tricks, and tools to manage SQL Server offerings on Azure, but will also help you in deciding between PaaS, IaaS, or hybrid. In the ever-changing world of operations, IT administrators and SQL Server DBAs often find that the biggest challenges occur once they've deployed to the cloud. This is precisely why Pro SQL Server on Microsoft Azure was written; it will help you master today's cloud world. What You'll Learn Understand the Microsoft Azure IaaS architecture Work with Azure Storage and Networking Deploy SQL Server on Azure VMs using best practices Apply effective security principles to SQL Azure Databases Measure and optimize the performance of SQL Server offerings on Azure Implement Business continuity and disaster recovery options with Azure SQL Databases Who This Book Is For This book is for IT admins and SQL Server DBAs who are managing or would be managing SQL Server deployments on Microsoft Azure. v>
Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance
by Louis DavidsonLearn effective and scalable database design techniques in SQL Server 2019 and other recent SQL Server versions. This book is revised to cover additions to SQL Server that include SQL graph enhancements, in-memory online transaction processing, temporal data storage, row-level security, and other design-related features. This book will help you design OLTP databases that are high-quality, protect the integrity of your data, and perform fast on-premises, in the cloud, or in hybrid configurations. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for well over 30 years, using technology that is constantly changing. This book covers everything from design logic that business users will understand to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, author Louis Davidson shows you how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data.What You Will LearnDevelop conceptual models of client data using interviews and client documentationImplement designs that work on premises, in the cloud, or in a hybrid approachRecognize and apply common database design patternsNormalize data models to enhance integrity and scalability of your databases for the long-term use of valuable dataTranslate conceptual models into high-performing SQL Server databasesSecure and protect data integrity as part of meeting regulatory requirementsCreate effective indexing to speed query performanceUnderstand the concepts of concurrencyWho This Book Is ForProgrammers and database administrators of all types who want to use SQL Server to store transactional data. The book is especially useful to those wanting to learn the latest database design features in SQL Server 2019 (features that include graph objects, in-memory OLTP, temporal data support, and more). Chapters on fundamental concepts, the language of database modeling, SQL implementation, and the normalization process lay a solid groundwork for readers who are just entering the field of database design. More advanced chapters serve the seasoned veteran by tackling the latest in physical implementation features that SQL Server has to offer. The book has been carefully revised to cover all the design-related features that are new in SQL Server 2019.
Pro SQL Server Relational Database Design and Implementation
by Louis Davidson Jessica MossLearn effective and scalable database design techniques in a SQL Server 2016 and higher environment. This book is revised to cover in-memory online transaction processing, temporal data storage, row-level security, durability enhancements, and other design-related features that are new or changed in SQL Server 2016. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for forty years coupled with technology that is constantly changing. Pro SQL Server Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, Louis Davidson shows how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data. The pace of change in relational database management systems has been tremendous these past few years. Whereas in the past it was enough to think about optimizing data residing on spinning hard drives, today one also must consider solid-state storage as well as data that are constantly held in memory and never written to disk at all except as a backup. Furthermore, there is a trend toward hybrid cloud and on-premise database configurations as well a move toward preconfigured appliances. Pro SQL Server Relational Database Design and Implementation guides in the understanding of these massive changes and in their application toward sound database design. Gives a solid foundation in best practices and relational theory Covers the latest implementation features in SQL Server 2016 Helps you master in-memory OLTP and use it effectively Takes you from conceptual design to an effective, physical implementation What You Will Learn Develop conceptual models of client data using interviews and client documentation Recognize and apply common database design patterns Normalize data models to enhance scalability and the long term use of valuable data Translate conceptual models into high-performing SQL Server databases Secure and protect data integrity as part of meeting regulatory requirements Create effective indexing to speed query performance Who This Book Is For Programmers and database administrators of all types who want to use SQL Server to store data. The book is especially useful to those wanting to learn the very latest design features in SQL Server 2016, features that include an improved approach to in-memory OLTP, durability enhancements, temporal data support, and more. Chapters on fundamental concepts, the language of database modeling, SQL implementation, and of course, the normalization process, lay a solid groundwork for readers who are just entering the field of database design. More advanced chapters serve the seasoned veteran by tackling the very latest in physical implementation features that SQL Server has to offer. The book has been carefully revised to cover all the design-related features that are new in SQL Server 2016.
Pro SQL Server Wait Statistics
by Enrico LaarPro SQL Server Wait Statistics is a practical guide for analyzing and troubleshooting SQL Server performance using wait statistics. Whether you are new to wait statistics, or already familiar with them, this book will help you gain a deeper understanding of how wait statistics are generated and what they can mean for your SQL Server's performance. Besides the most common wait types, Pro SQL Server Wait Statistics goes further into the more complex and performance threatening wait types. The different wait types are categorized by their area of impact, and include CPU, IO, Lock, and many more different wait type categories. Filled with clear examples, Pro SQL Server Wait Statistics helps you gain practical knowledge of why and how specific wait times increase or decrease, and how they impact your SQL Server's performance. What you'll learn How wait Statistics are generated by SQL Server Script examples for analyzing and tuning wait statistics How to lower, or even eliminate, wait times that hurt performance How to query wait statistics information from Dynamic Management Views How to build reliable and solid wait statistics baselines from which to detect performance issues Who this book is for Pro SQL Server Wait Statistics is the perfect guide for SQL Server DBAs wanting to troubleshoot and optimize SQL Server database installations. The book is also of interest to database developers who are serious about developing highly-performant applications and reporting systems. Table of Contents Introduction Part I: Foundations of Wait Statistics Analysis 1. How Wait Statistics are Generated 2. Querying Wait Statistics 3. Building a Solid Baseline Part II: Wait Types 4. CPU Wait Types 5. I/O Wait Types 6. Backup Wait Types 7. Lock Wait Types 8. Latch Wait Types 9. High-Availability and Disaster Recovery Wait Types 10: Preemptive Wait Types 11: Background and Miscellaneous Wait Types 12. Chapter 12 13: Appendix A 14. Appendix B 15. Appendix C
Pro T-SQL 2019: Toward Speed, Scalability, and Standardization for SQL Server Developers
by Elizabeth NobleDesign and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book provides the help you need in writing T-SQL that performs fast and is easy to maintain. You also will learn how to implement version control, testing, and deployment strategies. Hands-on examples show modern T-SQL practices and provide straightforward explanations. Attention is given to selecting the right data types and objects when designing T-SQL solutions. Author Elizabeth Noble teaches you how to improve your T-SQL performance through good design practices that benefit programmers and ultimately the users of the applications. You will know the common pitfalls of writing T-SQL and how to avoid those pitfalls going forward. What You Will LearnChoose correct data types and database objects when designing T-SQLWrite T-SQL that searches data efficiently and uses hardware effectivelyImplement source control and testing methods to streamline the deployment processDesign T-SQL that can be enhanced or modified with less effortPlan for long-term data management and storageWho This Book Is ForDatabase developers who want to improve the efficiency of their applications, and developers who want to solve complex query and data problems more easily by writing T-SQL that performs well, brings back correct results, and is easy for other developers to understand and maintain
Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers
by Elizabeth NobleLearn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations. New in this edition is coverage of Parameter Sensitive Plan (PSP) optimization, Azure Synapse Link for real-time analytics, integration with S3-compatible object storage, and SQL Ledger tables based on blockchain. You’ll learn to improve your T-SQL design in ways that provide faster performance, stronger security, and easier comprehension. The book identifies common anti-patterns in writing T-SQL and instructs you on how to change your code so you can be more confident in writing T-SQL code that is reliable and performs well.Pro T-SQL 2022 is focused on the problems that developers are faced with and must solve in delivering successful applications. The content begins from a foundation of writing T-SQL that is clear and understandable. The book then takes you through writing SQL that performs well, is easy to manage through coding standards and version control, can be maintained and modified as business requirements change over time, scales as your business grows, and takes advantage of the full range of security features built into the SQL Server and Azure SQL database engines. What You Will LearnChoose the correct data types and database objects when designing your T-SQLWrite T-SQL that accesses your data efficiently and uses hardware effectivelyImplement source control and testing methods to streamline your deployment process.Design T-SQL that is flexible and can be enhanced or modified with little effortPlan for long-term data management, including growth and purging of older dataEnhance database security through features such as encryption, data masking, row-level security, and the SQL Ledger blockchain table typeWho This Book Is ForDatabase developers who want to improve the efficiency of their applications with better T-SQL; developers who want to know more about T-SQL so they can be prepared to solve complex problems more easily; data professionals who want to write high-quality T-SQL that performs well, is flexible to changing needs, and is easy for others to understand
Pro T-SQL Programmer's Guide
by Miguel Cebollero Jay Natarajan Michael ColesPro T-SQL Programmer's Guide is your guide to making the best use of the powerful, Transact-SQL programming language that is built into Microsoft SQL Server's database engine. This edition is updated to cover the new, in-memory features that are part of SQL Server 2014. Discussing new and existing features, the book takes you on an expert guided tour of Transact-SQL functionality. Fully functioning examples and downloadable source code bring technically accurate and engaging treatment of Transact-SQL into your own hands. Step-by-step explanations ensure clarity, and an advocacy of best-practices will steer you down the road to success. Transact-SQL is the language developers and DBAs use to interact with SQL Server. It's used for everything from querying data, to writing stored procedures, to managing the database. Support for in-memory stored procedures running queries against in-memory tables is new in the language and gets coverage in this edition. Also covered are must-know features such as window functions and data paging that help in writing fast-performing database queries. Developers and DBAs alike can benefit from the expressive power of T-SQL, and Pro T-SQL Programmer's Guide is your roadmap to success in applying this increasingly important database language to everyday business and technical tasks. Covers the newly-introduced, in-memory database featuresShares the best practices used by experienced professionalsGoes deeply into the subject matter - an advanced book for the serious reader
Pro Tableau
by Seema Acharya Subhashini ChellappanLeverage the power of visualization in business intelligence and data science to make quicker and better decisions. Use statistics and data mining to make compelling and interactive dashboards. This book will help those familiar with Tableau software chart their journey to being a visualization expert. Pro Tableau demonstrates the power of visual analytics and teaches you how to: Connect to various data sources such as spreadsheets, text files, relational databases (Microsoft SQL Server, MySQL, etc. ), non-relational databases (NoSQL such as MongoDB, Cassandra), R data files, etc. Write your own custom SQL, etc. Perform statistical analysis in Tableau using R Use a multitude of charts (pie, bar, stacked bar, line, scatter plots, dual axis, histograms, heat maps, tree maps, highlight tables, box and whisker, etc. ) What you'll learn Connect to various data sources such as relational databases (Microsoft SQL Server, MySQL), non-relational databases (NoSQL such as MongoDB, Cassandra), write your own custom SQL, join and blend data sources, etc. Leverage table calculations (moving average, year over year growth, LOD (Level of Detail), etc. Integrate Tableau with R Tell a compelling story with data by creating highly interactive dashboards Who this book is for All levels of IT professionals, from executives responsible for determining IT strategies to systems administrators, to data analysts, to decision makers responsible for driving strategic initiatives, etc. The book will help those familiar with Tableau software chart their journey to a visualization expert.
Pro TBB: C++ Parallel Programming with Threading Building Blocks
by Michael Voss Rafael Asenjo James ReindersThis open access book is a modern guide for all C++ programmers to learn Threading Building Blocks (TBB). Written by TBB and parallel programming experts, this book reflects their collective decades of experience in developing and teaching parallel programming with TBB, offering their insights in an approachable manner. Throughout the book the authors present numerous examples and best practices to help you become an effective TBB programmer and leverage the power of parallel systems.Pro TBB starts with the basics, explaining parallel algorithms and C++'s built-in standard template library for parallelism. You'll learn the key concepts of managing memory, working with data structures and how to handle typical issues with synchronization. Later chapters apply these ideas to complex systems to explain performance tradeoffs, mapping common parallel patterns, controlling threads and overhead, and extending TBB to program heterogeneous systems or system-on-chips. What You'll LearnUse Threading Building Blocks to produce code that is portable, simple, scalable, and more understandableReview best practices for parallelizing computationally intensive tasks in your applicationsIntegrate TBB with other threading packagesCreate scalable, high performance data-parallel programsWork with generic programming to write efficient algorithmsWho This Book Is ForC++ programmers learning to run applications on multicore systems, as well as C or C++ programmers without much experience with templates. No previous experience with parallel programming or multicore processors is required.
Pro Team Foundation Service
by Mathias Olausson Joachim Rossberg Jakob Ehn Mattias SköldPro Team Foundation Service gives you a jump-start into Microsoft's cloud-based Application Lifecycle Management platform, taking you through the different stages of software development. Every project needs to plan, develop, test and release software and with agile practices often at a higher pace than ever before. Microsoft's Team Foundation Service is a cloud-based platform that gives you tools for agile planning and work tracking. It has a code repository that can be used not only from Visual Studio but from Java platforms and Mac OS X. The testing tools allow testers to start testing at the same time as developers start developing. The book also covers how to set up automated practices such as build, deploy and test workflows. This book: Takes you through the major stages in a software development project. Gives practical development guidance for the whole team. Enables you to quickly get started with modern development practices. With Microsoft Team Foundation Service comes a collaboration platform that gives you and your team the tools to better perform your tasks in a fully integrated way. What you'll learn What ALM is and what it can do for you. Leverage a cloud-based ALM platform for quick improvements in your development process. Improve your agile development process using integrated tools and practices. Develop automated build, deployment and testing processes. Integrate different development tools with one collaboration platform. Get started with ALM best-practices first time round. Who this book is for Pro Team Foundation Service is for any development team that wants to take their development practices to the next level. Microsoft Team Foundation Service is an excellent platform for managing the entire application development lifecycle and being a cloud-based offering it is very easy to get started. Pro Team Foundation Service is a great guide for anyone in a team who wants to get started with the service and wants to get expert guidance to do it right. Table of Contents Introduction to Application Lifecycle Management Introduction to Agile Planning, Development, and Testing Deciding on a Hosted Service Getting Started Working with the Initial Product Backlog Managing Team and Alerts Initial Sprint Planning Running the Sprint Kanban Engaging the Customer Choosing Source Control Options Working with Team Foundation Version Control in Visual Studio Working with Git in Visual Studio Working in Heterogeneous Environments Configuring Build Services Working with Builds Customizing Builds Continuous Deployment Agile Testing Test Management Lab Management
Pro Tools 101: For Pro Tools 12 Software
by Frank D. CookCongratulations on beginning work under Avid's official training program. This book represents the first step on a journey toward mastery of your Pro Tools system. The information, exercises, and projects you will find here apply to all Pro Tools 12 systems.
The Pro Tools 2023 Post-Audio Cookbook: A holistic approach to post audio workflows like music production, motion picture, and spoken word
by null Emiliano PaternostroTake your projects from vision to victory with Avid Pro Tools in this part-color guide by delivering high-quality results with perfect recipes for every challengeKey FeaturesLearn to edit audio quickly and efficiently using different techniquesDiscover advanced automation techniques used during a mix sessionUnlock Pro Tools' most powerful features and explore their usesPurchase of the print or Kindle book includes a free PDF eBookBook DescriptionPro Tools has long been an industry-standard Digital Audio Workstation (DAW) for audio professionals, but it can often be overwhelming for new and experienced users alike. The Pro Tools 2023 Post-Audio Cookbook acts as a reference guide to the software and breaks down each stage of a project into manageable phases. From planning a session, editing a sequence, performing a mix to printing the final masters, you can approach this book either sequentially or peruse the self-contained recipes. You’ll come to grips with workflows for music production, motion picture, and spoken word production, helping you gain expertise in the area of your choice. You'll learn aspects of music mixing like side chain processing to keep instruments from overshadowing each other and conforming for motion picture. The author’s expertise with Pro Tools will help you discover and incorporate different techniques into your workflows. You’ll also learn to build consistent and replicable workflows and templates by understanding what happens behind the scenes in Pro Tools. With this cookbook, you’ll be able to focus on the creative aspects of your audio production and not get mired by the technical hurdles. By the end of this book, you’ll be well-equipped to handle even the most complex features of Pro Tools to deliver immaculate results for your clients.What you will learnExplore the inner workings of Pro ToolsPlan and organize projects effectivelyEdit audio quickly and efficientlyUnderstand and explore the usage of audio routingBuild effective mix templatesDeliver custom solutions for varied service requirementsUse advanced mixing techniques to enhance sound tracksPick appropriate use cases for different audio effects and pluginsWho this book is forThe book is for audio professionals, sound designers/editors, music engineers, podcast producers, re-recordist mixers, and students looking to learn about Pro Tools and its features. A basic understanding of Digital Audio Workstations and its operations such as import, edit, mix and bounce is a must.