Ed Pollack – författare

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.

Discusses many applications of dynamic SQL, both simple and complex.Explains each example with demos that can be run at home and on your laptop.Helps you to identify when dynamic SQL can offer superior performance.Pays attention to security and best practices to ensure safety of your data.

What You Will Learn

Build flexible applications that respond fast to changing business needs. Take advantage of unconventionalbut productive uses of dynamic SQL. Protect your data from attack through best-practices in your implementations. Know about SQL Injection and be confident in your defenses against it Run at high performance by optimizing dynamic SQL in your applications. Troubleshoot and debug dynamic SQL to ensure correct results.

Who This Book isFor

Dynamic SQL: Applications, Performance, and Security

is for developers and database administratorslooking to hone and build their T-SQL coding skills. The book is ideal foradvanced users wanting to plumb the depths of application flexibility andtroubleshoot performance issues involving dynamic SQL. The book is also idealfor beginners wanting to learn what dynamic SQL is about and how it can helpthem deliver competitive advantage to their organizations.

Become an expert who can use window functions to solve T-SQL query problems. Replace slow cursors and self-joins with queries that are easy to write and perform better. This new edition provides expanded examples, including a chapter from the world of sports, and covers the latest performance enhancements through SQL Server 2019. Window functions are useful in analytics and business intelligence reporting. They came into full blossom with SQL Server 2012, yet they are not as well known and used as often as they ought to be. This group of functions is one of the most notable developments in SQL, and this book shows how every developer and DBA can benefit from their expressive power in solving day-to-day business problems. Once you begin using window functions, such as ROW_NUMBER and LAG, you will discover many ways to use them. You will approach SQL Server queries in a different way, thinking about sets of data instead of individual rows. Your querieswill run faster, be easier to write, and easier to deconstruct, maintain, and enhance in the future.Just knowing and using these functions is not enough. You also need to understand how to tune the queries. Expert T-SQL Window Functions in SQL Server clearly explains how to get the best performance. The book also covers the rare cases when older techniques are the best bet.What You Will LearnSolve complex query problems without cumbersome self-joins that run slowly and are difficult to readCreate sliding windows in a result set for computing such as running totals and moving averagesReturn aggregate and detail data simultaneously from the same SELECT statementCompute lag and lead and other values that access data from multiple rows in a result setUnderstand the OVER clause syntax and how to control the windowAvoid framing errors that can lead to unexpected resultsWho This Book Is For Anyone who writes T-SQL queries, including database administrators, developers, business analysts, and data scientists. Before reading this book, you should understand how to join tables, write WHERE clauses, and build aggregate queries.