Group Announcements


March '17 Baton Rouge SQL Server User Group

posted Mar 1, 2017, 7:11 PM by BRSSUG SQLPass BatonRouge

Our next meeting will be March 8, 2017 at the Louisiana Technology Park.


The meeting will begin around 6pm, sponsor TBD!

Main Topic: Azure SQL Database for the Production DBA 

Summary: Have you been wondering what Azure SQL Database is and what it means for you as a production DBA? Azure SQL Database has become an Enterprise-worthy database platform that provides relational database-as-a-service. In this session you’ll get a grounding in the fundamentals of Azure SQL Database from a DBA perspective. First we’ll cover how to create an Azure SQL Database using the Azure Portal and an approach for sizing a new Azure SQL Database. Then we’ll cover some of the similarities and differences between on premises SQL Server and Azure SQL Database. Finally, we will cover how monitoring and performance tuning Azure SQL Database differs from on premises SQL Server. If you’ve been considering Azure SQL Database for your organization, this session is for you!

Speakers: Tim Radney

Bio: Tim works as a principal consultant at SQLskills.com.  Tim is a SQL Server MVP. and 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.


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!

February '17 Baton Rouge SQL Server User Group

posted Feb 6, 2017, 6:00 PM by BRSSUG SQLPass BatonRouge   [ updated Feb 8, 2017, 1:17 PM by william assaf ]

Our next meeting will be February 8, 2017 at the Louisiana Technology Park.


The meeting will begin around 6pm, sponsored by Prime Occupational Medicine!

 Lightning Topic: Reporting Methods in PowerBI

Speakers: Andy Parkerson

Summary: Andy recently finished writing a comprehensive wiki explaining his business' reporting methods with PowerBI, in this lightning round he'll share some of that information and how they leverage the PowerBI cloud as a “Single Point of Truth”.

 

Main Topic: Fun with Dates and Time In SQL 

Speakers: William Assaf

Summary: William will be presenting some new material he's building a presentation around.  As always it'll  probably be amazing so come out, be surprised and enjoy his engaging presentation style.


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!

January '17 SQL Server User Group Meeting

posted Jan 9, 2017, 11:28 AM by william assaf   [ updated Jan 9, 2017, 11:28 AM ]

Welcome back everyone! Our next meeting will be January 11, 2017 at the Louisiana Technology Park.


The meeting will begin around 6pm, sponsored by Baton Rouge User Groups!

 Lightning Topic: New Year's Resolutions

Speakers: Matthew Tessier, William Assaf, Jimmy Alt

Summary: In December, we sent out a survey to get some feedback on what you guys would like plan to do new/better in 2017.  Matthew, William, and Jimmy will discuss some of the feedback as a whole before breaking off into our individual groups.

 

Main Topic: SQL Server User Group Resolutions

Speakers: Group Discussion

Summary: Continuing on the Lightning Round, we’ll have our own roundtable on 2017 resolutions/goals.  Bring ideas on your personal goals and we can discuss as a group how we can help facilitate/support some of these goals.  We will also talk about goals in the group as a whole so bring any ideas you’d like to discuss the group undertaking. Matthew will share a 15 minute or so account reinforcing one of his resolutions for the year as well!



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!

See you in January 2017!

posted Nov 10, 2016, 1:52 PM by BRSSUG SQLPass BatonRouge

No meeting scheduled in December 2016, see you 2nd Wednesday of January 2017!

November '16 BRSSUG Meeting

posted Nov 7, 2016, 8:13 AM by BRSSUG SQLPass BatonRouge   [ updated Nov 9, 2016, 11:27 AM by william assaf ]

Date: Wednesday, November 9, 2016

Location: The Louisiana Technology Park - http://www.brssug.org/where

 

Sponsor: CGI Federal

 

Agenda:

5:45 - 6:15 pm: Networking and Dinner with the other user groups

6:15 - 6:30 pm: Announcements, Sponsor Message, and Lightning Talks

