Dynamic SQL Applications, Performance, and Security in Microsoft SQL Server /

Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the changing landscape of analytics and database administration. Code examples have been updated with n...

Πλήρης περιγραφή

Λεπτομέρειες βιβλιογραφικής εγγραφής
Κύριος συγγραφέας: Pollack, Edward (Συγγραφέας, http://id.loc.gov/vocabulary/relators/aut)
Συγγραφή απο Οργανισμό/Αρχή: SpringerLink (Online service)
Μορφή: Ηλεκτρονική πηγή Ηλ. βιβλίο
Γλώσσα:English
Έκδοση: Berkeley, CA : Apress : Imprint: Apress, 2019.
Έκδοση:2nd ed. 2019.
Θέματα:
Διαθέσιμο Online:Full Text via HEAL-Link
Πίνακας περιεχομένων:
  • 1. What is Dynamic SQL?
  • 2. Protecting Against SQL Injection
  • 3. Large Scale Searching
  • 4. Permissions and Security
  • 5. Managing Scope
  • 6. Performance Optimization
  • 7. Scalable Dynamic Lists
  • 8. Parameter Sniffing
  • 9. Dynamic PIVOT and UNPIVOT
  • 10. Solving Common Problems
  • 11. Applications of Dynamic SQL
  • 12. Index Usage and Maintenance. .