LEADER 03932nam 22005535 450 001 9910734823103321 005 20230630113436.0 010 $a9781484292563 010 $a1484292561 024 7 $a10.1007/978-1-4842-9256-3 035 $a(MiAaPQ)EBC30614278 035 $a(Au-PeEL)EBL30614278 035 $a(DE-He213)978-1-4842-9256-3 035 $a(PPN)272270709 035 $a(CKB)27357704400041 035 $a(Perlego)4515699 035 $a(EXLCZ)9927357704400041 100 $a20230630d2023 u| 0 101 0 $aeng 135 $aurcnu|||||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aPro T-SQL 2022 $eToward Speed, Scalability, and Standardization for SQL Server Developers /$fby Elizabeth Noble 205 $a2nd ed. 2023. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2023. 215 $a1 online resource (555 pages) 311 08$aPrint version: Noble, Elizabeth Pro T-SQL 2022 Berkeley, CA : Apress L. P.,c2023 9781484292556 327 $a1. 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. 330 $aLearn 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. 606 $aDatabase management 606 $aMicrosoft software 606 $aMicrosoft .NET Framework 606 $aDatabase Management 606 $aMicrosoft 615 0$aDatabase management. 615 0$aMicrosoft software. 615 0$aMicrosoft .NET Framework. 615 14$aDatabase Management. 615 24$aMicrosoft. 676 $a005.756 700 $aNoble$b Elizabeth$0952610 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910734823103321 996 $aPro T-SQL 2022$93404548 997 $aUNINA