Skip Main Navigation
Page Content

Save This Event

Event Saved

SQL Saturday 594 pre-con with Pinal Dave

EDMPASS - Edmonton SQL Server User Group

Sunday, 23 April 2017 from 8:30 AM to 4:30 PM (MDT)

SQL Saturday 594 pre-con with Pinal Dave

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
Pre-Con with Pinal Dave
Entitles holder to all day session plus lunch plus refreshments
42 Tickets 23 Apr 2017 $120.00 $4.80

Who's Going

Loading your connections...

Share SQL Saturday 594 pre-con with Pinal Dave

Event Details

Enjoy a full day pre conference with Pinal Dave (http://blog.sqlauthority.com). live in person.

33 (Tips and Scripts): The Secret Toolbox for Performance Tuning and Optimizing Queries

Session Abstract:

This demo-oriented a day-long session will answer the questions which DBA and Developers often wonder about Performance Tuning and Query Optimization. There are some problems which have straight forward answers, but there are some problems which are often invisible or needs attention without even a problem statement. This day-long session will be divided in these three major components

 

1) Identifying common patterns and anti-patters for database performance tuning

For example: a) slow running queries, b) IO Intensive operations, c) CPU bottlenecks, d) memory optimizations e) tempdb contention and much more

 

2) Resolving optimization hindrances and issues proactively

For example: a) indexing strategies, b) file growths, c) server deployment best practices, d) statistics, e) wait stats and queues and much more

 

3) Avoid query performance surprises when upgraded to the latest version of SQL Server 2014 and 2016

For example: a) new cardinality engine, b) column store indexes best practices c) live plans, d) azure enhancements, e) in-memory OLTP optimizations and much more.

 

We will discuss 33 different tips and tricks along with scripts in this session and every attendee will have those scripts handy upon completion of the session.

 

The session will have a unique storytelling style of presentation. We will have a big story arc (an experience DBA with Jr. Intern) with three sub story lines. 33 total scripts and tips will be discussed.  Stay alert for pop quizzes.

Session Prerequisites: Basic understanding of SQL Server concepts.

 

Session Goal1:

Identifying common patterns and anti-patters for database performance tuning

For example: a) slow running queries, b) IO Intensive operations, c) CPU bottlenecks, d) memory optimizations e) tempdb contention and much more

 

Session Goal2:

Resolving optimization hindrances and issues proactively

For example: a) indexing strategies, b) file growths, c) server deployment best practices, d) statistics, e) wait stats and queues and much more

 

Session Goal3:
Avoid query performance surprises when upgraded to the latest version of SQL Server 2014

For example: a) new cardinality engine, b) column store indexes best practices c) live plans, d) azure enhancements, e) in-memory OLTP optimizations and much more.

 

Additional Notes:

This session will be a demo heavy session with a pop quiz at every hour to keep attendees attentive. We will have a big story arc (an experience DBA with Jr. Intern) with three sub story lines. 33 total scripts and tips will be discussed.

Lunch, snacks and refreshments will be provided. Please advise of any dietary restrictions.

 

FAQs 

What are my transportation/parking options for getting to and from the event?

Event Location: https://goo.gl/maps/2USafst5vuG2

Bus or LRT: http://etstripplanner.edmonton.ca/RouteSchedule.aspx 

Parking lots: https://www.google.ca/maps/search/parking+lots/@53.5433343,-113.5699467,13z/data=!3m1!4b1!4m8!2m7!3m6!1sparking+lots!2sCanadian+Western+Bank,+10303+Jasper+Avenue,+Edmonton,+AB+T5J+3N6!3s0x53a02247ca14375b:0xcc83354d271b4bcd!4m2!1d-113.4979098!2d53.5406152

 

What can I bring into the event?

Laptop, pen and writing pads

 

How can I contact the organizer with any questions?

SQLSaturday594@sqlsaturday.com

 

What's the refund policy?

Full refund up to $120 per person if the event is cancelled or before February 1, 2017.

$60 refund before Mar 1, 2017

$20 refund before Apr 1, 2017

No refunds after April 1, 2017

 

 

 

 

Have questions about SQL Saturday 594 pre-con with Pinal Dave? Contact EDMPASS - Edmonton SQL Server User Group

Save This Event

Event Saved

When & Where


Canadian Conference room (Lower Level)
Canadian Western Bank Building
10303 - Jasper Ave
Edmonton, Alberta Canada
Canada

Sunday, 23 April 2017 from 8:30 AM to 4:30 PM (MDT)


  Add to my calendar

Organizer

EDMPASS - Edmonton SQL Server User Group

EDMPASS - Professional Association for SQL Server Edmonton Chapter, Edmonton SQL Server User Group

 

  Contact the Organizer
SQL Saturday 594 pre-con with Pinal Dave
Things to do in Edmonton Class Business

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.