Group Announcements


PASS Modern Migration Tour 2019 - BATON ROUGE Event!

posted May 8, 2019, 3:52 PM by william assaf   [ updated ]

Modern Migration Tour 2019 - BATON ROUGE
PRESENTED BY YOUR Baton Rouge SQL Server User Group!

Baton Rouge is one of the sites for an international SQL Server event by PASS!


Description

With End of support for SQL Server 2008 around the corner (ends in July!), do you have a plan?

What do you need to do to ensure your transition is smooth? What approach do you take? 

Not only will you receive insightful views on migration, you’ll also walk away with an actionable plan for the year ahead.

  • Learn from peers and experts
  • Direct from the engineers at Microsoft and Intel
  • Have fun, get cool swag

Speakers:
Thomas Leblanc
William Assaf 


Click to Register Here


Date And Time

Wed, 12 June 2019

3:00 PM – 5:00 PM CDT

Add to Calendar


Louisiana Technology Park

7117 Florida Blvd

Baton Rouge, LA 70806

View Map

The PASS Migration Event will be followed by our regular user group meeting.



June 2019 SQL Server User Group meeting

When: Wednesday, 06/12/2019

Agenda:
• 5:30 - 5:45: Introduction/Food and Drinks <-- Note our earlier start time!
• 5:45 - 7:30: Presentations
• 7:30 - Until: Open forum for questions

Location: Louisiana Technology Parklocation info here


Speaker Info: Thomas Leblanc

Main Topic: TBD



May 2019 SQL Server User Group meeting

posted May 3, 2019, 6:23 AM by John Wells   [ updated May 16, 2019, 4:55 PM by BRSSUG SQLPass BatonRouge ]

When: Wednesday, 05/08/2019

Agenda:
• 5:30 - 5:45: Introduction/Food and Drinks <-- Note our earlier start time!
• 5:45 - 7:30: Presentations
• 7:30 - Until: Open forum for questions

Location: Louisiana Technology Parklocation info here


Main Presentation:

Fundamentals That Will Improve Your Query Performance! - John Wells

Time and time again the same misunderstandings by developers and query writers appear when query performance issues arise. In this demo heavy presentation, we will review these specific topics such as data types, implicit conversions, sargability, and some others that all have an impact on query performance. Come join me and by the end of this session you will have the knowledge to boost your query performance!

Lightning Talk:

Introduction to Cosmos DB - Brandon Brockhoeft

Presenters:

John Wells is a DBA at Lamar Advertising in Baton Rouge. He is a member of the Baton Rouge User Groups Board and helps out for the ONLY SQLSaturday that serves Jambalaya for lunch! John is known to some as "Mr. SQL Saturday" because he attends so many and started speaking last year.

Brandon Brockhoeft is a career software engineer working primarily with Microsoft solutions with over 15 years of professional experience. He is an LSU alumnus and native of the Baton Rouge area. Brandon is employed as a Principal Consultant for Austin-based Headspring custom software consultancy. He has provided development and architecture technology solutions in the finance, state government, energy, and aerospace industries.

 

Our Sponsor this month is TekChix

April 2019 SQL Server User Group meeting

posted Apr 7, 2019, 8:51 PM by william assaf



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!

March 2019 SQL Server User Group meeting

posted Apr 7, 2019, 8:51 PM by william assaf


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

posted Jan 26, 2019, 7:49 PM by BRSSUG SQLPass BatonRouge   [ updated Jan 26, 2019, 8:07 PM ]

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/

January SQL Server User Group meeting

posted Jan 9, 2019, 6:20 AM by william assaf   [ updated Jan 9, 2019, 6:22 AM ]


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.


November 2018 BRSSUG at Alliance Safety Council - Speaker Idol!

posted Nov 13, 2018, 9:23 AM by william assaf

Join us Wednesday, 11/14/2018 at the Alliance Safety Council for this month's user group! This month will be out speaker idol where we'll have 5 short form presentations by local speakers plus a demo presentation by this month's sponsor Quest Software!  

Speaker idol generally tends to be one of our more entertaining meetings of the year.  Come get a few nuggets of knowledge and get your final geek-friend fix before your holidays gets into full swing, as we won't be meeting again until January!

Agenda:

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

• 6:15 - 7:30: Presentations

• 7:30 - Until: Open forum for questions

Contestant Topics:

  • Theming Bootstrap
  • Intro to Extended Events
  • Embedded PowerBI: What Good is Data if Nobody Sees it?
  • The Option Pattern: A pattern for eliminiating bugs like null-pointer exceptions, unhandled exceptions, and race conditions
  • The Vim text editor

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!

This month's meeting is brought to you by Quest Software!

 See you there!

October 2018 Meeting

