Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers

Learn 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 Learn

• Choose the correct data types and database objects when designing your T-SQL
• Write T-SQL that accesses your data efficiently and uses hardware effectively
• Implement source control and testing methods to streamline your deployment process.
• Design T-SQL that is flexible and can be enhanced or modified with little effort
• Plan for long-term data management, including growth and purging of older data
• Enhance database security through features such as encryption, data masking, row-level security, and the SQL Ledger blockchain table type

Who This Book Is For
Database 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

學習如何撰寫和設計簡單高效的 T-SQL 代碼。這本實踐性的書籍通過示例和直觀的解釋教你如何撰寫更好的 T-SQL。本版新增了對參數敏感計劃（PSP）優化、用於實時分析的 Azure Synapse Link、與 S3 相容對象存儲的集成，以及基於區塊鏈的 SQL 分類帳表。你將學習如何改進 T-SQL 設計，以實現更快的性能、更強的安全性和更容易理解。本書還指出了撰寫 T-SQL 常見反模式，並指導你如何修改代碼，以便更有信心地撰寫可靠且性能良好的 T-SQL 代碼。

《Pro T-SQL 2022》專注於開發人員在交付成功應用程序時面臨並必須解決的問題。內容從撰寫清晰易懂的 T-SQL 基礎開始。然後，本書將引導你撰寫性能良好、易於通過編碼標準和版本控制進行管理、可根據業務需求隨時間進行維護和修改、隨著業務增長而擴展，並充分利用內置於 SQL Server 和 Azure SQL 數據庫引擎中的安全功能的 SQL。

你將學到以下內容：
- 在設計 T-SQL 時選擇正確的數據類型和數據庫對象
- 撰寫能夠高效訪問數據並有效利用硬件的 T-SQL
- 實施源代碼控制和測試方法，以簡化部署流程
- 設計靈活的 T-SQL，能夠輕鬆進行增強或修改
- 規劃長期數據管理，包括數據增長和舊數據清理
- 通過加密、數據遮罩、行級安全性和 SQL 分類帳區塊鏈表類型等功能增強數據庫安全性

本書適合對 T-SQL 應用程序效率有所提升的數據庫開發人員；希望更深入了解 T-SQL 以便更輕鬆解決複雜問題的開發人員；以及希望撰寫高質量、性能良好、易於他人理解的 T-SQL 的數據專業人士。

Elizabeth Noble is a Microsoft Data Platform MVP and Director of Database Development in the metro Atlanta area. When ze was introduced to hir first database over 10 years ago, ze found the career ze wanted to pursue. Hir passion is to help others improve the quality and speed of deploying database changes through automation. When ze is not trying to automate database development, ze can be found spending time with zir dogs, painting, paddle boarding, or throwing axes.

Elizabeth Noble 是一位微軟資料平台 MVP，也是亞特蘭大地區的資料庫開發總監。當她在10年前接觸到她的第一個資料庫時，她找到了她想要追求的職業。她的熱情是幫助他人通過自動化來提高部署資料庫變更的質量和速度。當她不在嘗試自動化資料庫開發時，她可以在和她的狗一起度過時間、繪畫、划板或者投擲斧頭。