SQL Server Administration and Maintenance

SQH10 Secrets of SQL Server - Database Worst Practices

12/08/2016

1:30pm - 2:45pm

Level: Introductory to Intermediate

Pinal Dave

MS Computer Science

Founder

SQLAuthority.com

"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. This 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. This session will focus on some of the common errors and their resolution. You'll walk out with scripts and knowledge you can apply to your own servers.

You will learn:

  • About some of the worst practices which produce incorrect results
  • About some of the worst practices that produce slow results
  • Discuss performance tuning best practices with SQL Server 2014, such as Cardinality estimate, In-Memory Optimization