SQH05 Secrets of SQL Server: Database WORST Practices


9:30am - 10:45am

Level: Introductory to Intermediate

Pinal Dave

MS Computer Science

SQL Server Performance Tuning Expert

This demo-oriented session will highlight database worst practices and how to avoid them.

"Oh my God! What did I do?" Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them. We will shed light on some of these perils and the tricks to avoid them may even save your current job. After attending this session, Developers will only need 60 seconds to improve the performance of their database server in their SharePoint implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session. Additionally, all attendees of the session will have access to learning material presented in the session.

You will learn:

  • Performance
  • Best Practices
  • Tuning
  • Database