6:30 - 7:00 pm: User Group business and Officer Elections

7:00 - 8:00 pm: Speakers

8:00 - 8:30 pm: Raffle and Giveaways

This will be a joint meeting with the Baton Rouge Power BI User Group (BRPBIUG)

 

Main Topic: Optimizing Backup and Restore Performance in SQL Server           

Speakers: Robert Canzonire, BCBS LA

Summary: Discuss and Demonstrate how Robert was able to take a backup averaging 279 minutes to complete down to 34 minutes by using several options.  Robert will also be discussing several different backup types and how to use them to minimize recovery times.

October '16 BRSSUG Meeting

posted Oct 10, 2016, 8:27 AM by BRSSUG SQLPass BatonRouge   [ updated Oct 10, 2016, 8:27 AM ]


Date: Wednesday, October 12, 2016

Location: The Louisiana Technology Park - http://www.brssug.org/where

 

Sponsor: SHI

 

Agenda:

5:45 - 6:15 pm: Networking and Dinner with the other user groups

6:15 - 6:30 pm: Announcements, Sponsor Message, and Lightning Talks

6:30 - 7:00 pm: User Group business and Officer Elections

7:00 - 8:00 pm: Speakers

8:00 - 8:30 pm: Raffle and Giveaways

This will be a joint meeting with the Baton Rouge Power BI User Group (BRPBIUG)


Topic: PowerBI Dashboards 

Speakers: Trey Cook and Ryan Varisco,  Sr Business Intelligence Consultants from Sparkhound

Summary: The secret to running a successful analytics program is knowing *which* projects to tackle, and how to use those analytics to improve your company’s overall performance.  We'll review how SQL Server and Power BI technologies can play a role in the architecture of Enterprise Performance Management.



Topic: Azure SQL Database Authentication and Security

Speakers: William Assaf, Principal Consultant, SQL, Sparkhound

Summary: This will be a review of your need-to-know information for authentication and security in Azure SQL Database.



 Important Announcement!

Registering for the PASS Summit in October? Use this code for a discount!  LC15BGL5

September '16 BRSSUG Meeting

posted Sep 7, 2016, 7:24 PM by BRSSUG SQLPass BatonRouge   [ updated Sep 13, 2016, 6:48 AM ]

Date: Wednesday, September 14, 2016

Location: The Louisiana Technology Park - http://www.brssug.org/where

 

Sponsor: Devart (giving away free licenses!)

 

Agenda:

5:45 - 6:15 pm: Networking and Dinner with the other user groups

6:15 - 6:30 pm: Announcements, Sponsor Message, and Lightning Talks

6:30 - 7:00 pm: User Group business

7:00 - 8:00 pm: Main Topic Speaker

8:00 - 8:30 pm: Raffle and Giveaways

This will be a joint meeting with the Baton Rouge Power BI User Group (BRPBIUG)


Topic: Welcome to the DBA Escape Room.

This month we will be doing an escape room challenge. Unlike most escape rooms we will not be physically prevented from leaving, but as DBAs we know that the effect is the same when a data is at risk. You are not going home until the database is fixed (or if you do, print out a bunch of resume before you go).  We will be working through two of the corruption challenges put forth by Steve Stedman at  

http://stevestedman.com/server-health/database-corruption-challenge/

In the Week 1 Database corruption challenge we will be recovering a database that has become corrupt. All we have to work with is a single backup of the corrupt databases. The conventional wisdom is that when DBCC reports corruption, the solution is to restore from the last good backup. But as you know, that often is not an acceptable solution. So how can we get back all of our data from somewhere in a corrupted database?

In the Week 3 Database corruption challenge we will be recovering a database where the .mdf file has been lost. All we have are the last full backup, 3 transaction log backups and the .trn file that was recovered.

A few of us will have laptops with the challenge files and a SQL2014 Server, and all of the challenge files on a thumb drive in case we want to split into teams and solve in parallel or as a competition. Matthew Tessier will be leading this adventure.

 Important Announcement!

