March 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.



  • February SQL Server User Group meeting
    When: Wednesday, 02/13/2019

    Agenda:

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

    • 6:15 - 7:30: Presentations

    • 7:30 - Until: Open forum for questions

    Location: Alliance Safety Council

    Main Presentation:

    Performance Optimization with Azure SQL Database

    The cloud is just using someone else's compute. You still need to care about and optimize for performance.  Just as a dropped call frustrates cellular customers, an app with data issues, high latency, connection timeouts will create the same frustration for users.  Do you want to catch the performance issues before your customers?  Do you want to automatically identify database issues and quickly drill down into details? Azure provides built in tools just to do that. 
    In this session I will show you 4 of those tools.  You will learn how these tools can provide Performance overview of a database and recommendations that can improve workload performance.  Find top resource consuming queries, deeper insight into your databases resource (DTU) consumption and learn when to let Azure  automatically optimize your database. 
     
    At the end of this session you will walk out knowing how to identify and tune Azure SQL database performance  issues with built in tools in Azure Portal.


    Main Speaker: Taiob Ali

    Taiob Ali, an accomplished technical leader with proven record of success. He has spent the last 13 years working with SQL Server and MongoDB platform both on premise and cloud. His experience includes three major business sectors: financial industry, e-commerce and healthcare. Taiob has hands on experience in managing large database projects including large data migration, complex process design, testing and deployment, performance tuning, long term capacity planning.

    Taiob is currently working at “GMO LLC” as lead DBA. Focusing on automation, improving and streamlining operational workflow, plan and prepare for cloud migration. He is a regular speaker at local and virtual PASS chapters, SQL Saturdays and Azure conferences. This month's meeting is brought to you by Vinformatix - http://www.vinformatix.com/
    Posted Jan 26, 2019, 8:07 PM by BRSSUG SQLPass BatonRouge
  • January SQL Server User Group meeting

    When: Wednesday, 01/09/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:

    Common SQL Server Mistakes and How to Avoid Them

    Making mistakes is natural, but learning from them and avoiding them in future takes effort. There's no substitute for experience or the shared wisdom of others to help you learn what mistakes to avoid. In this session, Tim will share with you a ton of what he's learned over the years from working and consulting at multiple Fortune-level companies. You'll hear about real-world environments he has worked on where there was a high impact from administrators making mistakes in how SQL Server was configured and administered. You'll learn many proven and accepted best practices for installing, configuring and supporting SQL Server to help your environment run as smoothly as possible and you'll leave with a checklist of items to take home to make sure your SQL Server environment is configured properly.

    Main Speaker: Tim Radney, SQLskills.com - Principal Consultant

    Tim is a SQL Server MVP. He has presented at PASS, SQLintersection, SQL Saturdays, user groups and numerous webinars. In addition, Tim runs the Columbus GA SQL Users Group, is a PASS Regional Mentor and was named a PASS Outstanding Volunteer in 2012. He’s married with three children and has a passion for electronics. He also farms chickens (for eggs), dwarf Nigerian goats, and tilapias in his spare time.


    Posted Jan 9, 2019, 6:22 AM by william assaf
Showing posts 1 - 2 of 109. 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