Dynamic SQL, 2nd Edition

Applications, Performance, and Security in Microsoft SQL Server



Bookstore > Books > Dynamic SQL, 2nd Edition

Price$30.40 - $34.01
Rating
AuthorEdward Pollack
PublisherApress
Published2019
Pages496
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-10148424317X
ISBN-139781484243176
EBook Hardcover Paperback

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 new system objects and functions to improve efficiency and maintainability.

Executing dynamic SQL is key to large-scale searching based on user-entered criteria. Dynamic SQL can generate lists of values and even code with minimal impact on performance. Dynamic SQL enables dynamic pivoting of data for business intelligence solutions as well as customizing of database objects. Yet dynamic SQL is feared by many due to concerns over SQL injection or code maintainability.

Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server helps you bring the productivity and user-satisfaction of flexible and responsive applications to your organization safely and securely. Your organization's increased ability to respond to rapidly changing business scenarios will build competitive advantage in an increasingly crowded and competitive global marketplace. With a focus on new applications and modern database architecture, this edition illustrates that dynamic SQL continues to evolve and be a valuable tool for administration, performance optimization, and analytics.

Build flexible applications that respond to changing business needs; Take advantage of creative, innovative, and productive uses of dynamic SQL; Know about SQL injection and be confident in your defenses against it; Address performance concerns in stored procedures and dynamic SQL; Troubleshoot and debug dynamic SQL to ensure correct results; Automate your administration of features within SQL Server.


  1. (3 books)


5 5 1

Similar Books


Pro PHP Security, 2nd Edition

Pro PHP Security, 2nd Edition

by Chris Snyder, Thomas Myer, Michael Southwell

PHP security, just like PHP itself, has advanced. Updated for PHP 5.3, the 2nd edition of this authoritative PHP security book covers foundational PHP security topics like SQL injection, XSS, user authentication, and secure PHP development. Chris Snyder and Tom Myer also delve into recent developments like mobile security, the impact of J...

Price:  $39.99  |  Publisher:  Apress  |  Release:  2010

Professional Ajax, 2nd Edition

Professional Ajax, 2nd Edition

by Nicholas C. Zakas, Jeremy McPeak, Joe Fawcett

With Professional Ajax, 2nd Edition, as your guide, you'll discover how to break free of the "click and wait" standard and defy all the traditional rules of what can happen on the web. This book arms you with a developer-level understanding of Ajax techniques, patterns, and use cases so that you can create an unprec...

Publisher:  Wrox  |  Release:  2007

Expert Oracle Application Express, 2nd Edition

Expert Oracle Application Express, 2nd Edition

by Doug Gault, Tom Petrus, Denes Kubicek, Dan McGhan, Francis Mignault, Roel Hartman, Raj Mattamal, Jorge Rimblas, Martin D'Souza, Christoph Ruepprich, Dimitri Gielis, Nick Buytaert, Karen Cannell, John Scott, Sharon Kennedy

Expert Oracle Application Express, 2nd Edition is newly updated for APEX 5.0 and brings deep insight from some of the best APEX practitioners in the field today. You'll learn about important features in APEX 5.0, and how those can be applied to make your development work easier and with greater impact on your business. Oracle Applica...

Price:  $16.00  |  Publisher:  Apress  |  Release:  2015

PostGIS in Action, 2nd Edition

PostGIS in Action, 2nd Edition

by Regina O. Obe, Leo S. Hsu

Processing data tied to location and topology requires specialized know-how. PostGIS is a free spatial database extender for PostgreSQL, every bit as good as proprietary software. With it, you can easily create location-aware queries in just a few lines of SQL code and build the back end for a mapping, raster analysis, or routing applicat...

Price:  $4.40  |  Publisher:  Manning  |  Release:  2015

Getting MEAN with Mongo, Express, Angular, and Node, 2nd Edition

Getting MEAN with Mongo, Express, Angular, and Node, 2nd Edition

by Simon Holmes, Clive Harber

Getting MEAN, Second Edition teaches you how to develop full-stack web applications using the MEAN stack. This edition was completely revised and updated to cover MongoDB 4, Express 4, Angular 7, Node 11, and the latest mainstream release of JavaScript ES2015.Juggling languages mid-application can radically slow down a full-stack web proj...

Price:  $38.99  |  Publisher:  Manning  |  Release:  2019

Learning SQL, 2nd Edition

Learning SQL, 2nd Edition

by Alan Beaulieu

Updated for the latest database management systems, this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-conta...

Price:  $14.50  |  Publisher:  O'Reilly Media  |  Release:  2009

Beginning Python Games Development, 2nd Edition

Beginning Python Games Development, 2nd Edition

by Harrison Kinsley, Will McGugan

Learn how to create compelling games using Python and the PyGame games development library. Beginning Python Games Development, 2nd Edition will teach you how to create visuals, do event handling, create 3D games, add media elements, and integrate OpenGL into your Python game.In this update to the first ever book to cover the popular open...

Price:  $39.49  |  Publisher:  Apress  |  Release:  2015

Linux and Solaris Recipes for Oracle DBAs, 2nd Edition

Linux and Solaris Recipes for Oracle DBAs, 2nd Edition

by Darl Kuhn, Charles Kim, Bernard Lopuz

Linux and Solaris Recipes for Oracle DBAs, 2nd Edition is an example-based book on managing Oracle Database under Linux and Solaris. The book is written for database administrators who need to get work done and lack the luxury of curling up fireside with a stack of operating-system documentation. What this book provides instead is task-or...

Price:  $42.49  |  Publisher:  Apress  |  Release:  2015