Chicago Suburban SQL Server User Group

MEMBERSHIP

If you have not done so already, please register on PASS.  Then update your PASS Profile & Join our Chapter there. All future mailings will be sent out via your SQLPass account:

http://www.sqlpass.org/PASSChapters/LocalChapters.aspx

Quick Search on "Chicago Suburban SQL Server User Group" and make sure you are registered as a member.  Doing so will ensure that you will receive future e-mails from us.

Next Meeting

Tuesday,

March

17

ChiSub SSUG March Meeting

  • In-Person @ 3005 Highland Parkway #100 Downers Grove, Illinois, United States (map)
  • 17:30 - 21:00 Central Daylight Time
  • Language: English

MARCH MEETING DETAILS

REGISTERhttp://www.eventbrite.com/e/chicago-suburban-ssug-march-2015-meeting-tickets-16085883310

DATE: Tuesday, March 17th

SPEAKER:  Ted Krueger

TOPIC:  Performance Tuning SQL Server – Execution Plans

LOCATION:
DeVry University
3005 Highland Parkway #100,
Downers Grove, IL 60515

AGENDA:
5:30PM - Doors Open
6:00PM - Meeting Start. Announcements.
6:15PM - Dinner w. Networking/Open Q&A (bring your questions!)
6:45PM - Main Presenter

ABSTRACT:
As a seasoned DBA, we often forget the basics of query tuning may be an area others haven’t been introduced to. Tuning can be a mystery for developers and DBAs that are starting out with SQL Server. Each operation and its cost can lead to lengthy research escapades, determining if the work is even worth the time to attempt a change in the overall execution plan. This session is going to discuss the basics of tuning; however, we can't end there. The second half of the session, the discussion portion, will focus on the key operations in the execution plan. The overall goal of the session is to take away knowledge on how to start with a query and use execution plans to refine it and turn it into a finely tuned process.

As a preview, we will run through a virtual lab in the beginning of this session to show how you can take all this knowledge directly to your laptop and begin building skills to a new level.

SPEAKER BIO:
Ted Krueger is a SQL Server MVP and Author that has been working in development and database administration and the owner of a successful consulting business, DataMetrics Consulting. Specialties range from High Availability and Disaster / Recovery setup and testing methods down to custom assembly development for SQL Server Reporting Services. Ted blogs and is also one of the founders of LessThanDot.com technology community. Some of the articles focused on are Backup / Recovery, Security, SSIS and working on SQL Server and using all of the SQL Server features available to create stable and scalable database services.

Featured Presentation:

Performance Tuning SQL Server – Execution Plans

As a seasoned DBA, we often forget the basics of query tuning may be an area others haven’t been introduced to. Tuning can be a mystery for developers and DBAs that are starting out with SQL Server. Each operation and its cost can lead to lengthy research escapades, determining if the work is even worth the time to attempt a change in the overall execution plan. This session is going to discuss the basics of tuning; however, we can't end there. The second half of the session, the discussion portion, will focus on the key operations in the execution plan. The overall goal of the session is to take away knowledge on how to start with a query and use execution plans to refine it and turn it into a finely tuned process.

Ted Krueger, SQL Server MVP LessThanDot

About Ted:
Ted Krueger is a SQL Server MVP and has been working in development and database administration for the better part of his career. Specialties range from High Availability and Disaster / Recovery design, implementation, testing methods and administration, down to custom assembly development for SQL Server Reporting Services.

REGISTER:

None




PASSChapterLogo100.jpg


sql_micro_sm.gif







Andy Yun
E-Mail: SQLBek@gmail.com
Twitter: @SQLBek

Lowry Kozlowski
E-Mail: lowrykoz@gmail.com
Twitter: @lowrykoz

Chapter E-Mail: 
chisuburbanssug@sqlpass.org

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids