Pro T-SQL 2019 : Toward Speed, Scalability, and Standardization for SQL Server Developers / by Elizabeth Noble.

Format:

Book

Author/Creator:

Noble, Elizabeth, Author.

Language:

English

Subjects (All):

SQL server.

Database management.

Microsoft software.

Microsoft .NET Framework.

Database Management.

Microsoft and .NET.

Local Subjects:

Database Management.

Microsoft and .NET.

Physical Description:

1 online resource (XVII, 406 p. 138 illus.)

Edition:

1st ed. 2020.

Place of Publication:

Berkeley, CA : Apress : Imprint: Apress, 2020.

System Details:

text file

Summary:

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.

Contents:

Introduction

Part I. Building Understandable T-SQL

1. Data Types

2. Database Objects

3. Standardizing T-SQL

4. Designing T-SQL

Part II. Building Performant T-SQL

5. Set-Based Design

6. Hardware Usage

7. Execution Plans

8. Optimize T-SQL

Part III. Building Manageable T-SQL

9. Coding Standards

10. Source Control

11. Testing

12. Deployment

Part IV. Building Maintainable T-SQL

13. Functional Design

14. Logging

15. Managing Data Growth.

Notes:

Includes index.

ISBN:

9781484255902

1484255909

OCLC:

1176246173