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.
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
- Project Managers
- Hiring Managers
- Jobseekers of all levels of experience
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"
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.
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
Complete sponsorship information available soon. Register as a sponsor here.
SQLSatBR pre-cons for 2016, both held on August 5, 2016:
Tim Mitchell: "Building Better SSIS Packages"
MidnightDBA: The Enterprise Scripting Workshop
This year we will only be hosting 2 pre-cons due to space limitations, but they are both great content!
Title: Building Better SSIS Packages
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:
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:
This course is designed for the beginner- to intermediate-level SSIS developer.
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
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.
Title: The Enterprise Scripting Workshop
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.
- 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.
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.
- Introducing your enterprise
- Enterprise philosophy
- The ideal SQL shop
- Elements of enterprise scripts
- T-SQL and regular expressions
- Developing the Script
- Applying RegEx
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.
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.
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!
Two hotel deals for speakers and attendees!
Lod Cook Hotel on LSU campus, Use code 160806SPAR
Hotel Indigo Downtown Baton Rouge near Speaker Banquet, use IATA# 99801505 and Group Code SQL
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.
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.