May 2017 Monthly Meeting – Crazy Things Developers Do!

Speaker: Wayne Sheffield

Bio:

Microsoft Certified Master in SQL Server, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of SQL Server 2012 T-SQL Recipes, and enjoys sharing his knowledge by presenting at SQL PASS events and blogging at http://blog.waynesheffield.com/wayne

Session Title:

Crazy Things Developers Do!

Abstract:

Throughout my career, I’ve seen developers do some pretty crazy things to databases (and truth be told, I’ve done some of these myself!). Come to this session to learn what we do and why it’s bad to the database server (or your career)… and alternatives that can be used instead. Some of the topics that we’ll discuss are the pitfalls of using NOLOCK, how coding mistakes open up the database for SQL Injection attacks, and how design choices keep SQL Server dumb – and if it was allowed to be smart, it would be faster! Trust me… your DBA will love you for making these changes.

Thank you to our Sponsors!

 

 

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *