SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This event will be held on Aug 06 2016 at LSU College of Business - Business Education Complex, Nicholson Drive Ext, Baton Rouge, Louisiana, 70803, United States

  Register Now!

Welcome to SQLSaturday Baton Rouge 2016!

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. 


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. A full list of session tracks and schedule is available.

Where:

Our event will be hosted at the new LSU College of Business building, next door to our previous location on LSU Campus.  LSU's new gem of a building gives us up to 17 classrooms, a large atrium and a 300-seat auditorium for our keynote and prize giveaways! 

Louisiana State University
Business Education Complex
Nicholson Drive Extension
Baton Rouge, La. 70803


Sponsorship Info:

Complete sponsorship information available soon. Register as a sponsor here.


Pre-Con Info:

SQLSatBR pre-cons for 2016, both held on August 5, 2016:

Tim Mitchell: "Building Better SSIS Packages"
http://www.eventbrite.com/e/building-better-ssis-packages-sql-sat-baton-rouge-tickets-24225615468

MidnightDBA: The Enterprise Scripting Workshop
https://www.eventbrite.com/e/the-enterprise-scripting-workshop-a-sql-saturday-baton-rouge-precon-tickets-21308317752




This year we will only be hosting 2 pre-cons due to space limitations, but they are both great content!

Precon #1

Title: Building Better SSIS Packages

Abstract:

Building packages in SQL Server Integration Services is easy. Building good packages takes a bit more effort.

SQL Server Integration Services is deceptively easy to use. With a few hours of instruction or self-study, most data professionals can throw together an SSIS package. However, creating a process that simply runs successfully isn’t the endgame; enterprise-class ETL demands a higher standard. Specifically, well-designed packages will be:

  • Reliable

  • Resilient

  • Reusable

  • Maintainable

  • Well performing

There’s nothing magical about building rock-solid SSIS packages, but it does take some discipline, experience, and a library of best practices. That is exactly the aim of this course: to demonstrate a set of proven practices that help frame the development of enterprise-ready SSIS packages.

In this full-day presentation, we will walk through each of these five facets of well-built packages, discussing and then demonstrating ways of applying these practices to design better SSIS packages. Among the topics for the day:

  • Checking for problems even when the package executes successfully

  • Building effective tests for your packages

  • Error handling and prevention

  • Being kind to your fellow developers by building  clear and easy-to-maintain packages

  • Leave a trail of evidence: package logging done properly

  • Avoiding performance bottlenecks: tips for making packages run faster

  • Using the right tool for the job by integrating non-SSIS tools when appropriate

This course is designed for the beginner- to intermediate-level SSIS developer.

 

Bio:

Tim Mitchell is a business intelligence consultant, author, and trainer.  He has worked with SQL Server for over a decade, specializing in business intelligence, ETL/SSIS, data quality, and reporting.  He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is recognized as aMicrosoft Data Platform MVP.  Tim is an independent business intelligence consultant and a partner with Linchpin People, and is the principal at Tyleris Data Solutions.

Register: 

http://sqlsatbr2016-ssis.eventbrite.com/


Precon #2

Title: The Enterprise Scripting Workshop

Abstract:

The DBA life is frustrating: you rarely have time to innovate, because the same tasks fill up your time day after day. Your users are unhappy about how long it takes to resolve “simple” tickets. You have to put big items on hold because special requests come in. As careful you are, mistakes creep in as you get busier.

We’ve been there.

In this workshop, the MidnightDBAs show you how to develop enterprise scripts with a huge range of uses. A good set of reusable scripts will reduce task time from hours – or even days – to just a few minutes, and eliminate mistakes from your environment.

You’ll learn:

  • Enterprise philosophy – tackle simple tasks with the whole environment in mind
  • Single data store – define the benefits and uses of a single central database for common-use data and metadata
  • Choice of tools – choose the best tool (Powershell, T-SQL, SSIS, or other) for the job
  • Environment ground work – prepare your environment for enterprise scripting
  • Real world scripts – work through dozens of enterprise scripting issues (like alerting, error handling, multiple SQL versions, and more) as we develop a real enterprise script in class

This session is for database administrators, with a basic understanding of Powershell. It’s for anyone who touches backups or security, maintains databases, troubleshoots performance, monitors disk space, or any of a hundred other DBA tasks. Enterprise scripting is for anyone who has more tasks than time.

Agenda

The morning will be spent largely in discussion and lecture, so the attendee has solid scripting principles to build upon. The afternoon session will be spent largely in actual enterprise script development.

  • Morning
    • Introducing your enterprise
    • Enterprise philosophy
    • The ideal SQL shop
    • Elements of enterprise scripts
  • Afternoon:
    • T-SQL and regular expressions
    • Developing the Script
    • Applying RegEx

Bio:

Sean McCown

Sean McCown is a Certified Master in SQL Server 2008 and a SQL Server MVP with 20 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos and co-hosts the popular web show DBAs@Midnight.

Jennifer McCown

Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in NTSSUG, PASS, and the PASS Women in Technology virtual chapter. 


Register: https://www.eventbrite.com/e/the-enterprise-scripting-workshop-a-sql-saturday-baton-rouge-precon-tickets-21308317752

Volunteer Info:

If you're interested in helping put on this great event, register for the event and check the volunteer box. We will be in touch as the event gets closer!


Hotel Info:

Two hotel deals for speakers and attendees!

Lod Cook Hotel on LSU campus, Use code 160806SPAR

-or-

Hotel Indigo Downtown Baton Rouge near Speaker Banquet, use IATA# 99801505 and Group Code SQL


Twitter info:

The event hash tag is #sqlsatbr. 

Follow the official SQL Saturday Baton Rouge twitter account at @SQLSatBR!

The Baton Rouge Chapter of PASS tweets at @BRSSUG

Facebook: Facebook.com/SQLSaturdayBR

 

SQL Saturday #515 is presented by the Baton Rouge Chapter of the Professional Association for SQL Server, the Baton Rouge SQL Server User Group. Also involved are the Baton Rouge .NET User Group, and Baton Rouge IT Pros User Group. The event is brought to you by numerous amazing sponsors.

 

 


 

Event news

  • Wednesday, September 14, 2016 11:57:00 PM

    The official SQLSaturday Baton Rouge 2016 Photo Gallery is here!

    https://goo.gl/photos/D1DNbTs89bEsUcUh6

  • Friday, August 5, 2016 3:28:00 PM

    Registering at the last minute? You don't have to wait for an email!
    Download your SpeedPASS PDF at the mySQLSaturday page:


    Attendee check-in will begin at 8:00 AM
    First sessions beginning at 9:15 AM. 

  • Wednesday, June 15, 2016 9:49:00 AM

    Exciting news!

    GOLD, UNATTENDED and SILVER booth space is officially SOLD OUT! We are at capacity inside the atrium! 

    We still have opportunities for Platinum, Bronze and Blog sponsorships for SQLSaturday Baton Rouge.

    Please contact us if you have any questions or would like to discuss sponsorship options. sqlpassbr@gmail.com

Event Location

Contact the Organizer

Profile Image Send a Quick Message

sqlpassbr@gmail.com sqlpassbr@gmail.com

Click here to view the event XML feed.

SQLSaturday