Registering for the PASS Summit in October? Use this code for a discount!  LC15BGL5

SQLSaturday Baton Rouge 2016!

posted Jul 14, 2016, 7:52 AM by william assaf   [ updated Aug 3, 2016, 2:34 PM by BRSSUG SQLPass BatonRouge ]

Free SQL Server, SharePoint and .NET training

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. 


Then...


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. 


Who Attends SQLSaturday? 

Folks with the following skillsets are drawn to SQL Saturday Baton Rouge because of the professional networking, free training, and giveaways:

  • SQL Server Administrators
  • Business Intelligence Developers
  • Data Analysts
  • ETL Developers
  • C#/VB.NET Developers
  • Mobile Developers
  • Windows Server Admins
  • SharePoint Architects
  • SharePoint Developers
  • Network Administrators
  • Quality Assurance Analysts
  • IT Managers
  • Students
  • Project Managers
  • Hiring Managers
  • Jobseekers of all levels of experience
  • Students
  • CIO's
  • CEO's

At the end of 2015, we polled our user group membership and got this amazing feedback on SQLSaturday Baton Rouge #423 in August of 2015:

 

  • "As a former speaker and attendee at Sql Saturday, I must say you guys knock the ball out of the park with SQL Saturday. You guys put on a top notch event for both presenters and attendees."
  • "SQL Saturday is always top-notch!"
  • "SQL Saturday is always on point. Love this event and always promote it to other groups."
  • "I am happy that the talks are open to more topics than just .Net and MSSQL"


When:

Saturday, August 6, 2016. Online 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. 


Registering for the PASS Summit in October? Use our user group code for a $150 discount!  LC15BGL5

Baton Rouge User Groups Networking Night 2016 - July 13!

posted Jul 12, 2016, 1:46 PM by BRSSUG SQLPass BatonRouge

What is Networking Night?

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, evangelism, etc.  

Sign up to speak at the event here! Speaker lineup is FULL!

Who should attend? Everyone should attend free Networking Night! In 2014 and 2015, 80+ IT professionals including many newcomers attended this fun event! 
  • Looking for a job? Meet and greet, bring your resume
  • Hiring? Introduce yourself to folks in your needed the field 
  • Current Student? Talk to your future colleagues and managers
  • Happy at your job? Share your experience and contribute to discussion
Instead of a regular user group meeting, Networking Night is open to everyone in the Baton Rouge IT community, for free! 

Date: Wednesday, July 13, 2016
Location: The Louisiana Technology Park - http://www.brssug.org/where

Agenda:
5:45 - 6:15 pm: Networking and Dinner
6:15 - 6:30 pm: Announcements
6:45 - 8:00 pm: Networking Nights Speakers
8:00 - 8:30 pm: Raffle and Giveaways

#SQLVacation Visits BRSSUG!

posted Jul 1, 2016, 8:19 AM by BRSSUG SQLPass BatonRouge   [ updated Jul 1, 2016, 8:19 AM ]

Date: Monday, July 11, 2016
Location: The Louisiana Technology Park - http://www.brssug.org/where

Agenda:
5:45 - 6:15 pm: Networking and Dinner 
6:15 - 6:30 pm: Announcements
6:45 - 8:00 pm: Kevin Kline
8:00 - 8:30 pm: Swag and more networking

Back by popular demand: SQL Vacation 2016 (http://info.sqlsentry.com/sql-vacation)! This time, Kevin Kline and family are traveling down South and making their way to seven different SQL Server user groups. Join in the fun on social media with #SQLVacation or by following @kekline.  

MAIN Topic: End-to-End Troubleshooting for SQL Server 

Abstract: Learning how to detect, diagnose and resolve performance problems in SQL Server is tough.  Often, years are spent learning how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.  

In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including:

XEvents, Profiler/Traces, and PerfMon 
Using Dynamic Management Views (DMVs)
Advanced Diagnostics Using Wait Stats
Reading SQL Server execution plan 

Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it.



1-10 of 85