
As an Amazon Associate and affiliate partner, Menrva Books earns from qualifying purchases. Learn more
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 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 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 e
This book investigates how to write and design simple, efficient, and scalable T-SQL code for SQL Server developers. It provides a hands-on approach with examples and explanations to improve T-SQL design for faster performance, stronger security, and easier comprehension. The content addresses common anti-patterns, guides developers in writing reliable and performant code, and covers essential aspects like data types, database objects, source control, testing, long-term data management, and security features such as encryption, data masking, row-level security, and SQL Ledger blockchain tables. New in this edition are updates on Parameter Sensitive Plan (PSP) optimization, Azure Synapse Link, and integration with S3-compatible object storage.
This book is targeted at database developers seeking to enhance their T-SQL coding and design skills. The content focuses on practical application, aiming to equip readers with the knowledge to create reliable, performant, and maintainable SQL code. It addresses real-world problems faced by developers in delivering successful applications, emphasizing clarity, efficiency, and scalability. The inclusion of new features like PSP optimization and Azure Synapse Link indicates an effort to keep the material current with modern database development practices.
Page Count:
553
Publication Date:
2023-07-01
Publisher:
Apress
ISBN-10:
1484292553
ISBN-13:
9781484292556
No comments yet. Be the first to share your thoughts!