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,

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 Microsoft Certified Master of SQL Server 2008 and a SQL Server MVP. A senior consultant at SQLskills.com, he started with SQL Server in 2004 as a database developer and report writer. After spending 2 1/2 years working in T-SQL, in late 2006, he transitioned to the role of DBA. In early 2011, he joined SQLskills.com full time, focusing on his primary passion of performance tuning. He frequently rewrites queries for better performance.

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 Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 17 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery. Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.

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