SQLSaturday #523 - Iowa City 2016

Event Date: 06/11/2016 00:00:00

Event Location:

University of Iowa - University Capitol Centre
201 S Clinton St
Iowa City, Iowa

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: SQL Server Hybrid Cloud Strategy: Best Of Both Worlds With On-Prem + Cloud

Abstract: For years it seemed that the only message SQL Server professionals were hearing was “to the Cloud…. you must get to the Cloud!”. However, if you work in a highly regulated industry, or one simply averse to change, this likely was not an option for you. The good news is, Microsoft heard your feedback and has been busy incorporating Cloud connectivity, compatibility, and functionality into the box product.

Come spend the hour with me and you’ll learn how to leverage the power of the Cloud with your on-premises SQL Server install. We’ll cover backup and restore options with Windows Azure Storage, using Windows Azure VMs for high availability, how to store your data files in Windows Azure Storage, and more. We’ll start with SQL Server 2012 and work our way up to the most recently released bits for SQL Server 2016. You can have the best of both worlds with a SQL Server Hybrid Cloud strategy!

Speaker(s):

Paul Timmerman

Track and Room: Cloud Application Development Deployment - 2520B

Title: Virtual SQL Servers. Actual Performance.

Abstract: Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance. This session is packed with many tips and tricks gained from years of experience for getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.

Speaker(s):

David Klee

Track and Room: Enterprise Database Administration Deployment - 2520D

Title: Kerberos Delegation Made Simple

Abstract: Kerberos delegation is often needed for SQL Server Reporting Services security. Many DBAs avoid Kerberos because of the complexity and come up with workarounds that may violate security policies in their shops. They also may not understand why Kerberos delegation is even required. Configuring Kerberos for SSRS can be broken down into three simple steps: SPN registration, setting delegation properties, and application configuration. It’s really not so difficult, and there are a number of tools that can help you troubleshoot when things don’t go as planned. Attend this session to learn why Kerberos is necessary and how to configure and troubleshoot it.

Speaker(s):

Kathi Kellenberger

Track and Room: Enterprise Database Administration Deployment - 2520D

Title: Building a Data Warehouse for the DBA

Abstract: Users want Data Warehouses built, but no one ever builds one for the DBA. Let’s fix that!

Get information from Active Directory, your Windows Servers, SQL Servers and other sources that mean something and will help you to keep the databases running smoothly. Be able to see which disks/machines are low on disk, what databases are on which SQL Servers, when backups happened and if any jobs failed.

This is targeted at the DBA who is responsible for multiple SQL Servers, in multiple places, and doesn’t have time to “point and click” their way to a comfortable understanding of the moving pieces on all of the systems that they need to monitor!

Speaker(s):

Pat Phelan

Track and Room: Automation and Monitoring - 2520C

Title: Does it Hurt When I Do This? Performing a SQL Server Health Check

Abstract: How often do you review your SQL Servers for basic security, maintenance, and performance issues? Many of the servers I “inherit” as a managed services provider have quite a few gaping holes. It is not unusual to find databases that are never backed up, servers with constant login failures (is it an attack or a bad connection string?), and servers that need more RAM/CPU/etc. (or sometimes that even have too much!)

Come learn how to use freely available tools from multiple layers of the SQL Server stack to check your servers for basic issues like missing backups and CheckDB as well as for more advanced issues like page life expectancy problems and improper indexing. If you are responsible in any way for a Microsoft SQL Server (DBA, Windows Admin, even a Developer) you will see value in this session!

Speaker(s):

Andy Galbraith

Track and Room: Automation and Monitoring - 2520C

Title: PoShDBA: Practical PowerShell for the DBA

Abstract: Think of all the tools you use in managing your SQL Servers. All those SQL Servers being managed by tools and man that is a lot of clicks. We will show practical scripts and techniques to help you get a handle on all those clicks. Whether you are gathering data or statistics from your SQL Servers or deploying an object to all of them. Configuration items are not excluded from the need for good tools. PowerShell is that tool that will let you get away from all those clicks. Reusable scripts that let you manage all those instances with ease. This session will give you a great start on how to think about admin tasks using PowerShell scripts or modules. Many items are already out there to help you and we will take a good look.

