SQLSaturday #767 - Lincoln 2018
Event Date: 10/27/2018 00:00:00
Event Location:
- Peter Kiewit Lodge
- 28500 W Park Hwy
- Ashland, Nebraska
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: Reducing The Surface Area Of Risk in Data Security
Abstract: Data obfuscation, also known as data masking, is soon a legal requirement. Data masking is the best way to secure non-production systems (i.e. DEV, TEST, etc) to greatly reduce the surface area of risk for data breach in your organization. Masking isn’t encryption, which is an appropriate solution for production applications. Masking also isn’t just a SQL Server feature, it is a technique common across databases.
Data masking for data at-rest removes the value from the asset. This reduces your organizations “surface area of risk” overall, permitting your organization to prioritize security efforts where they are absolutely needed. There are other possible solutions, such as synthesizing data and redaction, which present other challenges.
Come learn about the right way to secure non-production data to limit exposure only to production. Learn what techniques can be used, why, and what factors should be considered when deciding to secure confidential data.
Speaker(s):
- Tim Gorman
Track and Room: Enterprise Database Administration Deployment - Cottonwood Room - 900
Title: Shiny, SSAS Tabular Model Developed from a Star Schema
Abstract: A deep dive into a Tabular Model developed from a Star Schema. We review different levels of normalization versus de-normalization. We examine how all relationships require a M:1 cardinality that is joined on a pair of single columns. We will clarify that models cannot include model ambiguity. “Live” Demos using Power Pivot and Power BI • Integrated workspace / server workspace • Data connections (impersonation) • Import tables into the tabular model • Date Dimension for Time Intelligence • Relationships between facts and dimensions • DAX to create measures and calculated tables • Ragged Hierarchies • Detail Rows Expression Property for Measures • Project deployment and processing • Best practices and what to avoid • Dimensions, facts, and reference tables (parameters) • Bridge table and M:M relationships • Bi-directional filtering versus cross-filtering • DAX Expanded Tables • Filter context and DAX
Speaker(s):
- Ryan Casey
Track and Room: BI Platform Architecture, Development Administration - Blue Agate Room - 500
Title: Using Kafka for Real-Time Data Ingestion with .NET
Abstract: Remember that first time you saw Service Broker and thought of all the great things you could do with it? Remember when you actually tried Service Broker and found all the limitations and pain points? Enter Apache Kafka. Apache Kafka is a distributed publish-subscribe messaging system which can scale out to handle millions of messages per second and support a distributed, microservices-oriented architecture. In this talk, we will cover the basics of this powerful system, including general architectural and design principles. We will also build a .NET project which uses Kafka to produce and consume messages quickly and efficiently.
Speaker(s):
- Kevin Feasel
Track and Room: Application Database Development - Blue Agate Room - 500
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 - Goldenrod Room - 700
Title: Taking the pain out of database migrations
Abstract: Database migrations are scary. The migration of a database has many moving pieces and things to think about. Some of those things have nothing to do with the DBA and are outside of their control. However, if these items are not taken into account, it is the DBA that management will hold responsible for the failure.
This session will discuss what you need to take into account to ensure a successful pain free database migration. These steps can be used for a single database, multiple databases, or an entire server. By the end of the session, you will have a checklist of the items you need to consider for a database migration.
Speaker(s):
- Chris Lumnah
Track and Room: Enterprise Database Administration Deployment - Blue Agate Room - 500
Title: Zen and the Art of Baselines
Abstract: If your boss asked you for the list of the five most CPU-hungry databases in your environment six months from now for an upcoming licensing review, could you come up with an answer? Performance data can be overwhelming, but this session can help you make sense of the mess. Twisting your brain and looking at the data in different ways can help you identify resource bottlenecks that are limiting your SQL Server performance today. Painting a clear picture of what your servers should be doing can help alert you when something is abnormal. Trending this data over time will help you project how much resource consumption you will have months away. Come learn how to extract meaning from your performance trends and how to use it to proactively manage the resource consumption from your SQL Servers.
Speaker(s):
- David Klee
Track and Room: Enterprise Database Administration Deployment - Red Oak Room - 220
Title: Monster Text Manipulation: Regular Expressions for the DBA
Abstract: Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures filled with table variables instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cuts that work from hours to seconds. I use regular expressions all the time and I have taken many tasks down from several days to just a few minutes. Stop writing code manually and let regular expressions do it for you. Here you’ll learn: • The most useful regular expression commands. • The appropriate times to use regular expressions. • How to use regular expressions to write code for you. • How to incorporate regular expressions into large tasks and combine them with other methods.
Speaker(s):
- Sean McCown
Track and Room: Enterprise Database Administration Deployment - Red Oak Room - 220
Title: Beginning Admin: The Care and Feeding of SQL Server
Abstract: Design and development may be exciting, but database administration is absolutely critical (and, reasonably well-paying!) The care and feeding of a server tends to get short-changed or neglected. In this class, we’ll cover the basics of the big five administrator tasks:
- Backups – You must set up regular backups, to keep copies of your databases…just in case something breaks, or someone makes a bad, bad mistake.
- Integrity checks – Regularly and automatically check databases for corruption, which is when bits get scrambled, lost, and ruined.
- Index maintenance – Databases need regular upkeep so they’ll continue to run well.
- Disk management – It’s actually your job to find out about full disks before they happen. After all, databases grow!
- Alerting – Alerts tell you what’s wrong, so you don’t have to go looking for problems.
Being a database administrator is a big job, but we can cover the basics in one session!
Speaker(s):
- Jennifer McCown
Track and Room: Enterprise Database Administration Deployment - Nebraska Room - 200
Title: Why should I care about … the plan cache?
Abstract: SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this installment of Rick’s “Why should I care” series, he lays out a case for why working knowledge of the plan cache is critical for performance tuning efforts in real world environments. A review of relevant views and functions is included for the (newly?) motivated audience.
Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs often seem so frazzled. This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.
Speaker(s):
- Rick Lowe
Track and Room: Enterprise Database Administration Deployment - Blue Agate Room - 500
Title: How to Keep Your Databases Secure in Just Minutes a Day
Abstract: You’re busy. You don’t have time to check the security of your systems all the time, right? It’s not like anyone has added a user that you don’t know about. And no one would create a database and add all logins to the db_owner role. And of course, no one would ever think of setting the TRUSTWORTHY property on a database… right?
Things like that happen on a daily basis, poking holes in even the most well-secured database. Those holes are just waiting for someone to find them. That someone could be you, or it could be an attacker probing for a way to get data from your company.
In this session, we will explore how to create reports that are quick to review so you can find the holes before someone else does - without interfering with the rest of your day. Along the way, you’ll also learn where to find security-related information in SQL Server’s metadata and logs to allow you to customize and extend the reports to meet your company’s unique needs.
Speaker(s):
- Ed Leighton-Dick
Track and Room: Enterprise Database Administration Deployment - Cedar Room - 230
Title: T-SQL’s Hidden Support Feature
Abstract: The most effective T-SQL support feature comes installed with every edition of SQL Server, is enabled by default, and costs no overhead. Yet, the vast majority of database administrator underutilize or completely neglect it. That feature’s name is “comments”.
In this session, Microsoft Certified Master Jennifer McCown will demonstrate the various commenting methods that make code supportable. Attendees will#160;learn what’s important in a header comment, use code blocking to edit code, build a comprehensive help system, and explore alternative comment methods in stored procedures, SSIS packages, SSRS reports, and beyond. These methods help prevent errors and reduce troubleshooting.
Speaker(s):
- Jennifer McCown
Track and Room: Application Database Development - Cedar Room - 230
Title: Processing Analysis Services Tabular Models
Abstract: For large in-memory Analysis Services Tabular models, the design of table partitions and the scheduled refresh/processing operations has significant implications for query performance, resource utilization, processing duration, and database availability. This session will review the tabular model’s processing operation types, design decisions such as parallelism and transactions, and provide examples of Tabular Model Scripting Language (TMSL) scripts and PowerShell scripts used to support the processing of Tabular models. Additionally, common Azure and on-premises job automation and orchestration tools used in the processing of Tabular models will be demonstrated including Azure Automation, SQL Server Agent, and SSIS.
Speaker(s):
- Brett Powell
Track and Room: BI Platform Architecture, Development Administration - Cottonwood Room - 900
Title: Analysis Services is in Azure? Seriously!? Let’s build a model!
Abstract: Have you used SSAS before? Have you created reports using T-SQL and Group by? Are you interested in or currently using Power BI? Do you you have a need for Analysis Services but don’t want to have to deal with the hassle of buying and installing a server? Are you dreading having to upgrade your hardware for your current SSAS Tabular instance? Is your organization using Office 365? If you answered yes to any of these questions, you might need Azure Analysis Services. The wait is over! Azure Analysis Services is the platform as a service version of the wildly popular Analysis Services Tabular product.
This demo heavy session will be focused on setting up Azure Analysis Services, deploying a model, loading the model with data and finally reporting from your Azure Analysis Services instance.
Speaker(s):
- Phillip Labry
Track and Room: Cloud Application Development Deployment - Goldenrod Room - 700
Title: Temporal Tables – The New Hotness in Data Auditing
Abstract: A common issue database administrators face is data auditing. Many use triggers, CDC, third-party tools, or roll their own type of auditing tool. In SQL Server 2016, a new feature called Temporal Tables was introduced and helps to simplify this common need. In this session, we will take a look at what temporal tables are, how they work and how you can implement them into your environment.
Speaker(s):
- John Morehouse
Track and Room: Application Database Development - Cedar Room - 230
Title: Understanding SQL Server Always Encrypted
Abstract: Always Encrypted is a highly-touted feature of SQL Server 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 - Nebraska Room - 200
Title: Level Up Your Cloud Skills
Abstract: Think infrastructure in the cloud is still just for sysadmins? Think again! As your organization moves into the cloud, infrastructure architecture skills are more important than ever for DBAs to master. Expert knowledge of cloud-related infrastructure will help you maintain performance and availability for databases in the cloud. For example, know what an IOP is? Should you use a database-as-a-service or provision a cloud-based VM? How many compute resources does your database consume during a given day? Can you secure it properly? Come learn many of the key cloud infrastructure points that you should master as the DBA role continues to evolve!
Speaker(s):
- David Klee
Track and Room: Enterprise Database Administration Deployment - Nebraska Room - 200
Title: SQL Server on Amazon Web Services - Elastic Compute Cloud vs Relational Database Service?
Abstract: Amazon web services offers a befuddling number of of different services. Among these are the two major options for running SQL Server on AWS - Elastic Compute Cloud and Relational Database Services. Why would one be picked over the other? What are the limitations and trade offs? We will discuss these questions among others while working through the process of restoring a sample database under both services.
Speaker(s):
- Rick Lowe
Track and Room: Cloud Application Development Deployment - Red Oak Room - 220
Title: SELECT Tidbits FROM My.Experience WHERE NiceToKnow = 1 and date = DATEADD(D,-1,current_timestamp)
Abstract: This is not a class about how to pass a test, or make a pretty report. This is a guy with 20+ years of experience telling you some things that he wished he would have known when he was young.
Speaker(s):
- B.D. Softley
Track and Room: Professional Development - Cottonwood Room - 900
Title: I’m It - Survival Techniques for the Lone DBA
Abstract: Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We’ll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you’ll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.
Speaker(s):
- Monica Rathbun
Track and Room: Professional Development - Red Oak Room - 220
Title: Azure Basics for the DBA
Abstract: It’s not a question of whether or not the landscape for the common DBA is changing. Without a doubt, it is. Azure offers up a new world of possibilities for DBA’s and we should all strive to learn it. In this session, we’ll cover some basic knowledge and terminology of Azure as well as how easy it is to incorporate Azure into your environment. We will stand up a new Azure virtual machine as well as a setup SQL DB. You will see how easy it is to accomplish this. This new-found knowledge will help propel your career into the new landscape.
Speaker(s):
- John Morehouse
Track and Room: Cloud Application Development Deployment - Red Oak Room - 220
Title: Data Breach 101 - Legal and IT Responses
Abstract: Data breaches are now a when, not an if. Yet despite years of reading about data breaches in the news, very few companies are ready to weather the storm. This course will provide a general primer on data breach incident response and the parallels between the IT and Legal response cycles. At the end of this course, you will have the baseline knowledge of data breach responses and legal aspects your company needs to know.
Speaker(s):
- Wm Bruce Wray
Track and Room: Security - Cottonwood Room - 900
Title: APPLY Yourself
Abstract: Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.
Speaker(s):
- Kevin Feasel
Track and Room: Application Database Development - Goldenrod Room - 700
Title: Implementing a Cloud Analytics Solution: Options, costs and more
Abstract: If you’ve looked at the cloud, you’ve realized the large number of options you have to implement a complete cloud analytics solution. You have the ability to deploy dashboards, data ingestion and integration and advanced analytics to the cloud that will empower data-driven decisions for your organizations. This talk will discuss and review options you have to run Cloud Analytic Solutions from the three major cloud providers – AWS, Azure and Google Cloud Platform.
Speaker(s):
- Marc Beacom
Track and Room: BI Platform Architecture, Development Administration - Goldenrod Room - 700
Title: Husker Power BI
Abstract: In this session a sample database of athletic performance and wellness is leveraged to deliver insights and analytical capabilities via Power BI. A robust data model, advanced DAX metrics, rich data visualizations, and distribution capabilities in the Power BI web service such as data alerts and email subscriptions all contribute to the overall solution designed to answer top questions such as “Which athletes are making the greatest gains?” and to identify exceptions and trends.
Speaker(s):
- Brett Powell
Track and Room: BI Information Delivery - Blue Agate Room - 500
Title: Remember Back When? Temporal Tables in SQL Server 2016 and 2017
Abstract: SQL Server 2016 and 2017 come with their own version of a Wayback Machine: temporal tables. With this new feature, it is easy to store and query the history of changes to data. We will discuss the fundamentals and creating, storing data in, querying from, and maintaining these tables. We will also take a quick look under the hood to see how they work. And yes, this is a version 1 (and 2) product, so we’ll also consider the current limitations that are in place. Find out how temporal tables can benefit your system!
Speaker(s):
- Brian Hansen
Track and Room: Application Database Development - Cedar Room - 230
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 - Cedar Room - 230
Title: How to Get SQL Server to Run Better on Crappy Hardware.
Abstract: Many of us have to deal with hardware that doesn’t meet our standards or contributes to performance problems. This session will cover how to work around hardware issues when it isn’t in the budget for newer, faster, stronger, better hardware. It’s time to make that existing hardware work for us. Learn tips and tricks on how to reduce IO, relieve memory pressure, and reduce blocking. Let’s see how compression, statistics, and indexes bring new life into your existing hardware.
Speaker(s):
- Monica Rathbun
Track and Room: Enterprise Database Administration Deployment - Cottonwood Room - 900
Title: What’s new for Developers - SQL Server 2014-2017
Abstract: Have you been too busy to explore the new developer features in 2014+? This session is for you! We’re going to work through solving problems more effectively using the new capabilities built into SQL Server.
Topics covered will include JSON, string splitting and aggregation, data masking, row level security, graph processing, and too many “minor” features to mention.
Speaker(s):
- Bill Fellows
Track and Room: Application Database Development - Nebraska Room - 200
Title: Loading SQL Server Data with Powershell
Abstract: Powershell has become the defacto standard for scripting Microsoft products. However, putting data in text files doesn’t scale. Here I’m going to show you the ins and outs of loading data into SQL Server using Powershell for the purpose of centralizing collections. We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting. This is a no holds barred session taught by an enterprise SQL Server scripting expert. You can’t afford to miss this session if you do any level of scripting in your shop.
Speaker(s):
- Sean McCown
Track and Room: Enterprise Database Administration Deployment - Nebraska Room - 200
Title: Statistics - Why are they there and what do I do with them
Abstract: In this session you will learn the basics of statistics and what they are used for. You will learn how to gather information about the statistics and how to use the information to improve performance. It is important the statistics are maintained to work properly. We will discuss what on going maintenance should be done on statistics.
Speaker(s):
- Dave Bland
Track and Room: Enterprise Database Administration Deployment - Goldenrod Room - 700
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
Monica Rathbun
Twitter: - SQLEspresso
LinkedIn: Monica Rathbun
Contact: http://www.sqlespresso.com
Monica Rathbun lives in Virginia, is a Microsoft MVP for Data Platform and Microsoft Certified Solutions Expert. She has nearly two decades of experience working with a wide variety of database platforms with a focus on SQL Server and the Microsoft Data Platform. She is a frequent speaker at IT industry conferences on topics including performance tuning and configuration management. She is the Leader of the Hampton Roads SQL Server User Group and a Mid‐Atlantic PASS Regional Mentor. She is passionate about SQL Server and the SQL Server community, doing anything she can to give back. Monica can always be found on Twitter (@sqlespresso) handing out helpful tips. You can find Monica blogging at sqlespresso.com
Bill Fellows
Twitter: - @billinkc
LinkedIn: Bill Fellows
Contact: http://blog.billfellows.net
Bill Fellows is a SQL Server MVP and has been a database developer for most of his career, with the past 15 years focused on ETL. He is the organizer of Kansas City’s eight SQLSaturdays and a speaker at many other SQLSaturdays, User Groups and the PASS Summit. Bill is the owner of Sterling Data Consulting where he gets to solve interesting data problems.
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.
Phillip Labry
Twitter: - @philliplabry
Contact: http://phillip.labry.com
Phillip Labry is a Senior BI Consultant and Trainer with over 20 years experience in SQL Server and over 30 in IT. He has been lucky enough to work on data projects spanning telecom, banking, retail, law enforcement, health care, insurance, financial services and energy sectors. As a national consultant he provides training and builds solutions utilizing the full MS BI stack. He is an active member of the Madison, WI PASS chapter and speaks at events in the USA and Canada.
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.
Marc Beacom
Twitter: - MarcBeacom
LinkedIn: Marc Beacom
Contact: https://datalere.com/author/marc-beacom/
Marc Beacom, Managing Partner at Datalere, leverages over two decades of experience to better the data landscape for clients, along with nearly a decade of building and managing productive teams. Marc has led architecture and developed data integration strategies for dozens of Colorado based companies and organizations. Marc maintains an active presence in the Colorado community by volunteering and serving on nonprofit boards, speaking and running user groups.
Wm Bruce Wray
LinkedIn: Wm Bruce Wray
Mr. Wray is Vendor Legal Counsel for an international payments company, handling complex procurement negotiation and focusing on technology and security related aspects of the vendor on-boarding and management processes. ISC^2 CISSP certified, with Masters’ Degrees in Mathematics and Computer Science, focused on Information Assurance. He worked prior as an associate at a national law firm, working within their Intellectual Property/Information Technology group. Prior to joining the legal profession, he worked for over a decade in the information technology field, focusing on development, database, and security, and taught as an adjunct professor, including courses in mathematics, computer science and information assurance.
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.
Monica Rathbun
Twitter: - SQLEspresso
LinkedIn: Monica Rathbun
Contact: http://www.sqlespresso.com
Monica Rathbun lives in Virginia, is a Microsoft MVP for Data Platform and Microsoft Certified Solutions Expert. She has nearly two decades of experience working with a wide variety of database platforms with a focus on SQL Server and the Microsoft Data Platform. She is a frequent speaker at IT industry conferences on topics including performance tuning and configuration management. She is the Leader of the Hampton Roads SQL Server User Group and a Mid‐Atlantic PASS Regional Mentor. She is passionate about SQL Server and the SQL Server community, doing anything she can to give back. Monica can always be found on Twitter (@sqlespresso) handing out helpful tips. You can find Monica blogging at sqlespresso.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.
Sean McCown
Twitter: - @KenpoDBA
Contact: http://www.midnightdba.com/dbarant
Sean McCown is a Certified Master with 23 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. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.
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
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.
Sean McCown
Twitter: - @KenpoDBA
Contact: http://www.midnightdba.com/dbarant
Sean McCown is a Certified Master with 23 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. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.
Tim Gorman
Twitter: - @TimGormanTech
LinkedIn: Tim Gorman
Contact: http://evdbt.com
Tim Gorman is a senior technical consultant for Delphix who securely enables masked data virtualization to increase the agility of IT development and testing while ending decades of security risk in SDLC.
Tim has co-authored six books on data warehousing and database administration, has performed technical review on eight more books, and has an author#39;s page on Amazon.com (http://www.amazon.com/Tim-Gorman/e/B00BKCTO5E).
John Morehouse
Twitter: - SQLrUs
LinkedIn: John Morehouse
Contact: http://www.sqlrus.com
John Morehouse is currently a Consultant with Denny Cherry Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member Community Ambassador, and 2016 Idera Ace. John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible. He is a user group leader, SQLSaturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQLSaturday’s as well as other conferences.
Ryan Casey
Twitter: - @AimYourData
LinkedIn: Ryan Casey
Contact: https://www.AimYourData.com/
Microsoft Data Platform MVP, Public Speaker, and Group Moderator
SQLSaturday Speaker @ • Houston, TX 2018 • Dallas, TX 2018, 2017 (BI), 2016, 2015 • Phoenix, AZ 2018, 2017 (BI) • Kansas City, MO 2017 • Baton Rouge, LA 2017 • Oklahoma City, OK 2016 • San Antonio, TX 2016
SQL User Group Speaker @ • NTSSUG, Dallas, TX • CACTUSS, Austin, TX • OKCSQL, Oklahoma City, OK • MSBIC, Dallas, TX • SALSSA, San Antonio, TX • FWSSUG, Fort Worth, TX
AIM Business Driven Data Solutions combines the collaborative and creative arts included in Technical Communication, the business acumen of a Harvard MBA program, and the technical discipline of object-oriented programming and business intelligence (data warehouses).
Jennifer McCown
Twitter: - http://www.Twitter.com/MidnightDBA
LinkedIn: Jennifer McCown
Contact: http://www.MidnightDBA.com/Jen
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 PASS, and the PASS Women in Technology Virtual Group.
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.
Chris Lumnah
Twitter: - @lumnah
LinkedIn: Chris Lumnah
Chris Lumnah began working in the IT as a programmer in 1996. He ended up becoming a SQL DBA out of necessity 15 years ago. He has worked on SQL Server version 2000 thru 2017. He likes to continue to use his knowledge of programming to create more automated solutions to assist him and his team to be more proactive. Chris lives in Providence, RI and is currently a SQL Server Solutions Architect at Rubrik Inc.
John Morehouse
Twitter: - SQLrUs
LinkedIn: John Morehouse
Contact: http://www.sqlrus.com
John Morehouse is currently a Consultant with Denny Cherry Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member Community Ambassador, and 2016 Idera Ace. John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible. He is a user group leader, SQLSaturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQLSaturday’s as well as other conferences.
Brett Powell
Twitter: - https://twitter.com/BrettPowell76
LinkedIn: Brett Powell
Contact: https://insightsquest.com/
Brett is the author of the Microsoft Power BI Cookbook, Mastering Power BI, and an active technical blogger on Insight Quest (https://insightsquest.com). Brett also owns Frontline Analytics, LLC, a data and analytics consulting firm specializing in the Microsoft data platform. Brett has held multiple BI and analytics roles within corporate analytics functions, BI/IT organizations, and as a consultant for Microsoft BI Partner firms. Outside of work Brett contributes to the Power BI Community and the Boston Business Intelligence User Group.
B.D. Softley
Twitter: - @BDSoftley
LinkedIn: B.D. Softley
Someone remind me to put something interesting here.
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.
Rick Lowe
Twitter: - DataFLowe
LinkedIn: Rick Lowe
Contact: http://dataflowe.wordpress.com/
Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated… eventually specializing more on performance issues than code.
Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.
Brett Powell
Twitter: - https://twitter.com/BrettPowell76
LinkedIn: Brett Powell
Contact: https://insightsquest.com/
Brett is the author of the Microsoft Power BI Cookbook, Mastering Power BI, and an active technical blogger on Insight Quest (https://insightsquest.com). Brett also owns Frontline Analytics, LLC, a data and analytics consulting firm specializing in the Microsoft data platform. Brett has held multiple BI and analytics roles within corporate analytics functions, BI/IT organizations, and as a consultant for Microsoft BI Partner firms. Outside of work Brett contributes to the Power BI Community and the Boston Business Intelligence User Group.
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.
Rick Lowe
Twitter: - DataFLowe
LinkedIn: Rick Lowe
Contact: http://dataflowe.wordpress.com/
Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated… eventually specializing more on performance issues than code.
Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.
Jennifer McCown
Twitter: - http://www.Twitter.com/MidnightDBA
LinkedIn: Jennifer McCown
Contact: http://www.MidnightDBA.com/Jen
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 PASS, and the PASS Women in Technology Virtual Group.
Sponsors
The following is a list of sponsors that helped fund the event: