Dynamic SQL

Applications, Performance, and Security



Bookstore > Books > Dynamic SQL

Price$29.99 - $39.99
Rating
AuthorEd Pollack
PublisherApress
Published2016
Pages250
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484218108
ISBN-139781484218105
EBook Hardcover Paperback

This book is an introduction and deep-dive into the many uses of dynamic SQL in Microsoft SQL Server. Dynamic SQL is key to large-scale searching based upon user-entered criteria. It's also useful in generating value-lists, in dynamic pivoting of data for business intelligence reporting, and for customizing database objects and querying their structure.

Executing dynamic SQL is at the heart of applications such as business intelligence dashboards that need to be fluid and respond instantly to changing user needs as those users explore their data and view the results. Yet dynamic SQL is feared by many due to concerns over SQL injection attacks. Reading Dynamic SQL: Applications, Performance, and Security is your opportunity to learn and master an often misunderstood feature, including security and SQL injection.

All aspects of security relevant to dynamic SQL are discussed in this book. You will learn many ways to save time and develop code more efficiently, and you will practice directly with security scenarios that threaten companies around the world every day. Dynamic SQL: Applications, Performance, and Security 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.




4 5 10

Similar Books


Dynamic SQL, 2nd Edition

Dynamic SQL, 2nd Edition

by Edward Pollack

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 impro...

Price:  $30.40  |  Publisher:  Apress  |  Release:  2019

SQL Queries for Mere Mortals, 4th Edition

SQL Queries for Mere Mortals, 4th Edition

by John L. Viescas

SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques.Step by step, Viescas guides you through creating re...

Price:  $18.13  |  Publisher:  Addison-Wesley  |  Release:  2018

Inside Microsoft Dynamics AX 2012

Inside Microsoft Dynamics AX 2012

by The Microsoft Dynamics AX Team

Dig into the architecture and internals of Microsoft Dynamics AX 2012 - with firsthand insights from the team that designed and developed it. Targeted for solution developers and system implementers, this guide focuses on programming and customization capabilities - including key architectural principles, the application model, framework,...

Price:  $5.60  |  Publisher:  Microsoft Press  |  Release:  2012

Dynamic System Reliability

Dynamic System Reliability

by Liudong Xing, Gregory Levitin, Chaonan Wang

This book focuses on hot issues of dynamic system reliability, systematically introducing the reliability modeling and analysis methods for systems with imperfect fault coverage, systems with function dependence, systems subject to deterministic or probabilistic common-cause failures, systems subject to deterministic or probabilistic comp...

Price:  $107.51  |  Publisher:  Wiley  |  Release:  2019

Microsoft Dynamics NAV Administration

Microsoft Dynamics NAV Administration

by Amit Sachdev, Sharan Oberoi

Microsoft Dynamics NAV is an Enterprise Resource Planning (ERP) software product that integrates financial, manufacturing, supply chain management, sales and marketing, project management, human resources, and services management information from across your organization, into a centralized database. It can take hours to browse through do...

Price:  $3.00  |  Free ebook  |  Publisher:  Packt Publishing  |  Release:  2010

SQL Server DMVs in Action

SQL Server DMVs in Action

by Ian W. Stirk

SQL Server DMVs in Action shows you how to obtain, interpret, and act on the information captured by DMVs to keep your system in top shape. The over 100 code examples help you master DMVs and give you an instantly reusable SQL library. You'll also learn to use Dynamic Management Functions (DMFs), which provide further details that en...

Price:  $36.26  |  Publisher:  Manning  |  Release:  2011

SQL Server 2019 Administration Inside Out

SQL Server 2019 Administration Inside Out

by Randolph West, Melody Zacharias, William Assaf, Sven Aelterman, Louis Davidson, Joseph D'Antoni

Dive into SQL Server 2019 administration - and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to plan, implement, manage, and secure SQL Server 2019 in any production environment: on-premises, cloud, or hybrid. Six experts th...

Price:  $48.15  |  Publisher:  Microsoft Press  |  Release:  2020

A Developer's Guide to Data Modeling for SQL Server

A Developer's Guide to Data Modeling for SQL Server

by Eric Johnson, Joshua Jones

Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL...

Price:  $6.15  |  Publisher:  Addison-Wesley  |  Release:  2008