001470278 000__ 04579cam\\22005777i\4500
001470278 001__ 1470278
001470278 003__ OCoLC
001470278 005__ 20230803003410.0
001470278 006__ m\\\\\o\\d\\\\\\\\
001470278 007__ cr\cn\nnnunnun
001470278 008__ 230713s2023\\\\nyua\\\\o\\\\\000\0\eng\d
001470278 019__ $$a1389339401$$a1389612610
001470278 020__ $$a9781484292563$$q(electronic bk.)
001470278 020__ $$a1484292561$$q(electronic bk.)
001470278 020__ $$z9781484292556
001470278 020__ $$z1484292553
001470278 0247_ $$a10.1007/978-1-4842-9256-3$$2doi
001470278 035__ $$aSP(OCoLC)1390403173
001470278 040__ $$aGW5XE$$beng$$erda$$epn$$cGW5XE$$dEBLCP$$dYDX
001470278 049__ $$aISEA
001470278 050_4 $$aQA76.73.S67$$bN63 2023
001470278 08204 $$a005.75/6$$223/eng/20230713
001470278 1001_ $$aNoble, Elizabeth$$c(Database administrator),$$eauthor.
001470278 24510 $$aPro T-SQL 2022 :$$btoward speed, scalability, and standardization for SQL server developers /$$cElizabeth Noble.
001470278 250__ $$aSecond edition.
001470278 264_1 $$aNew York :$$bApress,$$c2023.
001470278 300__ $$a1 online resource (529 pages) :$$billustrations (black and white, and colour).
001470278 336__ $$atext$$btxt$$2rdacontent
001470278 337__ $$acomputer$$bc$$2rdamedia
001470278 338__ $$aonline resource$$bcr$$2rdacarrier
001470278 5050_ $$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.
001470278 506__ $$aAccess limited to authorized users.
001470278 520__ $$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. Youll 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.
001470278 588__ $$aDescription based on print version record.
001470278 650_0 $$aSQL (Computer program language)
001470278 655_0 $$aElectronic books.
001470278 77608 $$iPrint version:$$aNoble, Elizabeth (Database administrator).$$tPro T-SQL 2022.$$bSecond edition.$$dNew York : Apress, 2023$$z9781484292556$$w(OCoLC)1381892956
001470278 852__ $$bebk
001470278 85640 $$3Springer Nature$$uhttps://univsouthin.idm.oclc.org/login?url=https://link.springer.com/10.1007/978-1-4842-9256-3$$zOnline Access$$91397441.1
001470278 909CO $$ooai:library.usi.edu:1470278$$pGLOBAL_SET
001470278 980__ $$aBIB
001470278 980__ $$aEBOOK
001470278 982__ $$aEbook
001470278 983__ $$aOnline
001470278 994__ $$a92$$bISE