Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance

Know how to track changes and key events in your SQL Server databases in support of application troubleshooting, regulatory compliance, and governance. This book shows how to use key features in SQL Server, such as SQL Server Audit and Extended Events, to track schema changes, permission changes, and changes to your data. You'll even learn how to track queries run against specific tables in a database.
Not all changes and events can be captured and tracked using SQL Server Audit and Extended Events, and the book goes beyond those features to also show what can be captured using common criteria compliance, change data capture, temporal tables, or querying the SQL Server log. You will learn how to audit just what you need to audit, and how to audit pretty much anything that happens on a SQL Server instance. This book will also help you set up cloud auditing with an emphasis on Azure SQL Database, Azure SQL Managed Instance, and AWS RDS SQL Server.

You don't need expensive, third-party auditing tools to make auditing work for you, and to demonstrate and provide value back to your business. This book will help you set up an auditing solution that works for you and your needs. It shows how to collect the audit data that you need, centralize that data for easy reporting, and generate audit reports using built-in SQL Server functionality for use by your own team, developers, and organization's auditors.

What You Will Learn

• Understand why auditing is important for troubleshooting, compliance, and governance
  
• Track changes and key events using SQL Server Audit and Extended Events
• Track SQL Server configuration changes for governance and troubleshooting
• Utilize change data capture and temporal tables to track data changes in SQL Server tables
• Centralize auditing data from all your databases for easy querying and reporting
• Configure auditing on Azure SQL, Azure SQL Managed Instance, and AWS RDS SQL Server

Who This Book Is For
Database administrators who need to know what's changing on their database servers, and those who are making the changes; database-savvy DevOps engineers and developers who are charged with troubleshooting processes and applications; developers and administrators who are responsible for generating reports in support of regulatory compliance reporting and auditing

了解如何追蹤 SQL Server 資料庫中的變更和關鍵事件，以支援應用程式故障排除、法規合規和治理。本書展示了如何使用 SQL Server 的關鍵功能，例如 SQL Server Audit 和 Extended Events，來追蹤架構變更、權限變更和資料變更。您甚至可以學習如何追蹤對資料庫中特定表格執行的查詢。
並非所有的變更和事件都可以使用 SQL Server Audit 和 Extended Events 捕獲和追蹤，本書超越了這些功能，還展示了使用常見標準合規、變更資料捕獲、時間表格或查詢 SQL Server 日誌來捕獲的內容。您將學習如何僅審核您需要審核的內容，以及如何審核幾乎發生在 SQL Server 實例上的任何事情。本書還將幫助您建立雲端審核，重點放在 Azure SQL Database、Azure SQL Managed Instance 和 AWS RDS SQL Server 上。

您不需要昂貴的第三方審核工具來使審核適用於您，並向您的業務展示價值。本書將幫助您建立適合您和您需求的審核解決方案。它展示了如何收集所需的審核資料，將該資料集中化以便進行簡單的報告，並使用內建的 SQL Server 功能生成審核報告，供您的團隊、開發人員和組織的審計師使用。

您將學到什麼

• 了解為何對故障排除、合規和治理進行審核的重要性
  
  


• 使用 SQL Server Audit 和 Extended Events 追蹤變更和關鍵事件


• 追蹤 SQL Server 的配置變更以進行治理和故障排除


• 利用變更資料捕獲和時間表格追蹤 SQL Server 表格中的資料變更


• 將所有資料庫的審核資料集中化，以便進行簡單的查詢和報告


• 在 Azure SQL、Azure SQL Managed Instance 和 AWS RDS SQL Server 上配置審核

本書適合對象
需要了解其資料庫伺服器上發生變更的資料庫管理員，以及進行變更的人；熟悉資料庫的 DevOps 工程師和開發人員，負責故障排除流程和應用程式；負責生成法規合規報告和審核報告的開發人員和管理員。