SQLSaturday 624

Chattanooga, United States

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 Jun 24 2017 at UT Chattanooga EMC Building, 784 Vine Street, Chattanooga, Tennessee, 37403, United States

Register Now

Welcome to SQLSaturday

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, and most costs are covered by donations and sponsorships. At some events you will have the option to pay for lunch at the time of registration. Please register soon as seating is limited, and let friends and colleagues know about the event.

More Information

Welcome to SQLSaturday #624 Chattanooga

SQLSaturday is a free training event for SQL Server professionals and those wanting to learn about SQL Server. This event will feature sessions in Microsoft SQL Server development, BI, analytics and Big Data and will be held on June 24 2017, in the University of Tennessee at Chattanooga’s Engineering, Math, and Computer Science building, at 784 Vine Street, Chattanooga, Tenn.

Admittance to this event is free, all costs are covered by donations and sponsorships and presented through the volunteer efforts of SQL Professionals of Chattanooga (SPOC) and Professional Association of SQL Server (PASS). Please register soon as seating is limited, and let friends and colleagues know about the event.

We are pleased that the Chattanooga Marriott Downtown has offered a discount to attendees as our Preferred Hotel. To book your stay, click here.

Pre-Conference Session, June 23, 8:30AM-5:00PM

Building Scalable, Robust Solutions in SQL PowerShell-  Aaron Nelson

Data is growing faster than ever, and Data Professionals are being asked to do more with less. As your responsibilities scale up, you need to make sure your scripts scale with them. As Microsoft’s official PowerShell module gets updated, the best practices change too. In this precon, we’ll show you how to write large-scale scripts that take advantage of the latest tools.

First, I’ll give you a lay of the land, showing you the basics and what’s new in PowerShell for SQL. With 90+ cmdlets and more every couple of months, you’ve probably missed some of the cool, new functionality. Then you’ll be ready to jump into some large-scale demos.

Next, we’ll dig deeper and look at techniques for building scripts that works at scale. For example, a ForEach-Object loop is like counting on your fingers. It's great for a few objects, but starts to fall apart when you have to manage dozens of instances or hundreds of databases.  Growing to enterprise scale requires different techniques and different features.

By the end of the day, you will know how to use many of the new capabilities in SQL PowerShell and how to scale them across every instance of SQL Server in your environment.  You’ll know best practices, and how to choose the best performing options to build scalable, robust solutions in PowerShell.

All attendees will receive all of the code that is demoed, as well as handouts about the language and how to get things done.

Aaron Nelson ( blog | twitter ) is a Microsoft MVP for SQL Server (Data Platform) and leads the PowerShell Virtual Chapters of PASS, and volunteers for the local PASS Chapter AtlantaMDF, and helps organize SQL Saturday events in Atlanta.

30+

 

 

 New SQL PowerShell cmdlets have already been delivered and more are on their way every month. 2016 has unleashed a new era in what can be done with data by leveraging PowerShell.

PowerShell is for every Data Professional and this session is built from my own experience as a DBA, Database Developer, and now B/I Developer.

The day will start with a primer on the basics of PowerShell and it’s eco system.

You will learn things like how to work with data, import it into SQL Server extremely quickly, back up your database schema, compare that schema with another database.

We will go through techniques to scale your scripts across multiple instances as well as how to store the results where you want.

Even if you’re not a not a B/I Developer you may have needed to deploy an SSRS report or two, you will learn easy ways to leverage PowerShell to deploy lots of reports to lots of machines.

While we’re at it, we’ll go through new features the community has asked Microsoft build for SQL PowerShell, how you can add your voice to that conversation, and how to build something to get around an issue until Microsoft gets around to building their own solution.

Finally, we will go through error handling and other things to make your scripts more durable.

All attendees will receive all of the code that is demoed, as well as handouts about the language and how to get things done.

Learning Objectives

Show how to deploy database change faster & more consistently

Show how to easily gather environment & performance information

Show how to simplify common ETL & Reporting tasks data professionals are frequently asked to handle.

 

Aaron Nelson ( blog | twitter ) is a Microsoft MVP for SQL Server (Data Platform) and leads the PowerShell Virtual Chapters of PASS, and volunteers for the local PASS Chapter AtlantaMDF, and helps organize SQL Saturday events in Atlanta.

The PowerShell VC of PASS hosts monthly sessions on SQL Server + PowerShell and you can find the recordings of those sessions on their YouTube channel.

