Info

GroupBy – Free SQL Server Training

GroupBy.org is free technical training by the community, for the community. Volunteer speakers submit abstracts at GroupBy.org and you – the attendee – vote to pick the sessions. Want to present your own session or just vote on others? Join us at GroupBy.org.
RSS Feed
GroupBy – Free SQL Server Training
2017
October
September
August
July
June
May
April
March
February
January


All Episodes
Archives
Now displaying: Page 1
Jan 31, 2017

Are you faced with complaints from users, poor performing code from developers, and regular requests to build reports? Do you uncover installation and configuration issues on your SQL Server instances? Have you ever thought that in dire times avoiding Worst Practices could be a good starting point? If the answer is “yes”, then this session is for you: together we will discover how not to torture a SQL Server instance and we will see how to avoid making choices that turn out to be not so smart in the long run.

You are probably thinking: “Hey, wait, what about Best Practices?”. Sometimes Best Practices are not enough, especially for beginners, and it is not always clear what happens if we fail to follow them. Worst Practices can show the mistakes to avoid. I have made lots of mistakes throughout my career: come and learn from my mistakes!

Circles in the SQL Server Hell:

Design sins:

  1. Undernormalizers
  2. Generalizers
  3. Shaky Typers
  4. Anarchic Designers
  5. Inconsistent Baptists

Development sins:

  1. Environment Pollutors
  2. Overly Optimistic Testers
  3. Indolent Developers

Installation sins:

  1. Stingy Buyers
  2. Next next finish installers

Maintenance sins:

  1. Careless caretakers
  2. Performance killers
0 Comments