$129 – $195

#SQLSat835 PreCon: Murder They Wrote!

Event Information

Share this event

Date and Time

Location

Location

Montgomery County Community College

Whitpain Township, PA 19422

View Map

Refund Policy

Refund Policy

No Refunds

Event description

Description

PSSUG is excited to present another great PreCon for SQL Saturday 835 in Philadelphia:

Murder They Wrote!

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

  • Some of the many ways that Views can be abused

  • Functions: which ones you should use for better performance, and why.

  • Inherent design flaws of table variables that can lead to performance issues

  • Assumptions in the use, or lack therein, of an ORDER BY clause

  • The effects of SARG-ability on query performance and the Cardinality Estimator

  • Data Types and the effects on storage, performance, and maintenance operations

  • Explore some performance implications when using various methods in lieu of a Join

  • Various tools can also have an impact on Database performance and we will explore that too!

  • And much much more


Your Instructors: Jason Brimhall and Wayne Sheffield

Jason Brimhall

Jason Brimhall has more than 10 years of experience and has worked with SQL Server 6.5 through SQL 2016. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and MVP for SQL Server.

Wayne Sheffield

Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 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 T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne

Pricing

Book your ticket now, the price is going to go up soon:

$129 until 3/15 (for the first 5 attendees only)
$147 until 3/31
$175 until 4/15
$195 until 5/3

Share with friends

Date and Time

Location

Montgomery County Community College

Whitpain Township, PA 19422

View Map

Refund Policy

No Refunds

Save This Event

Event Saved