Group Announcements


May '16 BRSSUG Meeting

posted May 3, 2017, 8:58 AM by BRSSUG SQLPass BatonRouge   [ updated May 3, 2017, 9:00 AM ]

Our next meeting will be May 10, 2017 at the Louisiana Technology Park.

 

IMPORTANT ANNOUCEMENT!  Thinking of registering for the PASS Summit in October? Use this code for a $150 discount!  LC15BGL5

Date: Wednesday, May 10, 2016

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

 

Sponsor: TBA

 

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/Lightning Rounds

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)


 Please also visit our Meetup.com site and RSVP!

 

Main Topic: Introduction to Microsoft Analytics – Turning Data into Intelligent Action

Abstract: Data Science, Azure Machine Learning, and Analytics are all becoming core pieces to the success of every business.  As data professionals we need to know how these will affect what we do, and how we can use it to help our business and clients.  In this session we will take a look at these hot topics and learn how it helps us turn data into intelligence that will lead to actions that drive profits.  We will take a look at how Microsoft’s Cortana suite is the central hub for learning and implementing each of these core pieces.  An easy to follow example showing the flow from Data to Data Intelligence and thru to Action will be presented using Cortana Intelligence Suite.

 

Speaker: Melody Zacharias, Clearsight Solutions

Bio: Melody Zacharias is a Partner at ClearSight Solutions in British Columbia Canada. She is the leader of the Southern Interior Pass (SIP) chapter for the Professional Association of SQL Server (PASS), Regional Mentor for Pass Canada and a Microsoft MVP for the data platform.   Melody has been passionate about SQL Server since version 7.  You can find her on her blog at sqlmelody.blogspot.ca or on Twitter @SQLMelody.


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!


April '17 Baton Rouge SQL Server User Group

posted Mar 29, 2017, 7:14 AM by william assaf   [ updated Mar 31, 2017, 7:51 AM by BRSSUG SQLPass BatonRouge ]

Our next meeting will be April 12, 2017 at the Louisiana Technology Park.


The meeting will begin around 6pm, sponsored by Idera


Please also visit our Meetup.com site and RSVP!


Lightning Round Topic: TRY…CATCH Error Handling in SQL Server 

Abstract: : TRY…CATCH was introduced in SQL 2005 as the standard for error handling in SQL Server. This presentation will review the benefits of using proactive error handling to address both anticipated and unanticipated errors during code execution, along with the ways to utilize TRY…CATCH in standard queries and stored procedures.  

Speaker: Colby Loupe, Sparkhound

Bio: Colby is a Junior Consultant for Sparkhound’s SQL Server division with experience with administration, data integration, and report development. After working as a report writer for her local government, Colby moved to Baton Rouge to pursue a career in Database Administration at Sparkhound. 



Main Topic: You Want Me to Isolate What?

 

Abstract: Isolation Levels in SQL Server can benefit your application and help control data integrity by managing concurrency effects but can also hurt your application if you are unaware of what they are and how they are used. A review of SQL Concurrency issues and how SQL Isolation Levels can help eliminate them and keep the integrity of your data. This presentation will demonstrate with queries what causes concurrency issues and what isolation levels will prevent them.


Speaker: Robert Bishop, Sparkhound


Bio: Robert has been working with databases since SQL Server 2005.  After 4 years as a .NET developer using SQL Server, Robert became a DBA out of necessity, a true "Accidental" DBA!  After 5 years as a DBA for a local hospital, Robert decided to expand his career by becoming a Senior SQL Server Consultant for Sparkhound. Robert has presented at his local SQL Server User group, SQL Saturdays and PASS Virtual Chapters.  As a Microsoft MSCA and an Idera ACE, Robert enjoys administrative tasks, configuring SQL Server for optimal performance, troubleshooting problematic SQL queries and making those query run faster than the speed of light.  In the event of "free time", Robert enjoys camping, playing his guitars and spending time with his family.

 


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 '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

1-10 of 87