• April 2019 SQL Server User Group meeting



    When: Wednesday, 04/10/2019

    Agenda:

    • 5:45 - 6:15: Introduction/Food and Drinks

    • 6:15 - 7:30: Presentations

    • 7:30 - Until: Open forum for questions

    Location: Louisiana Tech Park - location info here

    Main Presentation: Replacing Profiler with Extended Events

    Extended Events was released over 10 years ago, with SQL Server 2008, and DBAs and developers alike *still* prefer Profiler. However, if you want to troubleshoot anything related to new features, you have to use Extended Events. If you've tried XE and struggled, or if you've been thinking about it but just aren't sure where to begin, then come to this session. Using your existing knowledge and experience, we bridge the gap between Profiler and Extended Events with demos, starting with the Profiler UI you know and love, and ending with an understanding of how to leverage functionality in the Extended Events UI for data analysis. By the end of this session, you’ll know how to use Extended Events in place of Profiler to continue the tasks you've been doing for years, and you'll have the foundation to better understand how you can leverage Extended Events to troubleshoot other issues in ways not previously possible.

    Main Speaker: Erin Stellato

    Erin Stellato is a SQL Server MVP and lives in Cleveland, OH. She has over 15 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include statistics, performance tuning, Extended Events, and helping accidental/involuntary DBAs figure out 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 like SQLintersection and the PASS Summit. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.

    All of our meetings are open to the public, open to students, folks looking to get into the field and those looking to move up! Please spread the word and come prepared to learn and share your knowledge and experience!

    Posted Apr 7, 2019, 8:51 PM by william assaf
  • March 2019 SQL Server User Group meeting

    When: Wednesday, 03/13/2019

    Agenda:

    • 5:45 - 6:15: Introduction/Food and Drinks

    • 6:15 - 7:30: Presentations

    • 7:30 - Until: Open forum for questions

    Location: Louisiana Tech Park 

    Main Presentation:

    Using Open Source Products to Collecting Performance Metrics

    Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it can handle additional workload? What information would you use to answer these questions? If only you knew what performance metrics to collect and had them for your existing instances to answer these questions.

    In this session, we will discuss sp_whoisactive and Query Store. Then we will be combining three open source tools – Telegraf, InfluxDB, and Grafana – into an inexpensive system that collects performance metrics you can use to troubleshoot issues and answer important questions about your SQL Server instances, including your Linux SQL Server instances. We will learn what metrics to collect, how to use the tools to collect performance metrics and then we’ll put it all together in an interactive dashboard for easy visualization.

    Attendees will see how easy it is to get good performance data and visualize in an interactive way and combine with other tools to troubleshoot issues. For an example, we will combine this solution with Query Store and/or sp_whoisactive to find a problem that occurred on a system and caused me to get my nap interrupted on a Saturday.


    Main Speaker: Tracy Boggiano

    Tracy is a Database Administrator for Broadvine. She has spent over 20 years in IT and has been using SQL Server since 1999 and is currently certified as a MCSE Data Platform. She has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a Special Interest Group for Advanced DBA topics. She also is currently leading bring Linux content into the various virtual PASS groups.

    Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com. Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org.

    Posted Apr 7, 2019, 8:51 PM by william assaf
Showing posts 1 - 2 of 111. View more »
SQLSaturday Baton Rouge Event History

2018 

Aug 11 

#749    

2017 

July 29 

#628    

2016 

Aug 6 

#515

2015

Aug 1 

#423

2014

Aug 2

#324

2013

Aug 3

#234

2012

Aug 4

#150

2011

Aug 6

#64

2010

Aug 14

#28

2009

Aug 1

#17