Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server

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.

What You'ill Learn

• 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

Developers and database administrators looking to hone and build their T-SQL coding skills. The book is ideal for developers wanting to plumb the depths of application flexibility and troubleshoot performance issues involving dynamic SQL. The book is also ideal for programmers wanting to learn what dynamic SQL is about and how it can help them deliver competitive advantage to their organizations.

深入探索在Microsoft SQL Server中使用動態SQL的眾多用途。本版本已更新為使用SQL Server 2016和SQL Server 2017的最新功能，並融入了分析和數據庫管理的不斷變化的風景。代碼示例已更新為使用新的系統對象和函數，以提高效率和可維護性。

執行動態SQL對於基於用戶輸入條件的大規模搜索至關重要。動態SQL可以生成值列表，甚至是具有最小性能影響的代碼。動態SQL使得商業智能解決方案中的數據動態樞紐以及數據庫對象的自定義成為可能。然而，由於對SQL注入或代碼可維護性的擔憂，許多人對動態SQL感到懼怕。

《動態SQL：Microsoft SQL Server中的應用、性能和安全性》幫助您安全地將靈活和響應能力的應用程式的生產力和用戶滿意度帶到組織中。您的組織對快速變化的業務場景的應對能力的提高將在競爭激烈的全球市場中建立競爭優勢。本版本專注於新應用和現代數據庫架構，說明動態SQL繼續發展並成為管理、性能優化和分析的寶貴工具。

您將學到什麼：

- 構建靈活應對變化的業務需求的應用程式
- 充分利用動態SQL的創造性、創新性和高效能使用
- 了解SQL注入並對其進行有效防禦
- 解決存儲過程和動態SQL的性能問題
- 調試動態SQL以確保正確結果
- 自動化SQL Server中的功能管理

適合閱讀對象：

希望提升和建立T-SQL編碼技能的開發人員和數據庫管理員。本書非常適合希望深入了解應用程式靈活性並解決涉及動態SQL的性能問題的開發人員。本書也非常適合希望了解動態SQL的程序員，以及如何通過動態SQL為組織帶來競爭優勢。