國立虎尾科技大學 |

Pro T-SQL 2022 = toward speed, scalability, and standardization for SQL server developers /

紀錄類型:	書目-語言資料,印刷品 : Monograph/item
正題名/作者:	Pro T-SQL 2022/ by Elizabeth Noble.
其他題名:	toward speed, scalability, and standardization for SQL server developers /
作者:	Noble, Elizabeth.
出版者:	Berkeley, CA :Apress : : 2023.,
面頁冊數:	xvii, 553 p. :ill., digital ; : 24 cm.;
Contained By:	Springer Nature eBook
標題:	Microsoft. -
電子資源:	https://doi.org/10.1007/978-1-4842-9256-3
ISBN:	9781484292563

Pro T-SQL 2022 = toward speed, scalability, and standardization for SQL server developers /
Noble, Elizabeth.

Pro T-SQL 2022toward speed, scalability, and standardization for SQL server developers /[electronic resource] :by Elizabeth Noble. - Second edition. - Berkeley, CA :Apress :2023. - xvii, 553 p. :ill., digital ;24 cm.

1. Data Types -- 2. Database Objects -- 3. Standardizing T-SQL -- 4. Designing T-SQL -- 5. Set-Based Design -- 6. Hardware Usage -- 7. Execution Plans -- 8. Optimizing Databases for T-SQL -- 9. Coding Standards -- 10. Source Control -- 11. Testing -- 12. Deployment -- 13. Functionality -- 14. Logging -- 15. Enhancement -- 16. Managing Data Growth -- 17. Managing Data Long-Term -- 18. Implementing Security Features -- 19. Implementing Encryption.

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.

ISBN: 9781484292563

Standard No.: 10.1007/978-1-4842-9256-3doiSubjects--Topical Terms:

1387749
Microsoft.

LC Class. No.: QA76.73.S67 / N63 2023

Dewey Class. No.: 005.756

Pro T-SQL 2022 = toward speed, scalability, and standardization for SQL server developers /
LDR:03355nam a2200337 a 4500 001 1106139
003 DE-He213
005 20230630113436.0
006 m d
007 cr nn 008maaau
008 231013s2023 cau s 0 eng d
020 $a 9781484292563 $q (electronic bk.)
020 $a 9781484292556 $q (paper)
024 7 $a 10.1007/978-1-4842-9256-3 $2 doi
035 $a 978-1-4842-9256-3
040 $a GP $c GP
041 0 $a eng
050 4 $a QA76.73.S67 $b N63 2023
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
082 0 4 $a 005.756 $2 23
090 $a QA76.73.S67 $b N748 2023
100 1 $a Noble, Elizabeth. $e author. $3 1319753
245 1 0 $a Pro T-SQL 2022 $h [electronic resource] : $b toward speed, scalability, and standardization for SQL server developers / $c by Elizabeth Noble.
250 $a Second edition.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2023.
300 $a xvii, 553 p. : $b ill., digital ; $c 24 cm.
505 0 $a 1. Data Types -- 2. Database Objects -- 3. Standardizing T-SQL -- 4. Designing T-SQL -- 5. Set-Based Design -- 6. Hardware Usage -- 7. Execution Plans -- 8. Optimizing Databases for T-SQL -- 9. Coding Standards -- 10. Source Control -- 11. Testing -- 12. Deployment -- 13. Functionality -- 14. Logging -- 15. Enhancement -- 16. Managing Data Growth -- 17. Managing Data Long-Term -- 18. Implementing Security Features -- 19. Implementing Encryption.
520 $a 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.
650 2 4 $a Microsoft. $3 1387749
650 1 4 $a Database Management. $3 669820
650 0 $a SQL (Computer program language) $3 561599
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
856 4 0 $u https://doi.org/10.1007/978-1-4842-9256-3
950 $a Professional and Applied Computing (SpringerNature-12059)