Speaker(s):

Ben Miller

Track and Room: PowerShell - 2390

Title: Performance Pitfalls from Code Reuse

Abstract: Have you ever found yourself deconstructing endless layers of nested code? Is your T-SQL codebase written in an object-oriented format with functions views? Did you know that object-oriented code reuse can come at a significant penalty?

Come to this session and learn why applying object-oriented principles can be extremely detrimental to your T-SQL’s performance. You will learn how T-SQL is not like other common programming languages. We will peek inside the Query Optimizer to see how it handles these scenarios. Through extensive demos, we will explore solutions to maximize performance. You will be introduced to a T-SQL tool that will aid you in unraveling nested code. Alternate design patterns will be shown to help you mitigate these performance pitfalls.

Speaker(s):

Andy Yun

Track and Room: Application Database Development - 2520B

Title: Extended Events: What are they and How do I use them

Abstract: Since Extended Events are replacing Profiler, every DBA should know what they are and how to use them. This session will cover what Extended Events are and how to use them.

Speaker(s):

Dave Bland

Track and Room: Automation and Monitoring - 2520B

Title: Get Your Optimizer to Give up All Its Secrets

Abstract: You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated? In this session, we will examine details the query optimization process that are not very well known. We will discuss how SQL Server parses a T-SQL statement then and begins applying rules to make it more efficient. Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos? We’ll do just that, and then take it a step further with a unique visualization tool that I have created. With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn’t do it as well as might be hoped), you can write more efficient SQL statements.

Speaker(s):

Brian Hansen

Track and Room: Enterprise Database Administration Deployment - 2520C

Title: Data Architecture 101

Abstract: This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!

This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.

Speaker(s):

Pat Phelan

Track and Room: Application Database Development - 2520D

Title: Taming the Transaction Log

Abstract: Wonder why the transaction log keep filling up the hard-drive? Wonder why a full backup does not backup the transaction log? Wonder how often to back up the transaction log? Wonder if the transaction log can be backed up in parallel? This interactive session will help to you to find answers to those questions and more.

Speaker(s):

Mike Hays

Track and Room: Enterprise Database Administration Deployment - 2520C

Title: SQL Server may let you do it, but it doesn’t mean you should.

Abstract: SQL Server comes packed with functionality, options, settings and features. Some of these are old, some brand new. Some features and functionality have been declared deprecated, others might be in the next cut (or maybe should be). This session will cover all the items that I’ve found or have seen in my research that may not be the best approach at using what SQL Server has to offer.

Speaker(s):

Samantha Fahrmann

Track and Room: Application Database Development - 2520B

Title: Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)

Abstract: As DBAs, we are asked all sorts of impossible questions. Who dropped that important table last month? Why was everything slow last week? Who made that user a sysadmin? You’d have to be a mind reader to know the answers to some of those, right? Not necessarily! SQL Server can help you find information about these and other common problems with its default trace and system_health Extended Events session, but you have to know how to collect and interpret the data they provide. In this session, we’ll explore what system_health and the default trace are, what information they contain, and how to use them to find the answers you’re searching for.

Speaker(s):

Ed Leighton-Dick

Track and Room: Automation and Monitoring - 2390

Title: Capture Changes with SQL Server’s Change Data Capture

Abstract: Learn how to easily capture information about data changes – inserts, deletes and updates using SQL Server’s Change Data Capture feature. Change Data Capture tracks INSERTs, UPDATEs, and DELETEs applied to your SQL Server tables, and then informs you of what changed and when it changed. In this presentation we’ll walk through the steps needed to activate Change Data Capture on your database tables and then explore how you can use Change Data Capture to understand how and why your data changed. Every SQL DBA and Developer utilizing SQL Server 2008/2012/2014 will benefit from this presentation.

