Implement, automate, build, operate, and optimize databases and other data-persistent technologies efficiently by leveraging the right set of DevOps best practices Key Features Implement core operational capabilities via automated pipelines, including testing and rollbacks Create infrastructure, deploy software, test execution, and monitor operations using the as-code strategy Automate common implementation patterns for databases with declarative orchestration frameworks Purchase of the print or Kindle book includes a free PDF eBook Book DescriptionIn today's rapidly evolving world of DevOps, traditional silos are a thing of the past. Database administrators are no longer the only experts; site reliability engineers (SREs) and DevOps engineers are database experts as well. This blurring of the lines has led to increased responsibilities, making members of high-performing DevOps teams responsible for end-to-end ownership. This book helps you master DevOps for databases, making it a must-have resource for achieving success in the ever-changing world of DevOps. You’ll begin by exploring real-world examples of DevOps implementation and its significance in modern data-persistent technologies, before progressing into the various types of database technologies and recognizing their strengths, weaknesses, and commonalities. As you advance, the chapters will teach you about design, implementation, testing, and operations using practical examples, as well as common design patterns, combining them with tooling, technology, and strategies for different types of data-persistent technologies. You’ll also learn how to create complex end-to-end implementation, deployment, and cloud infrastructure strategies defined as code. By the end of this book, you’ll be equipped with the knowledge and tools to design, build, and operate complex systems efficiently.What you will learn Apply DevOps best practices to data-persistent technologies Get to grips with architectural-level design and implementation Explore the modern data journey and data modeling with database technology Master the operation of large-scale systems with zero-touch automation Achieve speed, resilience, security, and operability at different scales Design DevOps teams with end-to-end ownership models Who this book is for This book is for newcomers as well as seasoned SREs, DevOps engineers, and system engineers who are interested in large-scale systems with a heavy focus on data-persistent technologies. Database administrators looking to level up in the world of DevOps will also find this book helpful. Experience with cloud Infrastructure, basic development, and operations will help you get the most out of this book.

The infrastructure-as-code revolution in IT is also affecting database administration. With this practical book, developers, system administrators, and junior to mid-level DBAs will learn how the modern practice of site reliability engineering applies to the craft of database architecture and operations. Authors Laine Campbell and Charity Majors provide a framework for professionals looking to join the ranks of today’s database reliability engineers (DBRE). You’ll begin by exploring core operational concepts that DBREs need to master. Then you’ll examine a wide range of database persistence options, including how to implement key technologies to provide resilient, scalable, and performant data storage and retrieval. With a firm foundation in database reliability engineering, you’ll be ready to dive into the architecture and operations of any modern database. This book covers: Service-level requirements and risk management Building and evolving an architecture for operational visibility Infrastructure engineering and infrastructure management How to facilitate the release management process Data storage, indexing, and replication Identifying datastore characteristics and best use cases Datastore architectural components and data-driven architectures

Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance. Now, for the first time, leading agile methodologist Scott Ambler and renowned consultant Pramodkumar Sadalage introduce powerful refactoring techniques specifically designed for database systems. Ambler and Sadalage demonstrate how small changes to table structures, data, stored procedures, and triggers can significantly enhance virtually any database design–without changing semantics. You’ll learn how to evolve database schemas in step with source code–and become far more effective in projects relying on iterative, agile methodologies. This comprehensive guide and reference helps you overcome the practical obstacles to refactoring real-world databases by covering every fundamental concept underlying database refactoring. Using start-to-finish examples, the authors walk you through refactoring simple standalone database applications as well as sophisticated multi-application scenarios. You’ll master every task involved in refactoring database schemas, and discover best practices for deploying refactorings in even the most complex production environments. The second half of this book systematically covers five major categories of database refactorings. You’ll learn how to use refactoring to enhance database structure, data quality, and referential integrity; and how to refactor both architectures and methods. This book provides an extensive set of examples built with Oracle and Java and easily adaptable for other languages, such as C#, C++, or VB.NET, and other databases, such as DB2, SQL Server, MySQL, and Sybase. Using this book’s techniques and examples, you can reduce waste, rework, risk, and cost–and build database systems capable of evolving smoothly, far into the future.

