Featured Presentation

Dynamic SQL - Uses and Risks

Speaker: Robert Biddle

Summary: Dynamic SQL has existed in some form or another since the concept of the language was created. Still to this day, there are many great performance benefits to using Dynamic SQL. However, there are serious caching and security concerns. In this session, we'll look at how to safely use Dynamic SQL to alleviate these concerns.

About Robert: Robert is a Data Architect with Hilton Grand Vacations. He's worked with SQL Server since 2004 and has worked on a variety of projects in administration, development, BI and data warehousing. He has MCITP DBA and Database Developer certifications in both 2005 and 2008.

Pre-Meeting Presentation

Deadlock Analysis and Prevention (Part 2)

Speaker: Jonathan Kehayias (Video replay from Pluralsight.com)

Summary: In part 2 of a 3 part series, learn how to analyze and prevent troublesome deadlocks that can occur in SQL Server, applicable for developers, DBAs, and anyone who uses SQL Server from SQL Server 2005 onwards.

cage-aids
cage-aids
cage-aids
cage-aids