Speaker(s):

Wylie Blanchard

Track and Room: Application Database Development - 2520B

Title: How to collect a baseline on all your servers and still get a good night’s sleep.

Abstract: Your boss comes up to you and asks you why the system is slow, unless you know how your system is supposed to respond you are stuck scrambling to answer those questions. With a few free quires and some SSIS magic you can capture a Baseline of your systems. With this you will be able to know exactly where to look and what might be amiss. Before you can say what is wrong with your system you need to know how it reacts under normal circumstances. This session will provide the tools you need to start collection of your systems baselines and give you a great deal of information.

Speaker(s):

Jim Dorame

Track and Room: Automation and Monitoring - 2390

Title: I Installed SQL Server… Now What?

Abstract: Before handing over a new SQL Server to DevOps or a Dev team, there are several things you should do to follow best practices and ensure optimal performance. In this session, Jared will go through his build checklist and explain why he is doing things like setting Cost Threshold for Parallelism, verifying Kerberos, and checking disk drive settings. When you leave this session, you will have the knowledge and tools to successfully implement a new SQL Server instance – and a copy of his checklist!

Speaker(s):

Jared Karney

Track and Room: Enterprise Database Administration Deployment - 2523

Title: Tackling Technical Blogging

Abstract: Ever thought of writing a technical blog? This session will cover the Ws (who, what, when, where, why, how) of getting a technical blog started. Answer the question of how it can be done for free. Discuss why pay for your own domain name. Explain how to be on the first page of a search engine. Learn how to determine the time commitment. And finally determine topics to write about.

Speaker(s):

Mike Hays

Track and Room: Professional Development - 2390

Title: Using Powershell to Automate Your Restore Strategy

Abstract: As DBAs, our most important job is protecting the data. Making sure our backups are running successfully gets us halfway there, but those backups are useless if we can’t restore them. Join me for this session to learn how to use Powershell to automate a restore process for backup validation.

Speaker(s):

Frank Gill

Track and Room: PowerShell - 2390

Title: Women in Technology Lunch: Energizing the Next Generation

Abstract: Everyone has heard that the number of women in technology is declining. How can all of us, women and men, encourage more young women to consider a career in technology? Join other women in technology over the lunch hour to discuss this important and hot topic. Attendees are encouraged to ask questions, make suggestions, and share their experiences as well.

Speaker(s):

Andrea Mascher

Track and Room: Professional Development - 2520D

Title: SQL Server Data Protection with EMC Technology [Sponsored]

Abstract: Every organization has their own ways of dealing with SQL data protection, typically including a mix of SQL scripts, local disk, NAS, snapshots and backup software. What strategy is right for your environment? Two focus topics in this educational session-

1 - How other Iowa customers are protecting SQL data with EMC Technology 2 - How EMC is simplifying and streamlining data protection for Microsoft SQL, while keeping control in the hands of the DBA

Speaker(s):

Klas Wiberg

Track and Room: Strategy and Architecture - 2523

Title: DataZen and MS SQL 2016 Mobile BI now

Abstract: Microsoft purchased DataZen last year. With the upcoming release of MS SQL 2016 the DataZen Business Intelligence dashboards are integrating into SSRS. The SSRS 2016 web portal has some significant changes. This session will cover the how DataZen enterprise has changed from a standalone web service to part of SSRS. I’ll also do a walkthrough of migrating existing DataZen dashboards to a SSRS 2016 instance.

Speaker(s):

James Borland

Track and Room: BI Platform Architecture, Development Administration - 2523

Title: SQL Server 2016: What’s new?

Abstract: This session will provide you with high level overview of several of the new features in SQL Server 2016. It will cover Always Encrypted, PolyBase, StretchDB and more. This is level 101 session so we will not be going deep into any one technology but will cover topics at the high level.The idea is to give you the taste of the new features of SQL Server 2016 and whatever spikes your interest, you can then go learn and test those features in your Dev environment.

