E-raamat: Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers

Elizabeth Noble

Formaat: PDF+DRM
Ilmumisaeg: 30-Jun-2023
Kirjastus: APress
Keel: eng
ISBN-13: 9781484292563

Teised raamatud teemal:

Formaat - PDF+DRM
Hind: 80,26 €*
* hind on lõplik, st. muud allahindlused enam ei rakendu
Lisa ostukorvi
Lisa soovinimekirja
See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.

Formaat: PDF+DRM
Ilmumisaeg: 30-Jun-2023
Kirjastus: APress
Keel: eng
ISBN-13: 9781484292563

Teised raamatud teemal:

DRM piirangud

Kopeerimine (copy/paste):

ei ole lubatud
Printimine:

ei ole lubatud
Kasutamine:

Digitaalõiguste kaitse (DRM)
Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

Vajalik tarkvara
Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

Seda e-raamatut ei saa lugeda Amazon Kindle's.

Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations. New in this edition is coverage of Parameter Sensitive Plan (PSP) optimization, Azure Synapse Link for real-time analytics, integration with S3-compatible object storage, and SQL Ledger tables based on blockchain. You’ll learn to improve your T-SQL design in ways that provide faster performance, stronger security, and easier comprehension. The book identifies common anti-patterns in writing T-SQL and instructs you on how to change your code so you can be more confident in writing T-SQL code that is reliable and performs well.

Pro T-SQL 2022 is focused on the problems that developers are faced with and must solve in delivering successful applications. The content begins from a foundation of writing T-SQL that is clear and understandable. The book then takes you through writing SQL that performs well, is easy to manage through coding standards and version control, can be maintained and modified as business requirements change over time, scales as your business grows, and takes advantage of the full range of security features built into the SQL Server and Azure SQL database engines.

What You Will Learn

Choose the correct data types and database objects when designing your T-SQL
Write T-SQL that accesses your data efficiently and uses hardware effectively
Implement source control and testing methods to streamline your deployment process.
Design T-SQL that is flexible and can be enhanced or modified with little effort
Plan for long-term data management, including growth and purging of older data
Enhance database security through features such as encryption, data masking, row-level security, and the SQL Ledger blockchain table type

Who This Book Is For

Database developers who want to improve the efficiency of their applications with better T-SQL; developers who want to know more about T-SQL so they can be prepared to solve complex problems more easily; data professionals who want to write high-quality T-SQL that performs well, is flexible to changing needs, and is easy for others to understand

Intermediate user level

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. Enhancement

Part V. Building Scalable T-SQL

16. Managing Data Growth

17. Managing Data Long Term

Part VI. Building Secure T-SQL

18. Implementing Security Features

19. Implementing Encryption

Elizabeth Noble is a Microsoft Data Platform MVP and Director of Database Development in the metro Atlanta area. When ze was introduced to hir first database over 10 years ago, ze found the career ze wanted to pursue. Hir passion is to help others improve the quality and speed of deploying database changes through automation. When ze is not trying to automate database development, ze can be found spending time with zir dogs, painting, paddle boarding, or throwing axes.

Lisainfo e-raamatute kohta