Chicago Suburban SQL Server User Group

Welcome

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,

October

07

ChiSub SSUG October Meeting

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

OCTOBER MEETING DETAILS


REGISTRATION:  

https://www.eventbrite.com/e/chicago-suburban-ssug-october-2014-meeting-tickets-13336563019


DATE:

Tuesday, October 7th


SCHEDULE:

6:00PM - Doors Open

6:30PM - Meeting Start.  Q & A and Networking

7:00PM - 8:30PM SQLSkills Presentation Mashup


LOCATION:

SWC Technology Partners

1520 Kensington Road

Oak Brook, IL 60523

(Conference Room in basement)


SPONSOR:

SQL Sentry


ABSTRACTS:

Session 1: SQL Sentry Plan Explorer

Presenter: Jonathan Kehayias


Abstract: Learn how SQL Sentry Plan Explorer can help you explore and tune the most difficult query plans! Jonathan will cover the key differences between Plan Explorer and SQL Server Management Studio plus what to look for in estimated and actual plans. Even if you have used Plan Explorer - you might be surprised at the cool things you can do. And, if you haven't used it - you shouldn't go any longer without knowing this revolutionary FREE tool from SQL Sentry!


 

Session 2: Extended Events

Presenter: Erin Stellato


Abstract: If you’re looking to upgrade to SQL Server 2012 or 2014 soon (or, perhaps you already have!) you need to understand how to use Extended Events. Not only can you use Extended Events to accomplish what you’ve been doing with SQL Trace / Profiler, but it’s the only method for capturing information about new features such as In-Memory OLTP and Availability Groups.  We’ll look at Profiler and Extended Events side by side so you can see how easy it is to transition to using Extended Events.


Session 3: Statement Execution / Caching

Presenter: Kimberly Tripp


Abstract: Have you ever wondered how SQL Server caches statements? Or, how much cache can be allocated to your plans? And, how it works - is this a good thing or a bad thing? What are the overall costs and benefits? In this final section, Kimberly will show you a variety of statement execution methods (ad hoc, dynamic, sp_executesql) and how / when (or, if?) they are cached. Additionally, we’ll look at some DMV queries to see them in cache. Finally, Kimberly will also compare and contrast how stored procedures work and when these can prove to be a better option!

 

Featured Presentation:

SQL Sentry Plan Explorer

Learn how SQL Sentry Plan Explorer can help you explore and tune the most difficult query plans! Jonathan will cover the key differences between Plan Explorer and SQL Server Management Studio plus what to look for in estimated and actual plans. Even if you have used Plan Explorer - you might be surprised at the cool things you can do. And, if you haven't used it - you shouldn't go any longer without knowing this revolutionary FREE tool from SQL Sentry!

Jonathan Kehayias, Principal Consultant SQLskills.com

About Jonathan:
Jonathan Kehayias is a Principal Consultant and trainer with SQLskills, and has been recognized as a Microsoft Data Platform MVP for over 10 years, and was the youngest person ever to achieve the Microsoft Certified Master – SQL Server certification. He has presented at numerous conferences including PASS Summit and SQL Rally, SQLBits, VMware Open Forum, SQLintersection, and multiple SQLSaturdays around the world. As a performance tuning and high availability expert for SQL Server, Jonathan has architected and implemented complex systems and solutions for some of the worlds most challenging workloads.

Extended Events

If you’re looking to upgrade to SQL Server 2012 or 2014 soon (or, perhaps you already have!) you need to understand how to use Extended Events. Not only can you use Extended Events to accomplish what you’ve been doing with SQL Trace / Profiler, but it’s the only method for capturing information about new features such as In-Memory OLTP and Availability Groups. We’ll look at Profiler and Extended Events side by side so you can see how easy it is to transition to using Extended Events.

Erin Stellato, Principal Consultant SQLskills

About Erin:
Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.

Statement Execution / Caching

Have you ever wondered how SQL Server caches statements? Or, how much cache can be allocated to your plans? And, how it works - is this a good thing or a bad thing? What are the overall costs and benefits? In this final section, Kimberly will show you a variety of statement execution methods (ad hoc, dynamic, sp_executesql) and how / when (or, if?) they are cached. Additionally, we’ll look at some DMV queries to see them in cache. Finally, Kimberly will also compare and contrast how stored procedures work and when these can prove to be a better option!

Kimberly Tripp, Founder/President/Owner SQLskills.com

About Kimberly:
Kimberly L. Tripp is the founder/co-owner (with her husband, Paul Randal) of SQLskills.com, a world-renowned training and consulting company. She worked for Microsoft University and on the SQL Server team in the early 1990s but left to consult in 1995. Since then, she has been training, consulting, and speaking on a number of SQL Server areas with performance tuning, VLDBs, and optimization her most common topics. Kimberly is an accomplished writer and presenter with numerous top-speaker awards over the years; she is also a SQL Server MVP. You can read more at SQLskills.com. In her free time, and with her husband, Paul Randal, she likes diving, searching for critters, and underwater photography!

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