posted Nov 3, 2019, 8:05 PM by BRSSUG SQLPass BatonRouge
[
updated Nov 8, 2019, 8:43 AM by william assaf
]
posted Oct 9, 2019, 5:15 PM by william assaf
When: Wednesday, 11/13/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 Park- location info here
Sponsor: Quest
Main Presentation: What's New In SQLServer 2019
Main Speaker: William Assaf, Sparkhound William Assaf, MCSE, is a principal consultant and DBA Manager in Baton Rouge, LA.
Initially a .NET developer, and later into database administration and architecture,
William currently works with clients on SQL Server and Azure SQL platform optimization,
management, disaster recovery and high availability, and manages a crack multi-city
team of SQL DBA's at Sparkhound. William has written for Microsoft SQL Certification
exams since 2011 and was the lead author of "SQL Server 2017 Administration Inside Out"
by Microsoft Press, its second edition due out in 2019. William is a member of the
Baton Rouge User Groups Board, a regional mentor for PASS, and head of the annual
SQLSaturday Baton Rouge Planning Committee. |
|
|
posted Oct 9, 2019, 3:15 PM by william assaf
When: Wednesday, 10/9/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 Park- location info here
Main Presentation: How to index, win friends, and influence people. In this session, we'll discuss performance benefits of indexes and compare index types. If you're new to indexes in SQL Server or just in need of a refresher, this session should help.
Main Speaker: Jonathan Jefferson, BCBS Jonathan Jefferson is a SQL enthusiast and amateur DBA on occasion. I'm currently working to remove the amateur part. |
|
posted Sep 12, 2019, 7:39 AM by william assaf
[
updated Sep 24, 2019, 1:26 PM
]
When: Wednesday, 09/11/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 Park- location info here
Main Presentation: SQL Security Principals and Permissions 101 A ground-floor introduction to SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and much more. This session is perfect for junior DBAs, developers and system admins of on-prem and Azure-based SQL platforms. Main Speaker: William Assaf William Assaf, MCSE, is a principal consultant and DBA Manager in Baton Rouge, LA. Initially a .NET developer, and later into database administration and architecture, William currently works with clients on SQL Server and Azure SQL platform optimization, management, disaster recovery and high availability, and manages a crack multi-city team of SQL DBA's at Sparkhound. William has written for Microsoft SQL Certification exams since 2011 and was the lead author of "SQL Server 2017 Administration Inside Out" by Microsoft Press, its second edition due out in 2019. William is a member of the Baton Rouge User Groups Board, a regional mentor for PASS, and former of the annual SQLSaturday Baton Rouge Planning Committee.
|
|
posted Jul 18, 2019, 10:58 AM by william assaf
[
updated Aug 15, 2019, 2:43 PM
]
SQLSATURDAYFree training day for SQL Server, PowerBI, .NET, SharePoint 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.
REGISTER HERE and VOLUNTEER HEREWhen: Saturday, August 17, 2019. 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!But wait, there's more!
SQLSATURDAY PRE-CONS on FRIDAY
Kubernetes: Zero to Hero with Anthony NocentinoModern application deployment needs to be fast and consistent to keep up with business objectives and Kubernetes is quickly becoming the standard for deploying container-based applications, fast. In this day-long session, we will start with an architectural overview of a Kubernetes cluster and how it manages application state. Then we will learn how to build a production-ready cluster. With our cluster up and running, we will learn how to interact with our cluster, common administrative tasks, then wrap up with how to deploy applications and SQL Server. At the end of the session, you will know how to set up a Kubernetes cluster, manage a cluster, deploy applications and databases, and how to keep everything up and running.Register here: https://www.eventbrite.com/e/kubernetes-zero-to-hero-by-anthony-nocentino-tickets-61845012096SQLSATURDAY KID'S STEM TRACK
For the second year, we have partnered with STEMupBR for an all-day STEM educational track for parents who are registered for SQLSaturday. PREREGISTRATION is REQUIRED and there is a small fee for the STEMupBR track for 4th-8th grade kids. Registration link: http://bit.ly/SQLYouth SOLD OUT!! |
posted Jun 13, 2019, 9:55 AM by william assaf
What is Networking Night?Instead of a regular user group meeting, Networking Night is open to everyone in the Baton Rouge IT community, for free! Many professional organizations have an annual meeting dedicated to career development and professional networking. Networking Night is a special User Group format where we will have several short-format talks, networking and career development, and an opportunity for Baton Rouge SQL Saturday sponsors to have an official presence to do recruiting, tech talks, career development, etc.
Who should attend? Everyone should attend free Networking Night! Starting in 2014, each year 50+ IT professionals including many newcomers attended this fun event! Looking for a job? Meet and greet, bring your resumeHiring? Introduce yourself to folks in your needed the field Current Student? Talk to your future colleagues and managersHappy at your job? Share your experience and wisdom and contribute to discussion
SQLSatBR SPONSORS:
Date: Wednesday, July 10, 2019Location: The Louisiana Technology Park - http://www.brssug.org/where
Agenda:5:00 - 5:30 pm: Networking and Dinner5:30 - 5:45 pm: Announcements5:45 - 7:00 pm: Networking Nights Speakers
|
posted May 8, 2019, 3:52 PM by william assaf
[
updated May 30, 2019, 11:16 AM by John Wells
]
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!
DescriptionWith 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 TimeWed, 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 meetingWhen: 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 Park- location info here
Main Presentation: Execution Plans in SQL Server 2017 After our Modern
Migration Tour special event at 3pm (see below!) stay for more SQL Server
insights! Performance Tuning starts with looking at a plan SQL Server
internally uses to execute T-SQL. There are many parts to the plan as well as
additional options for performance tuning. This session will provide real-world
examples of T-SQL that can cause execution plans to not be optimal. The plan
might also expose additions in the form of new indexes that can be added to
improve performance. There are many paths to reading these plans that need to
be discussed and probably you will hear 'it depends' in this session.
Explanations of why it depends will be used with examples. Plus a look at Query
Store in 2017. Main Speaker: Thomas LeBlanc
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data
Warehouse Architect in Baton Rouge, and uses his 30+ years in IT to develop
OLTP systems with normalized databases for high-performing T-SQL and
dimensional data marts. Development is done in SSIS, SSAS, SSRS, Power BI, and
Excel. As a PASS volunteer, he is past chair of Excel BI and Data Arch VCs and
is active in the Baton Rouge Analytics and SQL Server User groups as well as SQLSaturday
in Baton Rouge. Blog - TheSmilingDBA.BlogSpot.com and Thomas-LeBlanc.com
|
|
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 Park- location 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 |
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
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
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 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/
|
|
|
SQL Security Principals and Permissions 101.pptx
QueryPerformance Fundamentals.zip
