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

Noble, Elizabeth

  • 出版商: Apress
  • 出版日期: 2020-02-13
  • 定價: $1,650
  • 售價: 8.0$1,320
  • 語言: 英文
  • 頁數: 406
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1484255895
  • ISBN-13: 9781484255896
  • 相關分類: MSSQLJVM 語言SQL
  • 立即出貨 (庫存=1)

買這商品的人也買了...

商品描述

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

商品描述(中文翻譯)

在 SQL Server 2019 及以後的版本中,設計並撰寫簡單高效的 T-SQL 代碼。撰寫能夠正確返回結果的 T-SQL 可能具有挑戰性。本書提供了撰寫高效且易於維護的 T-SQL 的幫助。您還將學習如何實施版本控制、測試和部署策略。實際示例展示了現代 T-SQL 的實踐方法並提供了直觀的解釋。在設計 T-SQL 解決方案時,特別關注選擇正確的數據類型和對象。作者 Elizabeth Noble 教導您如何通過良好的設計實踐來提高 T-SQL 的性能,從而使程序員和最終用戶受益。您將了解撰寫 T-SQL 的常見陷阱以及如何避免這些陷阱。您將學到以下內容:
- 在設計 T-SQL 時選擇正確的數據類型和數據庫對象
- 撰寫高效搜索數據並有效利用硬件的 T-SQL
- 實施源代碼控制和測試方法以簡化部署過程
- 設計易於增強或修改的 T-SQL
- 規劃長期數據管理和存儲策略
本書適合以下讀者:
- 想要提高應用程序效率的數據庫開發人員
- 通過撰寫高效的 T-SQL,更輕鬆地解決複雜的查詢和數據問題,並使其他開發人員易於理解和維護的開發人員

作者簡介

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.

作者簡介(中文翻譯)

Elizabeth Noble 是亞特蘭大地區的高級資料庫管理員。她在10年前第一次接觸到資料庫時就一見鍾情。她的熱情是幫助他人通過自動化改善資料庫變更的品質和速度。當她不在嘗試自動化所有事情時,她喜歡和她的狗一起度過時間,打飛盤高爾夫,或在健身房散步。