If you work with SQL Server, dbatools is a lifesaver. This book will show you how to use this free and open source PowerShell module to automate just about every SQL server task you can imagine—all in just one month! In Learn dbatools in a Month of Lunches you will learn how to: Perform instance-to-instance and customized migrations Automate security audits, tempdb configuration, alerting, and reporting Schedule and monitor PowerShell tasks in SQL Server Agent Bulk-import any type of data into SQL Server Install dbatools in secure environments Written by a group of expert authors including dbatools creator Chrissy LeMaire, Learn dbatools in a Month of Lunches teaches you techniques that will make you more effective—and efficient—than you ever thought possible. In twenty-eight lunchbreak lessons, you’ll learn the most important use cases of dbatools and the favorite functions of its core developers. Stabilize and standardize your SQL server environment, and simplify your tasks by building automation, alerting, and reporting with this powerful tool. About the technology For SQL Server DBAs, automation is the key to efficiency. Using the open-source dbatools PowerShell module, you can easily execute tasks on thousands of database servers at once—all from the command line. dbatools gives you over 500 pre-built commands, with countless new options for managing SQL Server at scale. There’s nothing else like it. About the book Learn dbatools in a Month of Lunches teaches you how to automate SQL Server using the dbatools PowerShell module. Each 30-minute lesson introduces a new automation that will make your daily duties easier. Following the expert advice of dbatools creator Chrissy LeMaire and other top community contributors, you’ll learn to script everything from backups to disaster recovery. What's inside Performing instance-to-instance and customized migrations Automating security audits, best practices, and standardized configurations Administering SQL Server Agent including running PowerShell scripts effectively Bulk-importing many types of data into SQL Server Executing advanced tasks and increasing efficiency for everyday administration About the reader For DBAs, accidental DBAs, and systems engineers who manage SQL Server. About the author Chrissy LeMaire is a GitHub Star and the creator of dbatools. Rob Sewell is a data engineer and a passionate automator. Jess Pomfret and Cláudio Silva are data platform architects. All are Microsoft MVPs. Table of Contents 1 Before you begin 2 Installing dbatools 3 The dbatools lab 4 A gentle introduction to dbatools commands 5 Writing to SQL Server 6 Finding SQL Server instances on your network 7 Inventorying your SQL estate 8 Registered Servers 9 Logins and users 10 Backups 11 Restore 12 Snapshots 13 Install and update SQL Server 14 Preparing for disaster 15 Performing your first advanced SQL Server instance migration, part 1 16 Performing your first advanced SQL Server instance migration, part 2 17 High availability and disaster recovery 18 PowerShell and SQL Server Agent 19 SQL Server Agent administration 20 Creating and working with SQL Server Agent objects 21 Data masking 22 DevOps automation 23 Tracing SQL Server activity 24 Security and encryption 25 Data compression 26 Validating your estate with dbachecks 27 Working in the cloud 28 dbatools configurations and logging 29 Never the end

Describes Agile Modeling Driven Design (AMDD) and Test-Driven Design (TDD) approaches, database refactoring, database encapsulation strategies, and tools that support evolutionary techniques Agile software developers often use object and relational database (RDB) technology together and as a result must overcome the impedance mismatch The author covers techniques for mapping objects to RDBs and for implementing concurrency control, referential integrity, shared business logic, security access control, reports, and XML An agile foundation describes fundamental skills that all agile software developers require, particularly Agile DBAs Includes object modeling, UML data modeling, data normalization, class normalization, and how to deal with legacy databases Scott W. Ambler is author of Agile Modeling (0471202827), a contributing editor with Software Development (www.sdmagazine.com), and a featured speaker at software conferences worldwide

A comprehensive guide to becoming a skilled Azure DevOps engineer Key FeaturesExplore a step-by-step approach to designing and creating a successful DevOps environmentUnderstand how to implement continuous integration and continuous deployment pipelines on AzureIntegrate and implement security, compliance, containers, and databases in your DevOps strategiesBook Description Implementing Azure DevOps Solutions helps DevOps engineers and administrators to leverage Azure DevOps Services to master practices such as continuous integration and continuous delivery (CI/CD), containerization, and zero downtime deployments. This book starts with the basics of continuous integration, continuous delivery, and automated deployments. You will then learn how to apply configuration management and Infrastructure as Code (IaC) along with managing databases in DevOps scenarios. Next, you will delve into fitting security and compliance with DevOps. As you advance, you will explore how to instrument applications, and gather metrics to understand application usage and user behavior. The latter part of this book will help you implement a container build strategy and manage Azure Kubernetes Services. Lastly, you will understand how to create your own Azure DevOps organization, along with covering quick tips and tricks to confidently apply effective DevOps practices. By the end of this book, you’ll have gained the knowledge you need to ensure seamless application deployments and business continuity. What you will learnGet acquainted with Azure DevOps Services and DevOps practicesImplement CI/CD processesBuild and deploy a CI/CD pipeline with automated testing on AzureIntegrate security and compliance in pipelinesUnderstand and implement Azure Container ServicesBecome well versed in closing the loop from production back to developmentWho this book is for This DevOps book is for software developers and operations specialists interested in implementing DevOps practices for the Azure cloud. Application developers and IT professionals with some experience in software development and development practices will also find this book useful. Some familiarity with Azure DevOps basics is an added advantage.

