Dynamic SQL: Applications, Performance, and Security

by Edward Pollack

IntroductionChapter 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 ScopeChapter 7: Large-scale Searching Chapter 8: Scalable Dynamic Lists Chapter 9: Parameter Sniffing Chapter 10: Dynamic Pivoting and Application ExamplesChapter 11: Database Objects, Collation Conflicts, Data Archiving

304 pages, Paperback

Published May 4, 2016

Reviews

[Luke Darling · Rating 4 out of 5]

Not bad considering there are really not a lot of books on this subject. There are a lot of examples of how to build the queries which really just becomes complex string manipulation. Goes into detail on SQL injection and what you should be aware of. Knocked down a star because they want you to pay an additional $5 for the digital copies and code examples.

[Lolo · Rating 2 out of 5]

A well written book, but the title is misleading. About 70% of the book is how to write SQL queries. The rest is about dynamic SQL. This means that if you're familiar with Dynamic SQL, there are few new things in this book. If you're a beginner, this is a good book to learn SQL and the techniques of dynamic SQL.