Last year, the PowerShell VC of PASS set out to “Make SQL PowerShell Great Finally” and it is well on its way. Along with PowerShell MVP Chrissy LeMaire, Aaron helps organize what the community is asking for in the new SqlServer PowerShell module on the community Trello board (sqlps.io/vote). Thanks to these efforts and the countless contributions from the SQL community around the world, we have already received 30 new SQL PowerShell cmdlets and have been told to expect even more new cmdlets every month!

30+ New SQL PowerShell cmdlets have already been delivered and more are on their way every month. 2016 has unleashed a new era in what can be done with data by leveraging PowerShell.

PowerShell is for every Data Professional and this session is built from my own experience as a DBA, Database Developer, and now B/I Developer.

The day will start with a primer on the basics of PowerShell and it’s eco system.

You will learn things like how to work with data, import it into SQL Server extremely quickly, back up your database schema, compare that schema with another database.

We will go through techniques to scale your scripts across multiple instances as well as how to store the results where you want.

Even if you’re not a not a B/I Developer you may have needed to deploy an SSRS report or two, you will learn easy ways to leverage PowerShell to deploy lots of reports to lots of machines.

While we’re at it, we’ll go through new features the community has asked Microsoft build for SQL PowerShell, how you can add your voice to that conversation, and how to build something to get around an issue until Microsoft gets around to building their own solution.

Finally, we will go through error handling and other things to make your scripts more durable.

All attendees will receive all of the code that is demoed, as well as handouts about the language and how to get things done.

Learning Objectives

Show how to deploy database change faster & more consistently

Show how to easily gather environment & performance information

Show how to simplify common ETL & Reporting tasks data professionals are frequently asked to handle.

 

Aaron Nelson ( blog | twitter ) is a Microsoft MVP for SQL Server (Data Platform) and leads the PowerShell Virtual Chapters of PASS, and volunteers for the local PASS Chapter AtlantaMDF, and helps organize SQL Saturday events in Atlanta.

The PowerShell VC of PASS hosts monthly sessions on SQL Server + PowerShell and you can find the recordings of those sessions on their YouTube channel.

Last year, the PowerShell VC of PASS set out to “Make SQL PowerShell Great Finally” and it is well on its way. Along with PowerShell MVP Chrissy LeMaire, Aaron helps organize what the community is asking for in the new SqlServer PowerShell module on the community Trello board (sqlps.io/vote). Thanks to these efforts and the countless contributions from the SQL community around the world, we have already received 30 new SQL PowerShell cmdlets and have been told to expect even more new cmdlets every month!

30+ New SQL PowerShell cmdlets have already been delivered and more are on their way every month. 2016 has unleashed a new era in what can be done with data by leveraging PowerShell.

PowerShell is for every Data Professional and this session is built from my own experience as a DBA, Database Developer, and now B/I Developer.

The day will start with a primer on the basics of PowerShell and it’s eco system.

You will learn things like how to work with data, import it into SQL Server extremely quickly, back up your database schema, compare that schema with another database.

We will go through techniques to scale your scripts across multiple instances as well as how to store the results where you want.

Even if you’re not a not a B/I Developer you may have needed to deploy an SSRS report or two, you will learn easy ways to leverage PowerShell to deploy lots of reports to lots of machines.

While we’re at it, we’ll go through new features the community has asked Microsoft build for SQL PowerShell, how you can add your voice to that conversation, and how to build something to get around an issue until Microsoft gets around to building their own solution.

Finally, we will go through error handling and other things to make your scripts more durable.

All attendees will receive all of the code that is demoed, as well as handouts about the language and how to get things done.

Learning Objectives

Show how to deploy database change faster & more consistently

Show how to easily gather environment & performance information

Show how to simplify common ETL & Reporting tasks data professionals are frequently asked to handle.

 

Aaron Nelson ( blog | twitter ) is a Microsoft MVP for SQL Server (Data Platform) and leads the PowerShell Virtual Chapters of PASS, and volunteers for the local PASS Chapter AtlantaMDF, and helps organize SQL Saturday events in Atlanta.

The PowerShell VC of PASS hosts monthly sessions on SQL Server + PowerShell and you can find the recordings of those sessions on their YouTube channel.

