Overview
- Encourages developers to embrace simplicity when designing and writing T-SQL
- Provides an understanding of when it is beneficial to use specialized T-SQL features
- Promotes long-term planning for scalability and flexibility when designing T-SQL
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (19 chapters)
-
Front Matter
Keywords
- SQL Server
- Relational Database
- Database Development
- SQL
- Structured Query Language
- Transact-SQL
- Stored Procedures
- Thinking in Sets
- Execution Plans
- Database Tuning
- Indexing
- Unit Testing
- Integration Testing
- T-SQL Querying
- Advanced SQL Programming
- Joe Celko's SQL for Smarties
- Coding Standards
- Source Control
- Encryption
- Secure T-SQL
About this book
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 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
Authors and Affiliations
About the author
Bibliographic Information
Book Title: Pro T-SQL 2022
Book Subtitle: Toward Speed, Scalability, and Standardization for SQL Server Developers
Authors: Elizabeth Noble
DOI: https://doi.org/10.1007/978-1-4842-9256-3
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)
Copyright Information: Elizabeth Noble 2023
Softcover ISBN: 978-1-4842-9255-6Published: 01 July 2023
eBook ISBN: 978-1-4842-9256-3Published: 30 June 2023
Edition Number: 2
Number of Pages: XVII, 553
Number of Illustrations: 154 b/w illustrations, 13 illustrations in colour
Topics: Database Management, Microsoft and .NET