
Pro T-SQL 2019
Toward Speed, Scalability, and Standardization for SQL Server Developers
Elizabeth Noble(Author)
APress
1st Edition
Published on 13. February 2020
Book
Paperback/Softback
XVII, 406 pages
978-1-4842-5589-6 (ISBN)
Article exhausted; check for reprint
Description
Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book provides the help you need in writing T-SQL that performs fast and is easy to maintain. You also will learn how to implement version control, testing, and deployment strategies.
Hands-on examples show modern T-SQL practices and provide straightforward explanations. Attention is given to selecting the right data types and objects when designing T-SQL solutions. Author Elizabeth Noble teaches you how to improve your T-SQL performance through good design practices that benefit programmers and ultimately the users of the applications. You will know the common pitfalls of writing T-SQL and how to avoid those pitfalls going forward.
What You Will Learn
Who This Book Is For
Database developers who want to improve the efficiency of their applications, and developers who want to solve complex query and data problems more easily by writing T-SQL that performs well, brings back correct results, and is easy for other developers to understand and maintain
Hands-on examples show modern T-SQL practices and provide straightforward explanations. Attention is given to selecting the right data types and objects when designing T-SQL solutions. Author Elizabeth Noble teaches you how to improve your T-SQL performance through good design practices that benefit programmers and ultimately the users of the applications. You will know the common pitfalls of writing T-SQL and how to avoid those pitfalls going forward.
What You Will Learn
- Choose correct data types and database objects when designing T-SQL
- Write T-SQL that searches data efficiently and uses hardware effectively
- Implement source control and testing methods to streamline the deployment process
- Design T-SQL that can be enhanced or modified with less effort
- Plan for long-term data management and storage
Who This Book Is For
Database developers who want to improve the efficiency of their applications, and developers who want to solve complex query and data problems more easily by writing T-SQL that performs well, brings back correct results, and is easy for other developers to understand and maintain
More details
Edition
1st ed.
Language
English
Place of publication
Berkeley
United States
Target group
Professional and scholarly
Illustrations
138 s/w Abbildungen
XVII, 406 p. 138 illus.
Dimensions
Height: 25.4 cm
Width: 17.8 cm
Weight
802 gr
ISBN-13
978-1-4842-5589-6 (9781484255896)
DOI
10.1007/978-1-4842-5590-2
Schweitzer Classification
Other editions
New editions

Elizabeth Noble
Pro T-SQL 2022
Toward Speed, Scalability, and Standardization for SQL Server Developers
Book
07/2023
2nd Edition
APress
€80.24
Shipment within 15-20 days
Additional editions

Elizabeth Noble
Pro T-SQL 2019
Toward Speed, Scalability, and Standardization for SQL Server Developers
E-Book
02/2020
APress
€46.99
Available for download
Person
Elizabeth Noble is a senior database administrator in the metro Atlanta area. It was love at first sight when she was introduced to her first database over 10 years ago. Her passion is to help others improve the quality and speed of deploying database changes through automation. When she is not trying to automate all things, she can be found spending time with her dogs, playing disc golf, or taking a walk at the gym.
Content
Introduction
Part I. Building Understandable T-SQL1. Data Types2. Database Objects3. Standardizing T-SQL4. Designing T-SQL
Part II. Building Performant T-SQL5. Set-Based Design6. Hardware Usage7. Execution Plans8. Optimize T-SQL
Part III. Building Manageable T-SQL9. Coding Standards10. Source Control11. Testing12. Deployment
Part IV. Building Maintainable T-SQL13. Functional Design14. Logging15. Managing Data Growth
Part I. Building Understandable T-SQL1. Data Types2. Database Objects3. Standardizing T-SQL4. Designing T-SQL
Part II. Building Performant T-SQL5. Set-Based Design6. Hardware Usage7. Execution Plans8. Optimize T-SQL
Part III. Building Manageable T-SQL9. Coding Standards10. Source Control11. Testing12. Deployment
Part IV. Building Maintainable T-SQL13. Functional Design14. Logging15. Managing Data Growth