Dynamic SQL: Applications, Performance, and Security

Dynamic SQL: Applications, Performance, and Security

by Ed Pollack

Paperback(1st ed.)

$39.99
Choose Expedited Shipping at checkout for guaranteed delivery by Wednesday, January 23

Product Details

ISBN-13: 9781484218105
Publisher: Apress
Publication date: 04/30/2016
Edition description: 1st ed.
Pages: 279
Product dimensions: 7.01(w) x 10.00(h) x (d)

About the Author

Edward Pollack is a database administrator with over 15 years of professional experience in database design, optimization, server hardware, and public speaking. He has spoken at dozens of SQL Saturday events, as well as at 24 Hours of PASS and the PASS Summit. His passion for sharing knowledge also leads him to create and coordinate a SQL Saturday in New York’s Capital Region, where he has lived for the past 19 years. His long experience computing has lead Edward through many different fields of study, but data storage, security, and optimization has been the one area that has always been of most interest; it will continue to be so for as long as people continue to care about their data.

Table of Contents


Introduction
Chapter 1: What is Dynamic SQL?
Chapter 2: Dynamic SQL Best Practices
Chapter 3: Protecting Against Malicious Input
Chapter 4: Warding Off SQL Injection
Chapter 5: Permissions and Security
Chapter 6: Managing Scope
Chapter 7: Large-scale Searching
Chapter 8: Scalable Dynamic Lists
Chapter 9: Parameter Sniffing
Chapter 10: Dynamic Pivoting and Application Examples
Chapter 11: Database Objects, Collation Conflicts, Data Archiving

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews