Major Myths about SQL Server

Title: Major Myths about SQL Server

Level: 200

Abstract: Let’s have some fun!  Using a game show style presentation, Kevin will test your knowledge of commonly held misconceptions about SQL Server and point out truth from myth!  Winners get free eBooks written by Kevin.

The Internet is full of great information about SQL Server.  Unfortunately, much of that information was written a long time ago and hasn’t been updated since.  Consequently, a lot of sincere developers and administrators are following protocols that can hurt, not help performance, reliability, and maintainability of their applications.

This session will point out myths about:

  • Configuration and Setup
  • Memory, IO, and CPU
  • Performance
  • Transact-SQL Programming
  • Data Types and Database Design
  • Whether Bill Gates really thinks Access and SQL Server are the same thing

So let’s have some fun clearing out the cobwebs of old recommendations and faulty assumptions.  Learn about the major myths of SQL Server so that they don’t set you back!

Prerequisites: General experience with the SQL Server relational engine as a developer or administrator

Goal 1: Review the most widespread myths about SQL Server

Goal 2: Learn where to go for the most up-to-date and accurate information about SQL Server

Goal 3: Pummel naysayers and Oracle fanboys into submission with your superior knowledge of SQL Server!

Rate it! Rate my session and offer feedback here.