Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server 2nd Edition

Book Name: Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server 2nd Edition
Author: Edward Pollack
Publisher: Apress; 2nd ed. edition
ISBN-10, 13: 978-1484243176,148424317X
Year: 2018
Pages: 516 pages
Language: English
File size: 10 MB
File format: PDF,EPUB

Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server 2nd Edition Pdf Book Description:

Dynamic SQL is a tool that is often described in bits and pieces, when a need for code arises and time is limited. This book is an opportunity to put as many of those fragments as possible together into a meaningful journey, from defining the technology to delving into its deepest and most complex aspects. This is a dive into many topics that are extremely important when working with any database. We will intentionally delve deeper into performance optimization, application development, and security than may seem necessary. This is meant to be a discussion of smart database design and architecture, with a focus on dynamic SQL. If any topic that is covered in an aside feels incomplete, it is because there simply isn’t room in these pages for a thorough analysis of all of them without losing focus on why we are here. Dynamic SQL is a tool that is often underused, misused, or overused. The many tangents into other arenas of design and development serve as guides to keep us on track and emphasize the value of well written database queries, as well as ensuring that we use dynamic SQL for the correct applications. Each chapter delves into a specific topic and attempts to go into as much detail as possible, while also providing multiple examples to demonstrate it in the simplest way possible.

If you have never written a line of dynamic SQL, this will be an opportunity to learn, practice, and immediately apply it. If you already have experience in writing and using dynamic SQL, this will be a chance to learn new applications while getting a refresher on those you have worked with in the past. Most examples in this book will reference the Microsoft AdventureWorks sample database, which provides basic database structures that can be freely experimented with. Queries are compatible with any version of AdventureWorks, but were tested most heavily with AdventureWorks 2016. If you have a particular interest in database security or optimziation, then you will appreciate the focus on these topics in each chapter. SQL Injection gets an exhaustive review, with many different aspects and examples presented to ensure a thorough explanation of this important topic! Every chapter, regardless of topic, will reference performance whenever possible. It is an oft-made mistake that a database is designed with little data and few users, ignoring the possibility that it will one day grow into a behemoth. Reminders are placed throughout this book to consider query performance at all times, even when performance may seem “good enough.”