Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers
暫譯: Pro T-SQL 2022：為 SQL Server 開發者實現速度、可擴展性與標準化
Noble, Elizabeth
買這商品的人也買了...
相關主題
商品描述
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
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
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
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。本版新增了對參數敏感計劃（Parameter Sensitive Plan, PSP）優化、Azure Synapse Link 用於即時分析、與 S3 相容的物件儲存整合，以及基於區塊鏈的 SQL Ledger 表的介紹。你將學會如何改善 T-SQL 設計，以提供更快的性能、更強的安全性和更易於理解的代碼。本書指出撰寫 T-SQL 時常見的反模式，並指導你如何修改代碼，以便在撰寫可靠且性能良好的 T-SQL 代碼時更加自信。
Pro T-SQL 2022 專注於開發人員面臨的問題，並必須解決這些問題以交付成功的應用程式。內容從撰寫清晰易懂的 T-SQL 基礎開始，然後帶你了解如何撰寫性能良好的 SQL，通過編碼標準和版本控制輕鬆管理，隨著業務需求的變化進行維護和修改，隨著業務增長進行擴展，並充分利用 SQL Server 和 Azure SQL 數據庫引擎內建的各種安全功能。
你將學到什麼
- 在設計 T-SQL 時選擇正確的數據類型和數據庫對象
- 撰寫高效訪問數據並有效利用硬體的 T-SQL
- 實施源控制和測試方法，以簡化部署過程
- 設計靈活的 T-SQL，能夠輕鬆增強或修改
- 規劃長期數據管理，包括增長和清除舊數據
- 通過加密、數據遮蔽、行級安全性和 SQL Ledger 區塊鏈表類型等功能增強數據庫安全性
本書適合誰
希望通過更好的 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.
作者簡介(中文翻譯)
伊莉莎白·諾布爾 是微軟數據平台的 MVP 及亞特蘭大地區的數據庫開發總監。當她在十多年前接觸到第一個數據庫時，她發現了自己想要追求的職業。她的熱情在於幫助他人透過自動化來提高數據庫變更的質量和速度。當她不在努力自動化數據庫開發時，通常會和她的狗一起度過時光，畫畫，划槳，或是投擲斧頭。
