Dynamic SQL
Applications, Performance, and Security
| Price | $29.99 - $39.99
|
| Rating |   |
| Author | Ed Pollack |
| Publisher | Apress |
| Published | 2016 |
| Pages | 250 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1484218108 |
| ISBN-13 | 9781484218105 |
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.
- Ed Pollack
4 5 10
Similar Books
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
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
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
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
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
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
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
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