Speaker(s):

Ameena Lalani

Track and Room: Enterprise Database Administration Deployment - 2520C

Title: SQL Server 2016 for BI

Abstract: SQL Server 2016 is a new and shiny tool that we all know is coming. What exactly does it mean for BI though? What upgrades and new features are there that we actually care about? Well, we have a lot to talk about.

Speaker(s):

George Bryant

Track and Room: BI Information Delivery - 2523

Title: Uncovering Duplicate, Redundant, and Missing Indexes

Abstract: Do you know if your database’s indexes are really being used to their fullest potential? And do you know if SQL Server needs other indexes to improve performance?

Attend this session and learn how SQL Server tracks actual index usage, and how you can make use of that information to improve the state of indexes in your database. We will use this data to identify wasteful, unused, redundant indexes, and explore performance penalties you pay for not addressing these inefficient indexes. Finally, we will dive into the Missing Index DMV and explore the art of evaluating its recommendations to make proper indexing decisions.

Speaker(s):

Andy Yun

Track and Room: Application Database Development - 2520B

Title: So this is Power BI. What now?

Abstract: Everyone is talking about Power BI. People are starting to use and interact with Power BI. That is a good thing, Power BI is fun! As an organization however, what do I do now and how do I handle a periodically changing beast? Here is what to consider…

Speaker(s):

George Bryant

Track and Room: BI Platform Architecture, Development Administration - 2523

Title: Wibbly-Wobbly, Timey-Wimey Tables

Abstract: The temporal table type is introduced with SQL 2016. It has practical applications as a background auditing replacement and even dimensional tables in DataMart. This session will look at creating temporal tables, modifying data, and querying enhancements. The temporal table type allows time travelling in widowed views without the need to write complicated joins to multiple historic/audit tables.

Speaker(s):

James Borland

Track and Room: Application Database Development - 2520C

Title: “R” You Ready For SQL 2016?

Abstract: R is one of the fastest growing programming languages, useful for data analysis and visualization. You’ve been able to connect to SQL databases to work with large data sets before using R packages. But now, with the upcoming SQL 2016 release, R will be included as an Advanced Analytics Extension. You’ll be able to run the same R scripts right in your database.

In this beginner session we will look at how to set up R on your SQL instance. We’ll work with some sample data to show how R works with SQL inside and outside the database with some basic R commands. And we’ll create some graphs and charts for use in some SSRS reports.

Speaker(s):

John Pertell

Track and Room: Analytics and Visualization - 2520D

Title: The Flash-Enhanced Database [Sponsored]

Abstract: Imagine if storage I/O latency was no longer an inhibiter to database performance, growth, maintenance, and opportunity. Consider a world where the storage administrator no longer had to tell you, “No!” Pure Storage will share how they are making this dream a reality for DBAs everywhere. Welcome to a world where reports are faster, maintenance gets to complete, and database recovery is instant.

Speaker(s):

Brandon Grieve

Track and Room: Strategy and Architecture - 2523

Title: Understanding SQL Server 2016 Always Encrypted

Abstract: Always Encrypted is a highly-touted new feature of SQL Server 2016 that promises to make encryption simple to use and transparent to applications while still protecting the data both at rest and in motion, even from high-privilege users such as developers and DBAs. Does that sound too good to be true? It isn’t - Always Encrypted is an incredible feature - but like any new technology, it does have some limitations. In this session, you’ll see how to configure Always Encrypted, and we’ll talk about when you should and shouldn’t use it in your environment.

Speaker(s):

Ed Leighton-Dick

Track and Room: Application Database Development - 2520D

Title: Infrastructure Tuning for SQL Server Performance

Abstract: Mention SQL Server performance to any DBA, and the impulse is to dive headfirst into the database and queries. However, if the infrastructure underneath the data is your performance bottleneck, the time spent tuning at the database layer is usually in vain. Server hardware, operating system parameters, storage, interconnects, and networking will all be discussed in depth in terms that DBAs can relate to. Practical architecture guidelines and troubleshooting techniques will be presented so you can analyze your environments and see if your performance bottlenecks are where you think they are.

