This event has ended

SQL Saturday #331 Denver Pre-Con w/Jason Brimhall & Wayne Sheffield

Denver SQL Server User Group

Friday, September 19, 2014 from 9:00 AM to 5:00 PM (MDT)

Englewood, CO

SQL Saturday #331 Denver Pre-Con w/Jason Brimhall &...

Ticket Information

No tickets available.

Who's Going

Loading your connections...

Share SQL Saturday #331 Denver Pre-Con w/Jason Brimhall & Wayne Sheffield

Event Details

Title: Murder They Wrote
Abstract:

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.

Some of 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
Speaker: Jason Brimhall & Wayne Sheffield

Speaker Bio:

 

 

 

 

 

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

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

Have questions about SQL Saturday #331 Denver Pre-Con w/Jason Brimhall & Wayne Sheffield? Contact Denver SQL Server User Group

When & Where


Cherry Creek Presbyterian Church - Community Life Center
10150 E. Belleview Ave.
Englewood, CO 80111

Friday, September 19, 2014 from 9:00 AM to 5:00 PM (MDT)


  Add to my calendar

Organizer

Denver SQL Server User Group

The Denver SQL Server User Group is organized to bring professionals of all career levels that work with Microsoft's SQL Server, together to learn and network with others. There is no charge to attend and you are encouraged to bring your co-workers. Through our sponsors, we provide food and refreshments.


We meet every third Thursday of each Month at Microsoft DTC (7595 Technology Way, Suite 400, Denver, CO 80237).


Visit http://denversql.org for more information and to create a free account.

  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.