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

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

<div>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. </div><div><br></div><div>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. </div><div><br></div><div><br></div><div><b>What You Will Learn</b></div><div><div><ul><li>Choose correct data types and database objects when designing T-SQL<br></li><li>Write T-SQL that searches data efficiently and uses hardware effectively<br></li><li>Implement source control and testing methods to streamline the deployment process<br></li><li>Design T-SQL that can be enhanced or modified with less effort<br></li><li>Plan for long-term data management and storage</li></ul></div></div><div><b><br></b></div><div><b>Who This Book Is For</b></div><div><br></div><div>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<br></div>