posted Sep 24, 2018, 2:02 PM by Andy Parkerson

Wednesday, October 10, 2018
5:45 PM

Location: Louisiana Tech Park - Location Information

Agenda:

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

• 6:15 - 7:30: Presentations

• 7:30 - Until: Open forum for questions


Main Presentation:

Advanced DAX - Mitchell Pearson

The data analysis expression (DAX) language is easy, most Power BI users learn DAX in days, if not hours! From there the analytical value of data models can be significantly improved with minimal effort by using simple DAX calculations. Eventually, every power bi user comes to the realization that there is much more to the DAX language than they could have ever imagined. 

Unfortunately, the gap between the basics of DAX and advanced applications of DAX is quite wide. In this session, you will start building the knowledge necessary to “bridge” that gap so that you can author, with confidence, DAX solutions that solve complex business problems.


Lightning Round:

Intro to Extended Events - John Wells

It's time to go all in on Extended Events! In this quick demo, I will go over Extended Events, show you how easy they are to set up and my favorite Event that makes capturing code simple! 


Bios:

Mitchell Pearson is a Business Intelligence Consultant and the Training Content manager for Pragmatic Works. Mitchell has experience developing enterprise level BI Solutions using the full suite of products offered by Microsoft (SSRS, SSIS, SSAS, & Power BI). Mitchell is very active in the community presenting at SQL Saturday events, PASS virtual chapters, the Power BI World Tour and giving free webinars for Pragmatic Works. Mitchell can also be found blogging at mitchellpearson.com.

Originally from Southern California, John Wells is enjoying the slower pace here in Louisiana. He continues his journey with PowerShell and Performance Tuning. If he is not at a SQLSaturday event or a LSU game, he is grilling something or killing some crawfish! Actually he smokes more than he grills, but when he says this people look at him funny.

September '18 BRSSUG + BRPBIUG Meeting

posted Sep 10, 2018, 10:18 AM by Andy Parkerson   [ updated Sep 10, 2018, 10:19 AM ]

Wednesday, September 12, 2018
5:45 PM

Alliance Safety Council
10099 N Reiger Rd
Baton Rouge, la 70809 

Agenda:

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

• 6:15 - 7:30: Presentations

• 7:30 - Until: Open forum for questions


This week we will be doing BBQ for dinner so please RSVP so that we get an accurate head count!


Main Presentations:

Building Component Based UIs with Asp.Net Core Razor Page - Bryan McCoy

Asp.Net Razor pages are the newest aspect of the Asp.Net toolbox. In this talk we will go over some of the basic features of Razor Pages as well as how to design and build components and component based UIs.


Introduction to PowerApps - Devin Knight

In this session, you’ll learn how to create your first application using PowerApp. PowerApps is part of the Power Platform from Microsoft and provides a business-friendly way of creating applications quickly that can integrate with the Microsoft Power BI and Flow platforms for visualizing and moving data. This technology is one of the hottest new offerings from Microsoft and included in your Office 365 subscription.


Lightning Round:

TBA


Bios:

Bryan McCoy is a Software Developer who primarily focuses on the web side of things. He has worked for the City of Baton Rouge, various consulting companies both locally and in Chicago, and now works for BCBSLA. By day he focuses on the Microsoft stack, but by night he loves all things Linux. He spends most of his time programming in C# and/or Javascript with frameworks such as Asp.Net Core, AngularJs, and React.

Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. He is an author of seven SQL Server and Business Intelligence books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG).

SQLSaturday Baton Rouge 2018!

posted Jul 23, 2018, 11:07 AM by william assaf   [ updated Jul 23, 2018, 11:08 AM ]

Free training day for SQL Server, PowerBI, .NET and more 

SQLSaturday is a global event to bring Information Technology speakers and professionals together for a community-driven, community-attended free day of technical training. The Baton Rouge SQLSaturday event is sponsored by the Baton Rouge SQL Server and .NET User Groups, and will be our annual event on campus at LSU. We expect 600+ regional IT professionals and national speakers to join us. This free conference is open to the public and is perfect for students, CIO's, database administrators, developers, IT managers, server admins and job-seekers. 



What
An all day FREE training event with SQL Server, Development and SharePoint related sessions spread out over multiple tracks of Business Intelligence, Database Administration, SQL Development, SharePoint, IT Pro and .NET development. 

When:

Saturday, August 11, 2018. Registration is now open, but it is filling up fast so reserve your spot now. Attendee check-in will begin at 8:00 AM first sessions beginning at 9:15 AM. 

You MUST print your SpeedPASS and bring it with you! We will NOT be providing blank raffle tickets this year. If you do not print and bring your SpeedPASS, you will not be able to register for the Raffle!

1-10 of 113