Title: Murder They Wrote
Level: All levels
Review of database design and coding implementations and how they can
be murder on SQL Server in terms of performance, security, storage and
Certified Masters, Wayne Sheffield and Jason Brimhall, as they examine
numerous database design and coding implementations that they have seen
over the years. They will explore these implementations and show how
they can be murder on SQL Server in terms of performance, security,
storage and even accuracy. You will learn how you can identify these
“killers” and how you can implement alternatives that will keep data
professionals, management, and end-users happy. All while keeping your
databases happy, secure, turbo-charged and healthy.
What we’ll be covering:
Row-by-Row / Iteration / Cursors
Functions and how all but inline table-valued functions suck performance wise
Quick overview of why using table variables can be bad
Not using an ORDER BY clause and assuming there will be an order.
SARGABLE – what it is, what makes a query be sargable, what breaks it
Data type mismatch
Data type selection
How using IN() or correlated subqueries instead of a join affects performance
How ORM tools affect performance by doing almost all of the above
Wayne Sheffield, a
Microsoft Certified Master in SQL Server, started working with xBase
databases in the late 80's. With over 20 years in IT, he has worked with
SQL Server (since 6.5 in the late 90's) in various dev/admin roles,
with an emphasis in performance tuning. He is the author of several
articles at www.sqlservercentral.com, a co-author of SQL Server 2012
T-SQL Recipes, and enjoys sharing his knowledge by presenting at SQL
PASS events and blogging at http://blog.waynesheffield.com/wayne
Jason Brimhall has
10+ yrs experience and has worked with SQL Server from 6.5 through SQL
2012. He has experience in performance tuning, high transaction
environments, as well as large environments. He is currently a
consultant specializing in performance tuning, server analysis and
problem resolution. Jason is a Microsoft Certified Master(MCM) in SQL
Server. He is the VP of the Las Vegas User Group (SSSOLV).
The cost for the class is $99 if you register by February 20th, when they raise to $125. When you register
, be sure to choose Wayne's class.
SQLSaturday RVA Style
If you can't make Wayne's session on Friday, be sure to check out the sessions on Saturday at the SQLSaturday event!
Contact firstname.lastname@example.org or connect directly with Wayne or Jason via Twitter.