SQLSaturday #787 - Sioux Falls 2018
Event Date: 08/18/2018 00:00:00
Event Location:
- Augustana University, Froiland Science Complex (33rd Summit Ave)
- 2001 S Summit Ave
- Sioux Falls, South Dakota
This event has completed. All data shown below is from the historical XML public data available.
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: A Rocket Scientist Perspective on Indexes
Abstract: Performance! Performance! Performance! That’s what the rocket scientist and SQL Developer are looking for. Indexes can offer significant performance benefits, but can also be a detriment to overall database performance. This session will focus on a deep dive into clustered indexes (including B-tree traversal), Primary Keys, and non-clustered indexes, their syntax and utilization, and their effect on performance in transaction and data warehouse databases. Covering non-clustered indexes will also be examined in detail with emphasis on when and when not to use. Included will be many live query demos illustrating index utilization and performance using statistics and query plans. Some knowledge of TSQL and Management Studio is recommended.
Speaker(s):
- Mike Byrd
Track and Room: Application Database Development - Room 373
Title: Extending DevOps To SQL Server
Abstract: Most organizations are under pressure to speed up the software delivery cycle, whether that’s to respond more quickly to the needs of the business, the needs of your customers or just to keep up with the competition. Unfortunately the database is commonly considered a bottleneck. Without the right processes in place, database change management can slow things down, adding risk, uncertainty, and getting in the way of development and operations working together to deliver. Any organization that wants to fully benefit from a DevOps approach is going to have to overcome some specific challenges presented by the database. This session will teach you how to take DevOps principles and practices and apply them to SQL Server so that you can speed up the database delivery cycle at the same time you protect the information contained within.
Speaker(s):
- Grant Fritchey
Track and Room: Application Database Development - Room 373
Title: Powering Up with Power BI (Pre-Con)
Abstract: This day-long session will provide instruction on each aspect of Power BI. We will cover:
• Data collection using the Query Editor and the M language • Data modeling • Measures using DAX formulas • Visualizations with an emphasis on user interactivity with the data • Deployment and management in a secure, shared environment
Along the way we will look at tips and tricks as well as best practices for each of these facets of Power BI. Participants will leave with an understanding of the full range of capabilities of Power BI along with the confidence to use Power BI to create and securely share meaningful analytics.
Register Here: https://www.eventbrite.com/e/sqlsaturday-sioux-falls-pre-conference-tickets-45947239430?aff=utm_source%3Deb_email%26utm_medium%3Demail%26utm_campaign%3Dnew_event_emailutm_term=eventname_text#tickets
Speaker(s):
- Brian Larson
Track and Room: PreCon1 - Room 373
Title: Getting Started with Extended Events
Abstract: Few subjects in Microsoft SQL Server inspire the same amount of Fear, Uncertainty, and Doubt (FUD) as Extended Events. Many DBA’s continue to use Profiler and SQL Trace even though they have been deprecated for years. Why is this?
Extended Events started out in SQL Server 2008 with no user interface and only a few voices in the community documenting the features as they found them. Since then it has blossomed into a full feature of SQL Server and an amazingly low-impact replacement for Profiler and Trace.
Come learn how to get started - the basics of sessions, events, actions, targets, packages, and more. We will look at some base scenarios where Extended Events can be very useful as well as considering a few gotchas along the way. You may never go back to Profiler again!
Speaker(s):
- Andy Galbraith
Track and Room: Enterprise Database Administration Deployment - Room 373
Title: The Power of Data: The Complete Beginners Data Warehouse Kit
Abstract: For many of us data is scattered in many different systems. We almost all have data that someone wants to compare or track but can’t without a lot of manual manipulation. So, how do you tie disparate systems together? With a Data Warehouse! In this presentation you will get the skills you need to start building your own. We will discuss the basics of what a Data Warehouse is, the tools needed to create, deploy and manage the Data Warehouse process, and the benefits of using the data you collect to manage operational processes and create data visualizations. After attending this session you will be able to return to your job and amaze people with your ability to show them the power of the data!
Speaker(s):
- Leslie Andrews
Track and Room: BI Platform Architecture, Development Administration - Room 373
Title: SQL Server Tools for Query Tuning (Pre-Con)
Abstract: Query tuning within SQL Server can be a tough skill to master. The new tooling released with SQL Server 2016 and 2017 changes how you identify poorly performing queries, troubleshoot their behavior and tune the queries, all a little easier.
This workshop teaches new techniques for tuning queries using all the new tools introduced in SQL Server 2016 and 2017. You’ll be able to put this knowledge to work immediately, not only in your 2016 or better instances but also in your Azure SQL Database databases. You will be tuning your queries faster and more accurately using the new tools available.
Register here: https://www.eventbrite.com/e/sqlsaturday-sioux-falls-pre-conference-tickets-45947239430?aff=utm_source%3Deb_email%26utm_medium%3Demail%26utm_campaign%3Dnew_event_emailutm_term=eventname_text#tickets
Speaker(s):
- Grant Fritchey
Track and Room: PreCon3 - Room 374
Title: Data Protection Privacy in the World of Database DevOps
Abstract: Ensuring the ongoing protection of personally identifiable information is mandatory in today’s business, helping you to guard against data breaches, and comply with the GDPR. In a climate where cyber attacks are all too frequent, and data is spread across a growing number of different environments, the challenge of protecting your data can seem daunting. This session will address the implications of the GDPR on database management, and demonstrate a privacy-first approach to controlling and protecting data as it changes and moves through your SQL Server estate. As well as offering guidance for assessing your data estate for GDPR readiness, this session will include some great tools and tips for building data protection and privacy into your development processes, and dispel the myth that database DevOps and compliance can’t go hand in hand. With the right preparation, you can build compliance into your processes, keep sensitive data safe, and deliver value quickly to your end users.
Speaker(s):
- Grant Fritchey
Track and Room: Enterprise Database Administration Deployment - Room 374
Title: The Case for Change: Identifying and Remedying Bad Code
Abstract: There is no organization that is immune from performance issues with their SQL Server queries. Sometimes all it takes is one “perfect storm” that kills your server performance and lands you in the hot seat with everyone asking you what happened. While many performance issues can be addressed with an index or configuration change, what about when the root of the problem is the code itself? Whether it’s a stored procedure or dynamic T-SQL generated by an ORM, the burden of proof lies with the DBA to demonstrate how the code is negatively impacting performance.
How do you capture those bad queries? When you have this data what do you look at besides the query itself? How do you make the case to the business that a code change is necessary? In this session we will explore capturing and identifying those problem queries, the analysis of the performance data, and how to effectively communicate your findings to the business to get your proposed code change approved and implemented.
Speaker(s):
- Amy Herold
Track and Room: Enterprise Database Administration Deployment - Room 373
Title: DAX 201
Abstract: All Power BI models have date components. In this session, we’ll be talking about how to optimize time intelligence functions in DAX, like Year-To-Date, Same Period Last year, etc. We’ll review building DAX tables and the use of variables to assist.
Speaker(s):
- Belinda Allen
Track and Room: BI Platform Architecture, Development Administration - Room 116
Title: SQL Server Databases in the Clouds
Abstract: Application servers or services running on a cloud platform now have many options for their database engines. We discuss the various alternatives for providing Microsoft SQL Server services to cloud-based applications, including Microsoft Azure, Amazon AWS, and Google GCE, and multiple options within those environments. Why would you choose one approach over the other? What are the trade-offs on cost, performance, availability, security, ongoing maintenance, required skill sets, etc.
Speaker(s):
- Tim Plas
Track and Room: Enterprise Database Administration Deployment - Room 114
Title: Let’s Explore SQL Internals
Abstract: Have you ever wondered how SQL Server stores your data? With so many ways that it can be done, we couldn’t possibly cover everything in this session, but we’ll discuss the fundamental building blocks that SQL uses to organize data into usable units. We’ll also see how we can peek under the covers to actually view some of the strutures involved. Why? Because understanding how the pieces fit together will help you to design better, more efficient databases and tables, as well as providing knowledge of a critical component of how the SQL optimizer comes up with query plans.
Speaker(s):
- Brian Hansen
Track and Room: Enterprise Database Administration Deployment - Room 114
Title: Decoder ring not needed
Abstract: Data privacy has never been more relevant than the last few months. Are you doing all you can to protect your data? In this session we will look at different methods to encrypt data and what those methods protect against as well as what they do not protect. I will also demonstrate enabling Transparent Data Encryption (TDE) and column level encryption along with how to encrypt and decrypt your data….no decoder ring needed.
Speaker(s):
- Marcus Hopfinger
Track and Room: Enterprise Database Administration Deployment - Room 114
Title: An (Advanced) Introduction to Dax
Abstract: Coming from the Excel world, DAX can look like Excel formulas on steroids. However, to be successful with DAX and Powerpivot, you’ll need a completely different mental model. In this introduction to DAX, we won’t spend too much time on the basics. Instead, we’ll focus the concepts that make DAX unique. This will help you avoid the stumbling blocks of working with DAX. We will cover calculated columns, measures, aggregations, filtering, and iterators.
Speaker(s):
- Eugene Meidinger
Track and Room: BI Information Delivery - Room 116
Title: Looking through the Windshield: Forward-looking Dashboards KPIs
Abstract: It is dangerous to drive forward while looking through the rear window. The same is true about guiding our organizations forward while looking only at the past. Yet, much of our BI shows only the past. This session explores simple techniques to make our dashboards and KPIs visualize what is likely in the future. No fancy predictive algorithms are necessary – just an appreciation of what we know about our organization’s future and a recognition of past trends that are likely to continue. Examples are provided in Power BI, SSRS Paginated Report and SSRS Mobile reports.
Speaker(s):
- Brian Larson
Track and Room: BI Information Delivery - Room 116
Title: Intro to Powershell for the SQL Server DBA
Abstract: Many DBA’s have the same outlook on Powershell - we all know we should use it, but we don’t think we have time to learn one more tool that isn’t even really part of SQL Server anyway. I was one of these DBA’s for many years, but recently I have come to respect the power of Powershell. Come learn the basics of Powershell, how Powershell and SQL Server interact with each other, and finally how to use Powershell to automate common SQL Server tasks such as maintenance and SQL Server installations. If you need to interact with Windows or Active Directory, odds are Powershell is the right tool for the job - come learn how to use it!
Speaker(s):
- Andy Galbraith
Track and Room: Enterprise Database Administration Deployment - Room 114
Title: The Fast Track to Database Performance
Abstract: The Fast Track to Database Performance will give you a guaranteed maximum return with the least amount of overhead, aka Time! Who has time to go into the bits and bytes of all these SQL Server details! In my 5 years as a DBA I have seen some “interesting” implementations on SQL Server. In this session we will quickly cover the concepts in Database Design, Query Tuning/Performance and T-SQL Killers!
Speaker(s):
- Eric Swiggum
Track and Room: Application Database Development - Room 374
Title: JSON for the Data Mortals
Abstract: Do you see curly brackets stored in your database and wonder what that is? Are you a DBA, with developers storing JSON in your database? As a database administrator or developer, it’s important to understand JSON today. This session will explain what JSON is, where it came from, and why it is showing up all over the place. When you leave this session you will understand how to investigate, manipulate, and validate JSON in your database. You will walk away with example code of how to use Microsoft’s additions to SQL Server to use this data.
Speaker(s):
- Jim Dorame
Track and Room: Application Database Development - Room 374
Title: Difficult Queries
Abstract: Take your T-SQL skills to the next level. Regardless of your current level there will be something here you’ll be glad you didn’t miss. Basics like avoiding cursors in iterative tasks and multi-database executions are the tip of the iceberg. If queries are basic arithmetic then this is basic algebra. First we see how coding style affects maintainability then dive into several types of encapsulation, parameterization and tricks with values, cross apply, pivot and more .
Speaker(s):
- Rick Bielawski
Track and Room: Application Database Development - Room 374
Title: Mom Rules for Managing Enterprise Database Environments
Abstract: Have you ever looked at an environment and wondered how the heck they ever got anything done because it is so disorganized? The first thing I do for newly inherited environments is implement some organization and do some database clean up. Not only does organization make the environment easier to maintain, it can help speed up trouble shooting. Good organization can even help with some performance issues.
Speaker(s):
- Marsha Pierce
Track and Room: Enterprise Database Administration Deployment - Room 114
Title: Dynamic SQL: Tables / Parameters DBA Tools
Abstract: Dynamic SQL for the Developer DBA. In this class we will learn how to use Dynamic SQL on a day to day basis. Building Dynamic Tables from a wide variety of parameters passed into your query; Building Dynamic Column headers for those tables and using Pivot to display the results into a grid format. We will also explore passing parameters into and out of your SQL Query, creating dynamic search strings, and creating multiple databases, table structures using cross database scripting and Dynamic SQL.
Speaker(s):
- Steven Tidwell
Track and Room: Application Database Development - Room 374
Title: Data Cleansing With SQL And R
Abstract: On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and correcting data. In this session, we will look at different data cleansing and preparation techniques using both SQL Server and R. We will investigate the concept of tidy data and see how we can use tools in both languages to simplify research and analysis of a small but realistic data set.
Speaker(s):
- Kevin Feasel
Track and Room: Analytics and Visualization - Room 116
Title: An introduction to the magical world of BIML!
Abstract: Ever feel like you are just doing busy work while creating new SSIS packages? Feel like you are doing the same thing over and over while changing the names to protect the innocent? Ever wonder if there is a better way? Well wonder no more. Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors. Come with intrigue and leave with a fundamental understanding of BIML!
Speaker(s):
- Jonathan Stewart
Track and Room: BI Platform Architecture, Development Administration - Room 373
Title: Learn History from Temporal Tables
Abstract: SQL Server 2016 came out with a bucket full of cool new features. One of them is Temporal Tables. SQL Server 2017 made some enhancements in this area. Temporal tables are basically history tables of the normal tables; that allows us to retrieve data from any point in time for every change such as updates and deletes. It does this all without any change to application code. In this session, we will see what the requirements of creating temporal tables are. We will see the demo on insert and update functionality and how to query historical information using new TSQL clause. We will touch upon retention of history as well. It has lots of demos and less theory.
Speaker(s):
- Ameena Lalani
Track and Room: Enterprise Database Administration Deployment - Room 114
Title: Maximizing SQL Server Management Studio for Developers and DBAs
Abstract: Whether you’re a developer or a DBA, you likely use SSMS (SQL Server Management Studio) a lot. However, are you using all the features and extensions available to maximize your efficiency? This talk will show some of the most useful, yet overlooked, features of SSMS and some of the best (and free) extensions to make life easier for you and your teams. I’ll also include some of my most useful code snippets that I’ve found or written over the years. Save yourself some time and headaches!
Demos will include the latest version of SSMS and the new SQL Operations Studio.
Speaker(s):
- Nem Schlecht
Track and Room: Application Database Development - Room 374
Title: Power BI Deployment:Scaling from 5 to 5000
Abstract: With Power BI, hitting publish is just a click away. But what do you do when you want to share with your team, your company, or the whole world? In this presentation, we cover all of the different ways to deploy and share Power BI reports. We’ll start with sharing dashboards and work our way up to newer options like Power BI Premium and Power BI Embedded. By the end of this session, you’ll have an idea of the best deployment method for you.
Speaker(s):
- Eugene Meidinger
Track and Room: BI Platform Architecture, Development Administration - Room 116
Title: Getting Started with Power Query
Abstract: This session will highlight the core fundamentals of Power Query and how it can transform your efforts relating to Business Intelligence. Together we will talk about what it is, how it works, and how you can put it to good hard use in your organization. Power Query is a powerful tool that can help do the dirty work for you! It’s easy to learn and get started! Whether you want to use large complex datasets for Excel, Power BI or Power Pivot, Power Query is definitely a tool to help get you where you want to be!
Speaker(s):
- Shawn Dorward
Track and Room: Advanced Analysis Techniques - Room 116
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Brian Larson
Twitter: - @Brian_Larson
LinkedIn: Brian Larson
Contact: http://sqlmag.com/author/brian-larson
Brian Larson is Chief Creative Officer/Partner at Superior Consulting Services and has presented at SQL Server Connections, PASS Summit, and the Microsoft BI Conference. As a consultant to Microsoft, Brian contributed to the original code base of Reporting Services. Brian is the author of “Microsoft SQL Server 2016 Reporting Services: 5th Edition” and “Delivering Business Intelligence with SQL Server 2016: 4th Edition”, as well as the forthcoming “Data Analysis with Microsoft Power BI.”
Amy Herold
Twitter: - @texasamy
LinkedIn: Amy Herold
Contact: http://www.sqlkitten.com/
Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQLSaturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.
Marsha Pierce
Twitter: - MarshaPierceDBA
LinkedIn: Marsha Pierce
Marsha Pierce lives in Nashville, TN. She studied Computer Science, Mathematics, and French at Belmont University. She has 23 years of experience as a DBA, which means she has broken and fixed a lot of stuff. Before joining Pure Storage, she was an architect at HCA and Asurion. She is passionate about DevOps, Storage, Performance Tuning, and Standardization.
Leslie Andrews
Twitter: - landrews5807
LinkedIn: Leslie Andrews
Contact: https://www.lace.technology/blog
Leslie Andrews is an IT professional with almost 20 years of experience working with databases, designing databases, as well as designing and developing applications against those databases. 2018-2019 Idera ACE.
Steven Tidwell
Twitter: - @SQLCodeMonkey
LinkedIn: Steven Tidwell
Contact: https://www.sqlcodemonkey.com
I am currently the Technical Lead for Client custom projects. I have been writing SQL Code starting in SQL 7. Over the years I have put on many hats, DBA, Developer, Web Developer, C#, VB.NET, Cold Fusion and Java. But at the end of the day, I prefer to write SQL. Local Chapter Leader for the South Montgomery County SQL Server User Group in Montgomery County, Texas.
Grant Fritchey
Twitter: - @gfritchey
LinkedIn: Grant Fritchey
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
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.
Shawn Dorward
Twitter: - https://twitter.com/ShawnMDorward
LinkedIn: Shawn Dorward
Contact: https://gplifehacks.com/
Shawn Dorward, a Microsoft MVP for Business Solutions, is a business and technology professional focusing on efficiencies and maximizing the return on technology investments. After using Dynamics GP for nearly 15 years as an end user, Shawn found himself better serving the Dynamics Community as a consultant.
Shawn is the Dynamics GP Practice Lead at InterDyn Artis, headquartered in Charlotte, NC where he focuses on building relationships and helping businesses deepen their skill sets by learning more and more about their ERP.
Very active in the GP User Group (GPUG), Shawn serves proudly as a GPUG Allstar and can often be found presenting at community events around the US and online.
Mike Byrd
Twitter: - ByrdNest_TX
LinkedIn: Mike Byrd
Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com
Former rocket scientist and USAF Fighter Pilot – now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies.
Presenter at many SQLSaturdays over last 6 years in United States, Europe, and Australia.
Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).
Video presentations (for local SQL Server user groups or SQLSaturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd
Grant Fritchey
Twitter: - @gfritchey
LinkedIn: Grant Fritchey
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
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.
Eugene Meidinger
Twitter: - @sqlgene
Contact: http://www.sqlgene.com
Eugene Meidinger works as a BI consultant and full time Pluralsight author. He currently focuses on content on Power BI and related products. He also leads the Pittsburgh Power BI User Group. He is certified in querying and administering SQL Server.
Rick Bielawski
LinkedIn: Rick Bielawski
Rick has 35 years experience as a systems, applications and database architect having designed major systems for such institutions as NASDAQ, Bank of America, Blue Cross Blue Shield, Ecolab and Emperex. He holds multiple certifications including MCITP and MCSE in Business Intelligence and Data Platform. Rick currently designs database systems for custom software applications and likes speaking at local user groups and SQLSaturday events.
Eugene Meidinger
Twitter: - @sqlgene
Contact: http://www.sqlgene.com
Eugene Meidinger works as a BI consultant and full time Pluralsight author. He currently focuses on content on Power BI and related products. He also leads the Pittsburgh Power BI User Group. He is certified in querying and administering SQL Server.
Brian Larson
Twitter: - @Brian_Larson
LinkedIn: Brian Larson
Contact: http://sqlmag.com/author/brian-larson
Brian Larson is Chief Creative Officer/Partner at Superior Consulting Services and has presented at SQL Server Connections, PASS Summit, and the Microsoft BI Conference. As a consultant to Microsoft, Brian contributed to the original code base of Reporting Services. Brian is the author of “Microsoft SQL Server 2016 Reporting Services: 5th Edition” and “Delivering Business Intelligence with SQL Server 2016: 4th Edition”, as well as the forthcoming “Data Analysis with Microsoft Power BI.”
Nem Schlecht
Twitter: - nemws1
I’ve been a Server Administrator and DBA for 20+ years and have worked with multiple operating systems (UNIX variants, Mac OS X and Windows) and database engines (MySQL/MariaDB, Oracle, PostgreSQL, SQLite, and MSSQL). I currently work a lot with PowerShell and automation as well as supervising a group of awesome systems administrators. I’ve worked for a large state university system, a start-up company, and everything in-between (including my own consulting company). I currently work for Border States Electric as an I.T. Supervisor.
Belinda Allen
Twitter: - MsBelindaAllen
LinkedIn: Belinda Allen
Contact: http://www.BIBelinda.com
Belinda Allen is a (Power BI) Data Platform Microsoft Most Valuable Professional (MVP).
Belinda has just completed her second book, Building Dashboards with Microsoft Dynamics GP 2016 - Second Edition.
Belinda is also an inaugural member of the Board of Advisors for PBIUG (Power BI User Group.)
Belinda is also well known for her blog, www.BelindaTheGPcsi.com. On her blog, she shares really useful information about the product quickly and succinctly. With followers from all over the globe, she can share knowledge and achieve her mission: “To improve the lives and business success of my followers.”
Tim Plas
Twitter: - tjplas
LinkedIn: Tim Plas
Tim is a Principal Consultant at Virteva, in Mpls MN. His current focus areas are cloud architecture / engineering / migration, operational-DBA services (esp. HA/DR), server migrations, server virtualization, and storage. His experience over the past 25+ years has been primarily with server / data-center infrastructure, including being CTO / co-founder of a successful hosting company. Tim has held a variety of MS certifications since 1994.
Jonathan Stewart
Twitter: - sqllocks
LinkedIn: Jonathan Stewart
Contact: https://sqllocks.net/
Jonathan Stewart is a Business Intelligence consultant specializing in data visualization, data warehousing, and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments.
Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and Business Intelligence at numerous SQLSaturday events, local user groups, and conferences throughout the United States and around the world. He participates in webcasts, podcasts, and on
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.
Grant Fritchey
Twitter: - @gfritchey
LinkedIn: Grant Fritchey
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
Marcus Hopfinger
Twitter: - DakotaDataWrang
LinkedIn: Marcus Hopfinger
Contact: http://dakotadatawrangler.blogspot.com/
Marcus has been with Daktronics, Inc. since 2001 where he started doing ColdFusion development and some SQL Server 7 database administration. In late 2003 he was activated and deployed in early 2004 to Iraq with the South Dakota Army National Guard. During this time, he served as a Battalion Communications Officer where he was responsible for redundant voice and data networks including satellite internet and secure internet routing protocol networks. Upon returning to Daktronics in 2005 he moved in into a fulltime database administration position where he gets to work on SQL Server instances on three continents. He is also a Sci-Fi Fan, History buff, Amateur Radio Operator (call sign KA0SQL), but most importantly husband and father.
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.
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.
Kevin Feasel
Twitter: - feaselkl
LinkedIn: Kevin Feasel
Contact: http://www.catallaxyservices.com
Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.
Eric Swiggum
Twitter: - eric_swiggum
LinkedIn: Eric Swiggum
Contact: http://www.ericswiggum.com
Microsoft SQL Server Database Administrator for over 6 years with a focus in database performance/query tuning. I’ve been in the IT field for over a decade with prior experience in Oracle Database Administration ETL Administration. I have developed on various RDBMS platforms including but not limited to: Oracle, IBM DB2 Teradata.
Sponsors
The following is a list of sponsors that helped fund the event: