SQL Server Administration & Maintenance

SQH11 Secrets of SQL Server: Database Worst Practices


2:30pm - 3:45pm

Level: Intermediate

Pinal Dave

SQL Server Performance Tuning Expert


"Oh! What did I do?" Chances are you've 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. In this session we'll focus on some of the common errors and their resolution. Developers will walk out with scripts and knowledge that can be applied to their servers immediately post-session.

You will learn:

  • SQL Server 2017 features
  • SQL Server performance tuning
  • Internals of SQL Server