Téléchargez le livre : Pro T-SQL 2022

Pro T-SQL 2022

Toward Speed, Scalability, and Standardization for SQL Server Developers de

Éditeur :

Apress


Paru le : 2023-06-30

eBook Téléchargement , DRM LCP 🛈 DRM Adobe 🛈
Lecture en ligne (streaming)
78,87 €
Téléchargement immédiat
Dès validation de votre commande
Image Louise Reader présentation

Louise Reader

Lisez ce titre sur l'application Louise Reader.

badge apple Application Louise Reader
badge Android Application Louise Reader
Description


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 youthrough 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-SQLWrite T-SQL that accesses your data efficiently and uses hardware effectivelyImplement source control and testing methods to streamline your deployment process.Design T-SQL that is flexible and can be enhanced or modified with little effortPlan for long-term data management, including growth and purging of older dataEnhance 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
Pages
553 pages
Collection
n.c
Parution
2023-06-30
Marque
Apress
EAN papier
9781484292556
EAN PDF
9781484292563
Informations sur l'ebook
Nombre pages copiables
5
Nombre pages imprimables
55
Taille du fichier
21914 Ko
Prix
78,87 €
EAN EPUB
9781484292563
Informations sur l'ebook
Nombre pages copiables
5
Nombre pages imprimables
55
Taille du fichier
20306 Ko
Prix
78,87 €

Suggestions personnalisées