Winner of the 2011 Jolt Excellence Award! Getting software released to users is often a painful, risky, and time-consuming process. This groundbreaking new book sets out the principles and technical practices that enable rapid, incremental delivery of high quality, valuable new functionality to users. Through automation of the build, deployment, and testing process, and improved collaboration between developers, testers, and operations, delivery teams can get changes released in a matter of hours— sometimes even minutes–no matter what the size of a project or the complexity of its code base. Jez Humble and David Farley begin by presenting the foundations of a rapid, reliable, low-risk delivery process. Next, they introduce the “deployment pipeline,” an automated process for managing all changes, from check-in to release. Finally, they discuss the “ecosystem” needed to support continuous delivery, from infrastructure, data and configuration management to governance. The authors introduce state-of-the-art techniques, including automated infrastructure management and data migration, and the use of virtualization. For each, they review key issues, identify best practices, and demonstrate how to mitigate risks. Coverage includes • Automating all facets of building, integrating, testing, and deploying software • Implementing deployment pipelines at team and organizational levels • Improving collaboration between developers, testers, and operations • Developing features incrementally on large and distributed teams • Implementing an effective configuration management strategy • Automating acceptance testing, from analysis to implementation • Testing capacity and other non-functional requirements • Implementing continuous deployment and zero-downtime releases • Managing infrastructure, data, components and dependencies • Navigating risk management, compliance, and auditing Whether you’re a developer, systems administrator, tester, or manager, this book will help your organization move from idea to release faster than ever—so you can deliver value to your business rapidly and reliably.

Unlock the Potential of Scalable and Serverless Data with "Mastering Amazon DynamoDB Database" In today's data-centric world, the ability to efficiently manage and scale databases is a cornerstone of success. "Mastering Amazon DynamoDB Database" is your comprehensive guide to mastering one of the most robust and versatile NoSQL databases available – Amazon DynamoDB. Whether you're a seasoned data professional or a newcomer to NoSQL technology, this book equips you with the knowledge and skills needed to harness the full capabilities of Amazon DynamoDB. About the Book: "Mastering Amazon DynamoDB Database" takes you on a transformative journey through the intricacies of this dynamic NoSQL database. From fundamental concepts to advanced techniques, you'll explore DynamoDB's architecture, data model, and powerful features. Each chapter is meticulously crafted to provide both a deep understanding of the concepts and practical applications in real-world scenarios. Key Features: · DynamoDB Fundamentals: Lay a solid foundation by delving into DynamoDB's architecture, data model, and the principles that make it a leader in distributed databases. · Data Modeling: Learn how to design efficient schema structures that optimize storage, access patterns, and query performance in DynamoDB. · Serverless Scalability: Explore DynamoDB's seamless scalability, taking advantage of its serverless nature to accommodate growing workloads without manual intervention. · Advanced Querying: Master DynamoDB's powerful query capabilities, including filtering, indexing, and advanced querying techniques that enable complex data retrieval. · Best Practices: Dive into best practices for data modeling, indexing strategies, partition key selection, and managing read and write capacity to ensure optimal performance. · Real-World Applications: Gain insights from real-world use cases across industries, from e-commerce and gaming to IoT and beyond, showcasing DynamoDB's adaptability. · Integration and Ecosystem: Explore DynamoDB's integration with other AWS services, APIs, and developer tools, empowering you to build end-to-end solutions. · Advanced Topics: Uncover advanced concepts such as transactions, backups, global tables, security mechanisms, and best practices for disaster recovery. Who This Book Is For: "Mastering Amazon DynamoDB Database" caters to developers, data engineers, solution architects, and anyone interested in leveraging the power of NoSQL databases. Whether you're seeking to enhance your skills or dive into the world of serverless databases, this book provides the insights and tools to navigate DynamoDB's intricacies. Why You Should Read This Book: In an era where scalability and performance are paramount, Amazon DynamoDB shines as a cornerstone of data management. "Mastering Amazon DynamoDB Database" empowers you to fully harness its capabilities, enabling you to build highly available applications, deliver seamless user experiences, and scale effortlessly. © 2023 Cybellium Ltd. All rights reserved. www.cybellium.com

