A word in response to the corona virus crisis: Your print orders will be fulfilled, even in these challenging times. If you don’t want to wait – have a look at our ebook offers and start reading immediately.

Pro T-SQL 2019

Toward Speed, Scalability, and Standardization for SQL Server Developers

Authors: Noble, Elizabeth

Free Preview
  • Promotes simplicity when designing and writing T-SQL
  • Shows when it is beneficial to use specialized T-SQL features
  • Aids in planning for scalability and flexibility in T-SQL program design
see more benefits

Buy this book

eBook 26,99 €
price for Spain (gross)
  • ISBN 978-1-4842-5590-2
  • Digitally watermarked, DRM-free
  • Included format: PDF, EPUB
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover 36,39 €
price for Spain (gross)
  • ISBN 978-1-4842-5589-6
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
  • The final prices may differ from the prices shown due to specifics of VAT rules
About this book

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

  • 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

About the authors

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.

Table of contents (15 chapters)

Table of contents (15 chapters)
  • Data Types

    Pages 3-23

    Noble, Elizabeth

  • Database Objects

    Pages 25-72

    Noble, Elizabeth

  • Standardizing T-SQL

    Pages 73-95

    Noble, Elizabeth

  • Designing T-SQL

    Pages 97-120

    Noble, Elizabeth

  • Set-Based Design

    Pages 123-146

    Noble, Elizabeth

Buy this book

eBook 26,99 €
price for Spain (gross)
  • ISBN 978-1-4842-5590-2
  • Digitally watermarked, DRM-free
  • Included format: PDF, EPUB
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover 36,39 €
price for Spain (gross)
  • ISBN 978-1-4842-5589-6
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
  • The final prices may differ from the prices shown due to specifics of VAT rules
Loading...

Recommended for you

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Pro T-SQL 2019
Book Subtitle
Toward Speed, Scalability, and Standardization for SQL Server Developers
Authors
Copyright
2020
Publisher
Apress
Copyright Holder
Elizabeth Noble
eBook ISBN
978-1-4842-5590-2
DOI
10.1007/978-1-4842-5590-2
Softcover ISBN
978-1-4842-5589-6
Edition Number
1
Number of Pages
XVII, 406
Number of Illustrations
138 b/w illustrations
Topics