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

20

ChiSub March Meeting

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

Good morning everyone,

 

This announcement is about our March 20th Meeting. We are honored to have David Bland talk about Statistics.

 

Chicago SQL Saturday.

Saturday, March 17, 2018. This year, we will be at a new venue: Benedictine University in Lisle, IL.  The event is waitlisted, but if you sign up for one of our wonderful pre-cons, here, you can skip the wait list and attend SQL Saturday, guaranteed!

PRECON Sessions:

Aaron Nelson presents: Hands-On Power BI: Monitoring Your SQL Server Environment

Cathrine Wilhelmsen presents: Level Up! From Basic Biml to Automated Data Warehouse Frameworks

Ed Leighton-Dick presents: Data Security for the Cloud

Eddie Wuerch presents: Performance Tuning with Waits and Queues: a Full Day of Waits

 

SQL Saturdays nearby:

April 7th - Madison

 

Andy Yun & Lowry Kozlowski
Chicago Suburban SQL Server User Group

------------

MARCH MEETING DETAILS

REGISTER:  
https://www.eventbrite.com/o/chicago-suburban-sql-server-user-group-7027934567
DATE: Tuesday, March 20th

SPEAKER:  David Bland

TOPIC:  Statistics

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

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

BIO:

Dave has a degree in education from Western Illinois University and has worked as a band director for grades 5 -12 and managed group homes for individuals with disabilities for 12 years.  For the last 20 years Dave has worked in the technology field with over 15 years of SQL Server DBA experience working with all versions since SQL Server 2000.  He has experience as a BI developer and Application developer using VB.NET.  Dave currently supervises the Shared Services DBA team at Stericycle.  He has also worked as a DBA in the casino industry, insurance industry as well as the transportation industry.  He is a frequent presenter at SQL Saturday events throughout the Midwest. Has been teaching SQL Server since version 2000 and currently is the SQL Server instructor at Harper College in Palatine, IL. Dave currently holds 13 certifications including the following: • Microsoft Certified Trainer since 1998 • MCTS: SQL Server 2008, Implementation and Maintenance • MCTS: SQL Server 2008, BI Development and Maintenance • MCSA: SQL Server 2008 • MCSA: SQL Server 2012\2014 • MCSE: SQL Server 2012\2014 - BI • MCDBA: SQL Server 2000 • MCSD  • MCSE: Data Management and Analytics and A+.

 

ABSTRACT:
In this session you will learn the basics of statistics and what they are used for.  We will discuss how statistics are created and how to gather information about them. How teams can use this information to improve performance will also be discussed, including using Extended Events and Execution plans to find missing statistics.  Since it is important the statistics are maintained to work properly, we will discuss what ongoing maintenance should be done on statistics.

 

REGISTER:

https://www.eventbrite.com/o/chicago-suburban-sql-server-user-group-7027934567




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