Learn from Microsoft Power Platform experts how to leverage GitHub, Azure DevOps, and GenAI tools like Microsoft Copilots to develop and deliver secure, enterprise-scale solutions Key Features Customize Power Platform for secure large-scale deployments with the help of DevSecOps practices Implement code-first fusion projects with ALM and infuse AI in Power Platform using copilots and ChatOps Get hands-on experience through real-world examples using Azure DevOps and GitHub Purchase of the print or Kindle book includes a free PDF eBook Book Description Mastering DevOps on Microsoft Power Platform is your guide to revolutionizing business-critical solution development. Written by two Microsoft Technology Specialists with extensive experience in enterprise-scale Power Platform implementations and DevOps practices, this book teaches you how to design, build, and secure efficient DevOps processes by adapting custom software development practices to the Power Platform toolset, dramatically reducing time, cost, and errors in app modernization and quality assurance. The book introduces application life cycle management (ALM) and DevOps-enabled architecture, design patterns, and CI/CD practices, showing you why companies adopt DevOps with Power Platform. You'll master environment and solution management using Dataverse, Git, the Power Platform CLI, Azure DevOps, and GitHub Copilot. Implementing the shift-left approach in DevSecOps using GitHub Advanced Security features, you’ll create a Power Platform tenant governed by controls, automated tests, and backlog management. You’ll also discover advanced concepts, such as fusion architecture, pro-dev extensibility, and AI-infused applications, along with tips to avoid common pitfalls. By the end of this book, you’ll be able to build CI/CD pipelines from development to production, enhancing the life cycle of your business solutions on Power Platform. What you will learn Gain insights into ALM and DevOps on Microsoft Power Platform Set up Power Platform pipelines and environments by leveraging best practices Automate, test, monitor, and secure CI/CD pipelines using DevSecOps tools, such as VS Code and GitHub Advanced Security, on Power Platform Enable pro-developer extensibility using fusion development to integrate Azure and Power Platform Provision enterprise landing zones and build well-architected workloads Discover GenAI capabilities in Power Platform and support ChatOps with the copilot stack Who this book is for If you are a DevOps engineer, cloud architect, site reliability engineer, solutions architect, software developer, or low-code engineer looking to master end-to-end DevSecOps implementation on Microsoft Power Platform from basic to advanced levels, this book is for you. Prior knowledge of software development processes and tools is necessary. A basic understanding of Power Platform and DevOps processes will also be beneficial.

Accelerate the delivery of software, data, and machine learning KEY FEATURES ● Each chapter harmonizes the DevOps, Data Engineering, and Optimized Machine Learning cultures. ● Equips readers with AGILE skills to continuously re-prioritize production backlogs. ● Containerization, Docker, Kubernetes, DataOps, and MLOps are all rolled together. DESCRIPTION This book instructs readers on how to operationalize the creation of systems, software applications, and business information using the best practices of DevOps, DataOps, and MLOps, among other things. From software unit packaging code and its dependencies to automating the software development lifecycle and deployment, the book provides a learning roadmap that begins with the basics and progresses to advanced topics. This book teaches you how to create a culture of cooperation, affinity, and tooling at scale using DevOps, Docker, Kubernetes, Data Engineering, and Machine Learning. Microservices design, setting up clusters and maintaining them, processing data pipelines, and automating operations with machine learning are all topics that will aid you in your career. When you use each of the xOps methods described in the book, you will notice a clear shift in your understanding of system development. Throughout the book, you will see how every stage of software development is modernized with the most up-to-date technologies and the most effective project management approaches. WHAT YOU WILL LEARN ● Learn about the Packaging code and all its dependencies in a container. ● Utilize DevOps to automate every stage of software development. ● Learn how to create Microservices that are focused on a specific issue. ● Utilize Kubernetes to containerize applications in a variety of settings. ● Using DataOps, you can align people, processes, and technology. WHO THIS BOOK IS FOR This book is meant for the Software Engineering team, Data Professionals, IT Operations and Application Development Team with prior knowledge in software development. TABLE OF CONTENTS 1. Container – Containerization is the New Virtualization 2. Docker with Containers for Developing and Deploying Software 3. DevOps to Build at Scale a Culture of Collaboration, Affinity, and Tooling 4. Docker Containers for Microservices Architecture Design 5. Kubernetes – The Cluster Manager for Container 6. Data Engineering with DataOps 7. MLOps: Engineering Machine Learning Operations 8. xOps Best Practices