Dynamic SQL, 2nd Edition

Applications, Performance, and Security in Microsoft SQL Server



Bookstore > Books > Dynamic SQL, 2nd Edition

Price$30.40 - $34.46
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.





Similar Books


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

Pro SQL Database for Windows Azure, 2nd Edition

Pro SQL Database for Windows Azure, 2nd Edition

by Scott Klein, Herve Roggero

Pro SQL Database for Windows Azure, 2nd Edition shows how to create enterprise-level database deployments without the usual investment in datacenter and other infrastructure. Take advantage instead of Microsoft's worldwide backbone for cloud computing that delivers all the power of SQL Server in the form of the cloud-based SQL Database fo...

Price:  $44.67  |  Publisher:  Apress  |  Release:  2012

SQL and Relational Theory, 2nd Edition

SQL and Relational Theory, 2nd Edition

by C.J. Date

SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put the theory into practice. In this insightful book, author C.J. Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it directly to you...

Price:  $16.10  |  Publisher:  O'Reilly Media  |  Release:  2011

Beginning SQL Queries, 2nd Edition

Beginning SQL Queries, 2nd Edition

by Clare Churcher

Get started on mastering the one language binding the entire database industry. That language is SQL, and how it works is must-have knowledge for anyone involved with relational databases, and surprisingly also for anyone involved with NoSQL databases. SQL is universally used in querying and reporting on large data sets in order to genera...

Price:  $24.31  |  Publisher:  Apress  |  Release:  2016

Effective C#, 2nd Edition

Effective C#, 2nd Edition

by Bill Wagner

C# has matured over the past decade: It's now a rich language with generics, functional programming concepts, and support for both static and dynamic typing. This palette of techniques provides great tools for many different idioms, but there are also many ways to make mistakes. In Effective C#, Second Edition, respected .NET expert Bill ...

Price:  $15.00  |  Publisher:  Addison-Wesley  |  Release:  2010

HTML, XHTML and CSS All-In-One For Dummies, 2nd Edition

HTML, XHTML and CSS All-In-One For Dummies, 2nd Edition

by Andy Harris

HTML, XHTML, and CSS are essential tools for creating dynamic Web sites. This friendly, all-in-one guide covers what programmers need to know about each of the technologies and how to use them together.Like the bestselling first edition, HTML, XHTML, and CSS All-in-One For Dummies, 2nd Edition makes it easy to grasp the fundamentals and s...

Price:  $3.00  |  Publisher:  Wiley  |  Release:  2010

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

Pro Django, 2nd Edition

Pro Django, 2nd Edition

by Marty Alchin

Learn how to leverage Django, the leading Python web application development framework, to its full potential in this advanced tutorial and reference. Updated for Django 1.5 and Python 3, Pro Django, Second Edition examines in great detail the complex problems that Python web application developers can face and how to solve them. It provi...

Price:  $43.53  |  Publisher:  Apress  |  Release:  2013