Speaker(s):

David Klee

Track and Room: Enterprise Database Administration Deployment - 2523

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Pat Phelan

Twitter: - @YetAnotherSQL

LinkedIn: Pat Phelan

Pat Phelan first joined a computer user group (DECUS) in High School, and has joined many more since then. Pat worked many jobs in high school and college, and over twenty years for a major accounting firm. Pat started working for Involta in 2007 and is now the database mentor and a member of the Engineering team. Involta builds, owns and operates world class colocation datacenters and also provides managed services and support staff to clients.

Dave Bland

Twitter: - @SQLDave29

LinkedIn: Dave Bland

Contact: https://www.davebland.com

Over 20 years of SQL Server experience that includes being a DBA, BI development and Application development using VB.NET. Dave currently is the Manager of the DBA team at Stericycle. Dave is a Friend of Red-Gate for 2019. He is a frequent presenter at SQLSaturday events and user groups around the country. Has been teaching SQL Server since version 2000 and is the SQL Server instructor at Harper College in Palatine, IL. Current certifications include: • Microsoft Certified Trainer • MCTS: SQL Server 2008, Implementation and Maintenance • MCTS: SQL Server 2008, BI Development and Maintenance • MCSA: SQL Server 2008 • MCSA: SQL Server 2016 • MCSE: SQL Server 2016 - BI • MCDBA: SQL Server 2000 • MCSD • MCSE: Data Management and Analytics

Andy Yun

Twitter: - SQLBek

LinkedIn: Andy Yun

Contact: http://sqlbek.wordpress.com

Andy Yun is a SentryOne Principal Solutions Engineer and a former Microsoft MVP. He has been working with SQL Server for nearly 20 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQLSaturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQLSaturday Organizing Committee.

Paul Timmerman

Contact: http://blogs.lessthandot.com/index.php/author/mndba/

Paul is a Microsoft SQL Server MVP and the Lead SQL Server DBA at Hennepin County Medical Center in Minneapolis, Minnesota. Paul has fifteen years of experience in database administration and currently the Chapter Leader of the Minnesota SQL Server User Group, PASSMN. Paul is an active member of the PASS community and routinely speaks at user group meetings and SQLSaturday conferences.

Mike Hays

LinkedIn: Mike Hays

Contact: http://www.thesqlreport.com/

Mike has been working with Microsoft SQL Server for the last twenty years. Currently working as a Database Administrator for a diversified energy company, he has also worked in the retail, manufacturing, banking sectors. He holds a Master’s degree in Computer Information Science from Cleveland State University. He currently resides in Ohio with his girlfriend Alexia, her two children and their dog Lanna.

Klas Wiberg

Klas Wiberg has been an EMC Data Protection SE for the past 5 1/2 years, working directly with over 100 customers in the state of Iowa. Prior to EMC, he has held a variety of IT positions over 19 years, including leadership positions in the MSP and financial industries. Outside of work, his 2, 4 and 6 year old children do an excellent job keeping him busy.

Andy Yun

Twitter: - SQLBek

LinkedIn: Andy Yun

Contact: http://sqlbek.wordpress.com

Jared Karney

Twitter: - jaredkarney

LinkedIn: Jared Karney

Jared Karney has been working with SQL Server since 2007. He currently works as a Premier Field Engineer for Microsoft. His specialties include performance tuning, big data, cloud, automation, internals, and overall architecture. He is an MCT and holds a number of Microsoft certifications. He is also a leader for the Chicago SQL Server Users Group.

John Pertell

Twitter: - https://twitter.com/jayape

LinkedIn: John Pertell

Contact: http://www.pertell.com/sqlservings

I am an Accidental Database Administrator, working for the same healthcare company since 2000. I started using MS Access for report writing but started playing with SSRS 2000 and haven’t missed going back. In my spare time I enjoy reading, photography, and pretending I know how to golf.

