July 9, 2014: Common T-SQL Mistakes

Kevin Boles
Common T-SQL Mistakes

(download materials: Common SQL Programming Mistakes)

We are going to examine a variety of oopsies MANY developers fall prey too – some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application’s performance. I have given this talk over seventy five times now and it is always very highly rated!

Kevin Boles Kevin LinkedIn | Twitter) is a SQL Server expert, working exclusively with the product since v6.5. With over 20 years of database experience and almost 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. He has been a very successful independent consultant for over 15 years. Kevin is also a very frequent speaker, having presented at countless User Groups and over 70 SQL Saturday events! His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Jeff Honsowetz
Avoiding Orphaned Users on Restoration

In moving databases between servers, one method is to backup and restore the database. In this approach, it is helpful to be aware of steps to avoid orphaned users. We will discuss related topics and look forward to hearing other company best practices.

Jeff Honsowetz, CPA. (Website | Blog | LinkedIn | Twitter) Jeff’s career started in accounting and finance and crossed over to IT full time in 2006. He owns a small company called Interject Data Systems in Vancouver WA that has 16 employees and contractors. Their expertise is in process automation and integrations around ERP, budgeting and reporting systems.