Greater Lansing Area for SQL Server (GLASS)

Greater Lansing Area for SQL Server

We are a group of professionals who like to get together to talk about Microsoft SQL Server and related technologies. Meetings are open and free of cost to the public but will require an RSVP so we can get an accurate count for food. 

Goals

1. Facilitate networking and create opportunities for our members
2. Deliver quality content for in-depth learning and professional development
3. Encourage community growth and development

Contact Information

1. Mailing list signup: http://eepurl.com/bf3IW1
2. Twitter: https://twitter.com/GlassUserGroup
3. LinkedIn: https://www.linkedin.com/groups?home=&gid=8264371&trk=anet_ug_hm
4. Meetup.com: http://www.meetup.com/GLASS-Greater-Lansing-Area-for-SQL-Server/

 


Next Meeting

Tuesday,

June

14

SQL Server Execution Plans

  • In-Person @ Lansing, Michigan, United States (map)
  • 17:30 - 19:30 Eastern Daylight Time
  • Language: English

Speaker: Jody Meyer

Session Title: SQL Server Execution Plans 

Abstract: There are tools such as the SQL Server Execution Plan to help you resolve questions like speed issues. SQL Server creates and saves these Execution Plans for future use. SQL Server Management Studio gives us a way to look at these Execution Plans graphically and save them so we can share with other developers. In doing so, we can then work together to come up with the best solution for faster speed.

So, do you want to answer questions like:

Why is my T-SQL query running slow?
Is SQL Server using the indexes?
Why isn't SQL Server using an index?
Are there tools out there to help me determine this?

Most SQL Server developers and administrators will tell you, “It depends”. Execution Plans show you what’s going on behind the scenes in SQL Server. The plans can provide you with a wealth of information on how SQL Server is executing your queries, including: which indexes are getting used or not used, how the data is being retrieved and joined, how aggregations in GROUP BY queries are put together, anticipated load, and the estimated cost of all the operations.


Speaker Bio

Jody Meyer has been a software developer for 30 years and has been using Fox for all but three of them. Currently, Jody works for White Light Computing (WLC). At WLC, she works with all kinds of customers on various SQL Server/VFP applications. Previously, she was the chief architect of the WinMAGI framework, which is a world-class manufacturing ERP system for small
to mid-sized manufacturers.

After hours, Jody takes her passion for software development and applies it to some volunteer projects and a couple of user groups. She is the President and Webmaster of the Grand Rapids Area FoxPro User Group (GRAFUG). She is a member of the Detroit Area Fox User Group (DAFUG), Great Lansing Area for SQL Server (GLASS), and has been known to make the trek to the Chicago FoxPro Users and Developers Group (ChicagoFUDG). She has attended a number of SQL Saturday conferences as well. When she isn't a taxi driver for her son David to Karate and Royal Ranger events, Jody loves learning karate, being a Sunday School teacher, and bicycling with her husband Jeff and walking with her dogs, Beau and Behr.

PASSChapterLogo.jpg

sql_micro_sm.gif



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