Mike Hays

LinkedIn: Mike Hays

Contact: http://www.thesqlreport.com/

Samantha Fahrmann

Twitter: - @slfahrmann

LinkedIn: Samantha Fahrmann

I Graduated from University of Northern Iowa in 2010 with my BA in Computer Science. I previously worked for a Law Enforcement Software company as a developer and accidental DBA for over 7 years. Since Aug 2016, I’ve dived into the DBA world fully at Modern Woodmen of America and loving every minute. My passion for SQL Server came about when I was wanting to learn more about performance. I started attending the SQLSaturdays, with my first being in Iowa City in 2012. The one thing I love more than anything is to always learn something knew every chance I get.

Ed Leighton-Dick

Twitter: - eleightondick

LinkedIn: Ed Leighton-Dick

Contact: http://www.edleightondick.com

Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including current roles as a Regional Mentor, co-leader of I-380 PASS local group, and co-leader of the HA/DR virtual group. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.

David Klee

Twitter: - kleegeek

LinkedIn: David Klee

Contact: http://davidklee.net

David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.

Ed Leighton-Dick

Twitter: - eleightondick

LinkedIn: Ed Leighton-Dick

Contact: http://www.edleightondick.com

Andy Galbraith

Twitter: - https://twitter.com/DBA_ANDY

LinkedIn: Andy Galbraith

Contact: http://nebraskasql.blogspot.com/

I’m a forty-something Microsoft SQL Server DBA of 18+ years, a devoted husband, and a father of three young boys (all aged eight and under!) I have been a DBA at a public university, at a major bank, at a healthcare system, and I now work as a consultant with customers across the United States. I write and speak primarily about the tips and tricks that I discover along my SQL Server journey.

Jim Dorame

Twitter: - @DBAJD

LinkedIn: Jim Dorame

Contact: http://www.jamesdorame.com/

Jim Dorame has been working with SQL Server for over 20 years. Over those years he has learned a great deal from the SQL community. He has also given back to the community in the hopes that he may help someone in their career. He is always looking for something to learn and luckily Microsoft keeps adding to SQL Server.

Wylie Blanchard

Twitter: - WylieBlanchard1

LinkedIn: Wylie Blanchard

Contact: https://WylieBlanchard.com/?utm_source=sqlsaturday.comutm_medium=profileutm_campaign=website

Wylie Blanchard, MCSE is an IT consultant, SQL Server professional and web strategist who enjoys helping people learn how to use technology as a tool to amplify their professional lives. He has 15+ years of experience in the IT Industry and holds several certifications in SQL and Oracle systems. He is a father of twin-girls, a gadget enthusiast and a self-proclaimed pizza connoisseur. Learn more about Wylie at: www.WylieBlanchard.com.

Andrea Mascher

Andrea Mascher (she/her) leads the SQL Server DBA team at The University of Iowa (UI). In addition to her experience in the education sector, Andrea previously supported systems in the biotechnology and healthcare fields.

Andrea is an advocate for gender diversity in STEM and co-founded the UI Women In Technology users group to promote a climate of inclusivity and professional growth for women and non-binary individuals in technical fields at UI. Andrea also serves as a member of the UI Council on the Status of Women.

Andrea’s undergraduate and graduate coursework at UI was in Computer Science, with a focus on Electronic Voting Systems and Technology Law and Policy.

Brandon Grieve

LinkedIn: Brandon Grieve

Brandon Grieve is a Systems Engineer at Pure Storage. He is a 20-year IT veteran and has seen all sides of the data center – sales, architecture, engineering, and operations. Nearly the last decade of this time has been spent with an emphasis on storage and backup amp; recovery. Most importantly, Brandon likes to collaborate with his clients on how these technologies enable value to business-critical applications in the modern data center.

Pat Phelan

Twitter: - @YetAnotherSQL

LinkedIn: Pat Phelan

James Borland

