May '18 BRSSUG+BRPBIUG Meeting at Alliance Safety Council

Post date: Apr 27, 2018 3:16:33 PM

Date: May 9, 2018

Location:

Alliance Safety Council

10099 Reiger Rd

Baton Rouge, LA 70809

Directions:

Turn onto North Reiger Rd between the McDonald's and Racetrack on Siegen Lane. We are located in the fancy building next door to Office Depot. Parking is directly in front of the building.

Entrance is the double glass doors in the front of the building under the awning and there will be signs pointing to where the meetings will take place.

Sponsor: Sponsorship Available

Agenda:

• 5:45 - 6:15: General Introduction/Food and Drinks

• 6:15 - 7:30: Presentations

• 7:30 - Until: Open forum for questions

**NEWS: You can now order SQLSaturday Baton Rouge posters online! https://coastalthreads.com/sqlsaturdayposter/

Main Presentation:

Analyzing I/O Subsystem Performance, Glenn Berry

SQL Server is often I/O bound - but why? Do you feel lost when talking to your storage administrator? Are your storage subsystems like a mysterious black box where your databases live but you can’t go visit? This session will get you up to speed with the fundamentals of storage subsystems for SQL Server. You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.

Lightning Round:

Why Data Types Matter!, John Wells

In this lightning round, we will go over why it is important to choose your data types wisely. I will show a few different examples of data types, the difference in I/O and why Developers need to stop with the NVARCHAR(MAX) already.

Bios:

Glenn Berry is a Principal Consultant with SQLskills. He has worked as a SQL Server professional for many years in a variety of roles, most recently as Database Architect for Avalara in Parker, CO.

Glenn has been a SQL Server MVP since 2007, and has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves he likes to take tests. His expertise includes DMVs, high availability, hardware selection and configuration, and performance tuning. He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. He has completed the Master Teacher Program at University College.

Glenn is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, and the PASS Community Summit. He is the author of the book SQL Server Hardware, and he wrote chapters for SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2 books.

John Wells: Originally from Southern California, I am enjoying the slower pace here in Louisiana. I continue my journey with PowerShell and Performance Tuning. If I am not at a SQLSaturday event or a LSU game, I am grilling something or killing some crawfish! Actually I smoke more than grill, but when I say this people look at me funny.