Presentations

Here are resources to presentations that I have given.

    • 2017-11-14 – PASS Security Virtual Group – SQL Injection Attacks: Is Your Data Secure?


      SQL injection is one of the most common ways that hackers gain access to your SQL server. Do you know how to protect your data from malicious users? This session will provide an overview of how SQL injection works as well as T-SQL examples and techniques to protect against it. We’ll also take a look at why some commonly used techniques aren’t as secure as many people think. If you ever write or maintain dynamic SQL queries then this session is for you.

      Download demos

    • 2017-09-30 – SQL Saturday Pittsburgh #636 – DBAs vs Developers: JSON in SQL Server 2016/2017

      This session will explore the new JSON functionality introduced in SQL Server 2016 and what improvements are added with 2017. We will use T-SQL examples to learn how these functions can be used to parse, create, and modify JSON data. More importantly, we will discuss how to optimize performance when using these functions.

      By the end of this session DBAs and developers will know how to efficiently work with JSON in SQL Server 2016.

      Download demos

  • 2017-07-22 -SQL Saturday Columbus #653 – DBAs vs Developers: JSON in SQL Server 2016

    This session will explore the new JSON functionality introduced in SQL Server 2016. We will use T-SQL examples to learn how these functions can be used to parse, create, and modify JSON data. More importantly, we will discuss how to optimize performance when using these functions.

    By the end of this session DBAs and developers will know how to efficiently work with JSON in SQL Server 2016.

    Download demos

  • 2017-01-13 – Group By Conference – High Performance SSRS

    SQL Server Reporting Services (SSRS) is an easy-to-use tool for automating reports and creating highly visual dashboards. Although SSRS is easy to learn there are many tips and tricks that can improve your report building experience, not to mention make your reports run blazing fast!

    This rapid-fire session goes over my learnings from the past six years of developing high performance SSRS reports, including topics like multivalue parameter efficiencies, how to best utilize subreports, and performing SQL CRUD operations with SSRS.

    Each rapid-fire topic includes sample data and an SSRS reporting example that users will be able to try out for

    Download presentation and demos