Pro T-SQL 2019: Toward Speed, Scalability, and Standardization for SQL Server Developers - Brossura

Noble, Elizabeth

Brossura

ISBN 10: 1484255895 ISBN 13: 9781484255896

Casa editrice: Apress, 2020

Riassunto

Intermediate user level

Su questo libro

Informazioni sull?autore

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.

Dalla quarta di copertina

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. 

You will:

• 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

Dettagli dell?edizione

• Editore: Apress
• Data di pubblicazione: 2020
• Lingua: Inglese
• ISBN 10: 1484255895
• ISBN 13: 9781484255896
• Rilegatura: Copertina flessibile
• Numero edizione: 1
• Numero di pagine: 424
• Contatto del produttore: Springer Nature Customer Service Center GmbH; ProductSafety@springernature.com