Last year, the PowerShell VC of PASS set out to “Make SQL PowerShell Great Finally” and it is well on its way. Along with PowerShell MVP Chrissy LeMaire, Aaron helps organize what the community is asking for in the new SqlServer PowerShell module on the community Trello board (sqlps.io/vote). Thanks to these efforts and the countless contributions from the SQL community around the world, we have already received 30 new SQL PowerShell cmdlets and have been told to expect even more new cmdlets every month!

30+ New SQL PowerShell cmdlets have already been delivered and more are on their way every month. 2016 has unleashed a new era in what can be done with data by leveraging PowerShell.

PowerShell is for every Data Professional and this session is built from my own experience as a DBA, Database Developer, and now B/I Developer.

The day will start with a primer on the basics of PowerShell and it’s eco system.

You will learn things like how to work with data, import it into SQL Server extremely quickly, back up your database schema, compare that schema with another database.

We will go through techniques to scale your scripts across multiple instances as well as how to store the results where you want.

Even if you’re not a not a B/I Developer you may have needed to deploy an SSRS report or two, you will learn easy ways to leverage PowerShell to deploy lots of reports to lots of machines.

While we’re at it, we’ll go through new features the community has asked Microsoft build for SQL PowerShell, how you can add your voice to that conversation, and how to build something to get around an issue until Microsoft gets around to building their own solution.

Finally, we will go through error handling and other things to make your scripts more durable.

All attendees will receive all of the code that is demoed, as well as handouts about the language and how to get things done.

Learning Objectives

Show how to deploy database change faster & more consistently

Show how to easily gather environment & performance information

Show how to simplify common ETL & Reporting tasks data professionals are frequently asked to handle.

 

Aaron Nelson ( blog | twitter ) is a Microsoft MVP for SQL Server (Data Platform) and leads the PowerShell Virtual Chapters of PASS, and volunteers for the local PASS Chapter AtlantaMDF, and helps organize SQL Saturday events in Atlanta.

The PowerShell VC of PASS hosts monthly sessions on SQL Server + PowerShell and you can find the recordings of those sessions on their YouTube channel.

Last year, the PowerShell VC of PASS set out to “Make SQL PowerShell Great Finally” and it is well on its way. Along with PowerShell MVP Chrissy LeMaire, Aaron helps organize what the community is asking for in the new SqlServer PowerShell module on the community Trello board (sqlps.io/vote). Thanks to these efforts and the countless contributions from the SQL community around the world, we have already received 30 new SQL PowerShell cmdlets and have been told to expect even more new cmdlets every month!

Register here.

 

Pre-Conference Session, June 23, 8:30AM-5:00PM

SQL Development Hero in a Day - Vladimir Oselsky & Nathaniel Gainer


This full-day workshop will help you discover the secrets of successful database development. We will take a deep dive into what can make and break a database solution including some specific intricacies that have to be taken when developing on SQL Server. There are many ways to develop a database, some are just better than others.

During this workshop, we will be discussing the following topics: 
 * Performance Tuning 
 * Patterns and Design for proper Database Development 
 * Advanced Database Development Techniques 
 * Error Handling/Transaction Handling 
 * Tools Available for Faster Development 
 * Database Modeling Techniques 
 * And Much More! 

Vladimir Oselsky presented his first SQL Saturday in Chattanooga three years ago and since has spoken at SQL Saturday's all over the country. He's a developer whose programming language specialties include SQL,C#, VB.NET, ASP.NET, SilverLight 4.0 and .NET 4.0 and various softwares and technologies.

Nathaniel Gainer also presented his first session at SQL Saturday Chattanooga. He's a developer and data warehouse architect at U.S. Express with a wide variety of experience in SQL Server development and integration projects.


Register here.

Event Location

Event news

  • Friday, June 16, 2017

    AFTER PARTY!!!!!!Hey everybody, let's go to the Comedy Catch after the event. They have a nice little bar attached to the showroom with a porch on Station Street. Good food, good drinks, and SQL Family! An unbeatable combination.

  • Monday, May 8, 2017

    SEVEN TRACKS!!!That's right, we've added another track because there were so many good speakers who submitted so many good sessions.We'll be announcing the schedule shortly. If there's anything data science that we're not covering, you don't need to know it.Make plans now for June 24.

  • Tuesday, January 10, 2017

    Hey, we're live! SQL Saturday is coming to Chattanooga for the third year. We thank everyone who came to the last two and promise that SQL Saturday #624 Chattanooga 2017 will be better than ever. More great content and sponsor than ever. Make plans now to visit us on June 24 in Gig City.

Contact

Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us


Back to Top