in

RichmondSQL

Richmond SQL Server Users Group

events

SQLSaturday Pre-Con with Wayne Sheffield and Jason Brimhall

Title: Murder They Wrote
Level: All levels
Description: A Review of database design and coding implementations and how they can be murder on SQL Server in terms of performance, security, storage and even accuracy.

Join Microsoft 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:

SQL Injection
Row-by-Row / Iteration / Cursors
Abusing Views
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

About:

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).

Registration

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

SQLSatIf you can't make Wayne's session on Friday, be sure to check out the sessions on Saturday at the SQLSaturday event!

Questions?

Contact events@richmondsql.org or connect directly with Wayne or Jason via Twitter.

Comments

No Comments
©2006-2011 Richmond SQL Server Users Group; ©2008-©2011 Richmond User Groups Corporation
Powered by Community Server (Non-Commercial Edition), by Telligent Systems