Elizabeth Noble Pro T-SQL 2022 : Toward Speed, Scalability, & Standardization

Learn how to write and design simple and efficient TSQL code. This is a handson book that teaches you how to write better TSQL with examples and straightforward explanations. New in this edition is coverage of Parameter Sensitive Plan (PSP) optimization, Azure Synapse Link for realtime analytics, integration with S3compatible object storage, and SQL Ledger tables based on blockchain. Youll learn to improve your TSQL design in ways that provide faster performance, stronger security, and easier comprehension. The book identifies common antipatterns in writing TSQL and instructs you on how to change your code so you can be more confident in writing TSQL code that is reliable and performs well. Pro TSQL 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 TSQL that is clear and understandable. The book then takes youthrough 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 TSQLWrite TSQL that accesses your data efficiently and uses hardware effectivelyImplement source control and testing methods to streamline your... | Elizabeth Noble Pro T-SQL 2022 : Toward Speed, Scalability, & Standardization