Jim Borland has over 20 years of hands-on Information technology experience across various industries ranging from governmental, hospital, biotechnology, and telemarketing. Jim start out as an application program who ended up liking data too. His SQL Server experience began with SQL Server 6.0 in 1996. Jim currently a Lead Database Administrator at the University of Iowa overseeing 180+ SQL instances and involved in the Business Intelligence campus wide efforts.

Ameena Lalani

Twitter: - SQLHands

LinkedIn: Ameena Lalani

Ameena Lalani is a SQL Server veteran and started her journey with SQL Server 2000. She is a Microsoft Certified Solution Associate on SQL Server 2016 and also hold Azure Administrator Associate certification. Ameena works at Microsoft as a Premier Field engineer. She has implemented numerous High Availability and Disaster Recovery solutions at various companies. Ameena loves to share her technical knowledge and speaks at local user groups and SQLSaturday events throughout the United States.

Ben Miller

Twitter: - DBAduck

LinkedIn: Ben Miller

Contact: https://dbaduck.com

Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.

James Borland

Frank Gill

Twitter: - skreebydba

LinkedIn: Frank Gill

Contact: http://skreebydba.com/

Frank Gill is a Senior Data Engineer at Concurrency With 21 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. Over the past several years, he has worked extensively with SQL Server solution in Azure, including Managed Instance. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.

George Bryant

Twitter: - Azure_George0

LinkedIn: George Bryant

George has over a decade of experience in the Business Intelligence industry and is an active member of the BI community across the Midwest. His knowledge spans multiple industries including, retail, manufacturing, finance, and medical, however recent years has seen him focus on the analytics in sports.

George specializes in BI architecture and end to end development in order to deliver advanced analytics and metrics to multiple organizations across the country. In recent years George has focused on and worked primarily in the Azure cloud, utilizing both established and recent offerings.

George Bryant

Twitter: - Azure_George0

LinkedIn: George Bryant

Brian Hansen

Twitter: - tf3604

Contact: http://www.tf3604.com

Brian is a database administrator at Children International in Kansas City. He has been working with SQL Server technologies since 1998, including roles in report development, application development and database administration.

David Klee

Twitter: - kleegeek

LinkedIn: David Klee

Contact: http://davidklee.net

SQLSaturday #523 - Iowa City 2016

Sessions

Title: SQL Server Hybrid Cloud Strategy: Best Of Both Worlds With On-Prem + Cloud

Title: Virtual SQL Servers. Actual Performance.

Title: Kerberos Delegation Made Simple

Title: Building a Data Warehouse for the DBA

Title: Does it Hurt When I Do This? Performing a SQL Server Health Check

Title: PoShDBA: Practical PowerShell for the DBA

Title: Performance Pitfalls from Code Reuse

Title: Extended Events: What are they and How do I use them

Title: Get Your Optimizer to Give up All Its Secrets

Title: Data Architecture 101

Title: Taming the Transaction Log

Title: SQL Server may let you do it, but it doesn’t mean you should.

Title: Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)

Title: Capture Changes with SQL Server’s Change Data Capture

Title: How to collect a baseline on all your servers and still get a good night’s sleep.

Title: I Installed SQL Server… Now What?

Title: Tackling Technical Blogging

Title: Using Powershell to Automate Your Restore Strategy

Title: Women in Technology Lunch: Energizing the Next Generation

Title: SQL Server Data Protection with EMC Technology [Sponsored]

Title: DataZen and MS SQL 2016 Mobile BI now

Title: SQL Server 2016: What’s new?

Title: SQL Server 2016 for BI

Title: Uncovering Duplicate, Redundant, and Missing Indexes

Title: So this is Power BI. What now?

Title: Wibbly-Wobbly, Timey-Wimey Tables

Title: “R” You Ready For SQL 2016?

Title: The Flash-Enhanced Database [Sponsored]

Title: Understanding SQL Server 2016 Always Encrypted

Title: Infrastructure Tuning for SQL Server Performance

Speakers

Sponsors