SQLSaturday #619 - Rochester 2017
Event Date: 04/29/2017 00:00:00
Event Location:
- Rochester Institute of Technology
- 1 Lomb Memorial Drive
- Rochester, New York
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: Building Effective Backups
Abstract: There are few aspects of a database infrastructure that are as basic, yet as critical as backups. Determining an appropriate backup methodology and architecting a fitting solution for it is critical to data security and the ability to service emergency requests.
Time constraints often cause us to lean on maintenance plans or third party tools to handle backups for us, but having a full understanding of the necessary processes involved is critical to having backup and restore processes that will provide us with exactly what we want, when we need it.
This is an opportunity to create a backup solution from scratch that takes into account the most important aspects of a backup process and can easily be customized to fit the needs of any database environment.
Speaker(s):
- Edward Pollack
Track and Room: Enterprise Database Administration Deployment - 1610
Title: Big data architectures and the data lake
Abstract: With so many new technologies it can get confusing on the best approach to building a big data architecture. The data lake is a great new concept, usually built in Hadoop, but what exactly is it and how does it fit in? In this presentation I’ll discuss the four most common patterns in big data production implementations, the top-down vs bottoms-up approach to analytics, and how you can use a data lake and a RDBMS data warehouse together. We will go into detail on the characteristics of a data lake and its benefits, and how you still need to perform the same data governance tasks in a data lake as you do in a data warehouse. Come to this presentation to make sure your data lake does not turn into a data swamp!
Speaker(s):
- James Serra
Track and Room: Enterprise Database Administration Deployment - 1435
Title: Finding Islands, Gaps, and Clusters in Complex Data
Abstract: Being able to group data into logical and meaningful sets can be extremely useful. When the data involved is a non-repeating sequence of integers, grouping is not too difficult. Most real data, though, is made up of dates, times, decimals, and rarely can guarantee non-repeating, non-null data sets.
This is a fast-paced session that delves into methods that can be applied to any data. Want to know how many production incidents make up a single common problem? Can we track sales success by the number of consecutive weeks that an agent has exceeded their goal? How about the longest home run streak hit by Derek Jeter at night games on Tuesdays?
Discussion will include performance, CTEs, recursion, set-based vs. iterative analysis, and some pretty hairy TSQL!
Speaker(s):
- Edward Pollack
Track and Room: Application Database Development - 1435
Title: Learning to present and becoming good at it
Abstract: Have you been thinking about presenting at a user group? Are you being asked to present at your work? Is learning to present one of the keys to advancing your career? Or do you just think it would be fun to present but you are too nervous to try it? Well take the first step to becoming a presenter by attending this session and I will guide you through the process of learning to present and becoming good at it. It’s easier than you think! I am an introvert and was deathly afraid to speak in public. Now I love to present and it’s actually my main function in my job at Microsoft. I’ll share with you journey that lead me to speak at major conferences and the skills I learned along the way to become a good presenter and to get rid of the fear. You can do it!
Speaker(s):
- James Serra
Track and Room: Professional Development - 1445
Title: Architecting Availability Groups
Abstract: Are you a DBA familiar with some basic Windows clustering and database mirroring concepts, and now you’re considering AlwaysOn Availability Groups? This session is for you! I’ll cover the pros and cons of four typical configurations of AlwaysOn Availability Groups: stand-alone instances, fail-over cluster instances, multi-subnet configurations, and disaster-recovery-on-the-cheap. I’ll also discuss read-only routing, and implications and limitations of the Availability Group Listener. In addition, you’ll learn why you should be using Windows Server 2012 R2 or above for your Windows clusters. Join me to learn which configuration options you should choose for your Availability Group.
Speaker(s):
- Derik Hammer
Track and Room: Enterprise Database Administration Deployment - 1620
Title: Azure SQL Database for the DBA
Abstract: Everyone knows that Azure SQL Database only supports a small subset of SQL Server functionality, small databases, and has really bad performance. Except, everyone is wrong. In fact, Azure SQL Server Database is ready to support many, if not most, databases within your enterprise. This session reintroduces Azure SQL Database and shows the high degree of functionality and improved performance that is now available. We’ll cover topics from monitoring, to high availability to disaster recovery, all within Azure SQL Database. You’ll leave this session with a more thorough understanding of the strengths and weaknesses of Azure SQL Database so that you can make a more informed choice over when, or if, you should use it within your environment.
Speaker(s):
- Grant Fritchey
Track and Room: Enterprise Database Administration Deployment - 1610
Title: The Query Store and Query Tuning in SQL Server
Abstract: For the most part, query tuning in one version of SQL Server is pretty much like query tuning in the next. SQL Server 2016 introduces a number of new functions and methods that directly impact how you’re going to do query tuning in the future. The most important change is the introduction of the Query Store.
This session will explore how the Query Store works and how it’s going to change the methods you use to tune and troubleshoot query performance. With the information in this session, not only will you understand how the Query Store works, but you’ll know everything you need in order to put it to work with your own SQL Server 2016 tuning efforts, as well as your Azure SQL Databases.
Speaker(s):
- Grant Fritchey
Track and Room: Application Database Development - 1455
Title: How to migrate a SQL database to Microsoft Azure SQL V12
Abstract: There are many tools available to successfully migrate your on-premises relational database to Microsoft Azure SQL V12 database. Do you know what tools are available for migration? How do you choose the best tool for you? How do you analyze what objects are not compatible for migrating to Azure? It depends on the type, size and complexity of the database being migrated. In this demo based session I will show you 4 different tools, that you can use to analyze/migrate your on-premises SQL Database to Microsoft Azure SQL V12. We will migrate a single database using 4 different tools so you know what options are available for you. I will also talk about where you can download and how you can set up these tools. Briefly talk about pros and cons of each tool. At the end of this session you will be aware of the various techniques available to analyze and migrate SQL Database to Azure V12 and chose the best fitting one for your database.
Speaker(s):
- Taiob Ali
Track and Room: Enterprise Database Administration Deployment - 1610
Title: Think like the Cardinality Estimator
Abstract: SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates bases on the statistics as to how many rows flow from one query plan iterator to the next. Knowing how CE generates these numbers, will enable you to write better TSQL code and in turn influence type of physical operations during a query execution. Based on that estimated rows, the query processor decides how to access an object, which physical join to use, how to sort the data. Do you know how the CE generates these numbers? What happen when you have multiple predicates, range predicates, variable values that are “NOT KNOWN” to the optimizer or you have predicate values increasing in ascending order? Do you know what will happen if your predicate is using a value that is outside of histogram range? In this session, I will show you how CE estimates in all of these scenarios and you will walk out better equipped to tackle those nasty, hard to solve query plans.
Speaker(s):
- Taiob Ali
Track and Room: Enterprise Database Administration Deployment - 1455
Title: Version control with GIT for the DBA
Abstract: In 2005, Linus Torvalds developed the version control system (VCS) git. Since then, it has become as platform agnostic and ubiquitous as the internet. In that same note, github, the most popular service for hosting git repositories has become so ubiquitous that Microsoft chose to host the source code for its OSS fork of the .NET framework there instead of its own codeplex.
What does this mean to a DBA? Whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in VCS.
In my session. We’ll cover:
What is version control? How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN? How do I setup git for internal use in my company? How do I host public and private repositories on github. How do pull requests work? How do I fork a SVN repo to github?
We will be covering using git from both the command line and Visual Studio.
Speaker(s):
- Justin Dearing
Track and Room: Application Database Development - 1455
Title: Version control with GIT for the DBA Precon
Abstract: This is a half day pre-con for DBAs, database developers, and application developers that want to get started with storing their database schema in git.
We will cover using git from the command line and with Visual Studio. We will be using github as our central repository, but we will discus other cloud and on premisis options for the primary repository.
Our example application will be an ASP.NET MVC application and SQL Database whose schema will be managed by SSDT. Participants will be expected to have a laptop with either the community edition or professional edition of Visual Studio 2013, the latest CTP of SQL Server 2016, git for windows and Tortoise git. A github URL for the example application will be provided in advance. Attendees will be expected to have cloned the repo, compiled the application, and having it run locally.
Speaker(s):
- Justin Dearing
Track and Room: Application Database Development - 1435
Title: WIT: Start ‘em Young - Growing Women in IT
Abstract: Do an internet search on “Women in Technology” and you’ll find lots of articles with surveys, graphs and percentages telling you that there are not enough women in technology related fields. They’ll give you just as many reasons why girls don’t start in IT or women don’t stay in IT. Is this true? As women in technology, are we wired differently? Was there some lightbulb moment that to put us on the path to innovate with code? Why are you in technology in the first place? From Grace Hopper to that 6th grade girl gaming with people around the globe - while technology has changed and is more accessible, what makes women pursue IT careers hasn’t. With opportunities now spanning a wide array of fields and technologies, what does it take to inspire the young girls of today? In this session we will try to cut through a lot of the noise and get down to what drives young girls who grow to be women in technology, how we can encourage them, and not get in their way.
Speaker(s):
- Amy Herold
Track and Room: Professional Development - 1445
Title: Emergency! Are You Ready for Disaster to Strike?
Abstract: Most of the time pilots are learning to fly, they’re actually learning how to recover from emergency conditions. While we as Database Administrators focus on taking backups, how much time do we actually spend practicing recovering with those backups? This session will focus on the kinds of situations that can dramatically affect a data center, and how to use checklists to practice recovery processes to assure business continuity.
Learning objectives: 1 Understand the kinds of issues that can arise in critical data environments 2 Understand the expectations for performance and recovery of those data environments 3 Define a Personal Minimums contract for meeting the data availability expectations of the business
Speaker(s):
- Allen White
Track and Room: Enterprise Database Administration Deployment - 1435
Title: Scalable Application Design with Service Broker
Abstract: How your business applications interact with the corporate database directly can have a dramatic impact on how successful you are, and one of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates you can focus performance concerns to where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently, and minimizes the conflicts with your critical updates. This session will walk you through the steps to get Service Broker up and running and providing a consistent delivery of your business data.
Learning Objectives: Session Goal 1 Understand the Service Broker architecture Session Goal 2 Understand the difference between critical and non-critical updates Session Goal 3 Demonstrate how the non-critical updates are best handled asynchronously
Speaker(s):
- Allen White
Track and Room: Application Database Development - 1435
Title: SQL Server R Services in SQL 2016
Abstract: One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we’ll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We’ll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We’ll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we’ll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!
Speaker(s):
- Chris Hyde
Track and Room: Analytics and Visualization - 1455
Title: Big Data, Small Data, and Everything In Between
Abstract: The breadth of options available to data professionals today is staggering: between relational, object, graph, and document databases, we have a wide array of storage options, as well as a huge number of access and analysis tools. This talk will walk you through data platform, data analysis, and data processing options. We’ll discuss when to use (and when not to use) Spark, R, Storm, and SSAS, as well as a range of other tools and technologies. By the end of this talk, you may not have MongoDB or Neo4J, but you will know where they might fit.
Speaker(s):
- Kevin Feasel
Track and Room: Strategy and Architecture - 1435
Title: Developing and deploying reusable TSQL code with Visual Studio and SQL Server Data Tools
Abstract: Join Thomas in an almost PowerPoint free session where he shows how to write a reusable code library using TSQL, stored procedures, tables and functions and shows how to integrate the library into multiple database projects with a few mouse clicks. He will also share many Tips and Tricks for using Visual Studio more effective for database development.
Speaker(s):
- Thomas Grohser
Track and Room: Application Database Development - 1620
Title: From problem to Power BI: A journey in data visualization
Abstract: Power BI is all the rage right now in visualizing data on the Microsoft BI stack. We’ve seen multiple how tos and presentations on the features, but in this hour, we will actually go through the journey of a specific problem, research it, storyboard it, work through how we solve it (before we ever open Power BI) and then build the Power BI visualization. Make your visualization count. Come join us on the journey.
Speaker(s):
- Jonathan Stewart
Track and Room: BI Information Delivery - 1445
Title: # vs @ - it’s not about Social Media it’s about temporary tables and data
Abstract: In this session Thomas will explore and explain the different options that exist in SQL Server to temporary store data and show you when to use which and why not the others. This will cover #, ##, @, Non-Durable Memory Optimized and regular user tables. He will also present alternatives like common table expressions.
Speaker(s):
- Thomas Grohser
Track and Room: Application Database Development - 1435
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 - 1445
Title: SQL Server vNext (Linux and Beyond)
Abstract: Microsoft has leveled the RDBMS playing field, with SQL Server vNext, allowing you to deploy and run SQL Server on a variety of operating systems and container solutions.
In this session, we will look at the background of SQL Server’s move to non-Windows platforms, cover how to install using package deployment on Linux and image-containers with Docker. Focus will cover administration and tools that you can leverage while running SQL Server on non-Windows platforms, including migration and current feature function limitations.
Speaker(s):
- Andrew Loree
Track and Room: Enterprise Database Administration Deployment - 1610
Title: Query Tuning without Production Data
Abstract: The DBA is constantly ringing your phone complaining about why you did not include an index to support your new stored procedure. They have full access to production and do not understand how hard it is to tune a query with an underpowered development machine and a database which is less than 1/10th the size of the production equivalent. This session will cover query tuning techniques which will stop those phone calls and can be exercised on the worse of development environments. I will focus on query execution plan anti-patterns and faking out the optimizer.
Speaker(s):
- Derik Hammer
Track and Room: Application Database Development - 1445
Title: R For the SQL Server Developer
Abstract: R is the premiere language for data analysis. If the world of data science sounds fun and exciting, now is the time to get into R. We will walk through the core constructs of R, learn how to retrieve data from flat files and databases, and get a peek at the power behind R. This session will also give resources on where to go in order to become more familiar with statistics, R the language, and the R package ecosystem.
Speaker(s):
- Kevin Feasel
Track and Room: Analytics and Visualization - 1455
Title: Stretch Database and Managed Backups: Cloud Services for your SQL Servers
Abstract: Utilizing Azure cloud services does not mean moving all of your data or control away from your on-premises SQL Servers. In this session we will cover the new SQL 2016 Stretch Database and the SQL 2014 Managed Backups to Azure features. We will look at use-cases and limitations of both features to illustrate how these cloud services may fit into your current SQL Server environment.
Speaker(s):
- Andrew Loree
Track and Room: Enterprise Database Administration Deployment - 1610
Title: Painting with PowerShell: SQL Server Administration
Abstract: The SQL Server canvas gives us limitless opportunity for scripting and automation, and PowerShell is the perfect brush to paint with. Configuring our database servers, deploying database code changes, performing backups and restores are just a few examples of a day in the life of a DBA. Automation and scripting bring consistency, simplicity and scalability to many of these sometimes daunting tasks.
Join me to learn how to paint your own SQL Server canvas with PowerShell.
Speaker(s):
- Chris Sommer
Track and Room: Enterprise Database Administration Deployment - 1455
Title: Tuning Query Performance with SentryOne Plan Explorer
Abstract: SQL Server query tuning can be challenging, and the free SentryOne Plan Explorer solution provides the necessary information to both diagnose and troubleshoot where those problems actually are, and help you fix those issues.
Speaker(s):
- Allen White
Track and Room: Other - 1435
Title: Making the Leap from Developer to DBA
Abstract: You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.
Speaker(s):
- Amy Herold
Track and Room: Enterprise Database Administration Deployment - 1445
Title: Distributed Replay, using it to plan for the future.
Abstract: Before you go and move that mission critical application to a new version of SQL or new hardware you are probably creating some sort of testing and benchmarking scenarios to ensure a smooth upgrade. Right? Come learn how distributed replay can capture your workload and play it back on your new instance. Be it an upgrade of SQL or hardware we can review all sorts of scenarios to help make your upgrade a smooth process.
Speaker(s):
- Paul Popovich Jr
Track and Room: Enterprise Database Administration Deployment - 1620
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
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.
Andrew Loree
Twitter: - @LowOnDiskSpace
LinkedIn: Andrew Loree
Contact: http://www.andyloree.com
Andrew Loree has over nineteen years of database experience with roles in architecture, design, development, and implementation of enterprise-scale SQL Server data solutions, supporting industries from legal e-discovery to manufacturing. Areas of expertise since SQL Server 2000 include data migration and ETL/ELT solutions, disaster recovery planning, high availability service design, licensing and virtualization. Andrew holds fourteen Microsoft certifications, has both a Bachelor and Masters of Science in Computer Science from Wright State University and is a Columbus (Ohio) PASS board member.
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.
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.
Taiob Ali
Twitter: - https://twitter.com/SqlWorldWide
LinkedIn: Taiob Ali
Contact: http://www.sqlworldwide.com
Taiob Ali, MVP Data Platform, is an accomplished technical leader with a proven record of success. For 14 years, he has worked with the Microsoft Data Platform and MongoDB both on-premise and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare. Taiob has hands-on experience in managing large database projects, massive data migration, intricate process design, testing and deployment, performance tuning, long term capacity planning. Taiob is currently working at “GMO LLC” as a Database Solution Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He is a regular speaker at local and virtual PASS chapters, SQLSaturdays, and Azure conferences.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
Derik Hammer
Twitter: - https://twitter.com/sqlhammer
LinkedIn: Derik Hammer
Contact: http://www.sqlhammer.com
I am currently working as a Database Operations Team Lead with Subway World Headquarters. Server configuration, architecture, disaster recovery, high-availability, performance tuning, and maintenance automation form the bulk of my responsibilities. Almost all of my previous experience has resided firmly in the traditional / production DBA realm. I also spend as much time as I can spare attending SQL Server community functions. Currently chapter leader for FairfieldPASS.
Andrew Loree
Twitter: - @LowOnDiskSpace
LinkedIn: Andrew Loree
Contact: http://www.andyloree.com
Andrew Loree has over nineteen years of database experience with roles in architecture, design, development, and implementation of enterprise-scale SQL Server data solutions, supporting industries from legal e-discovery to manufacturing. Areas of expertise since SQL Server 2000 include data migration and ETL/ELT solutions, disaster recovery planning, high availability service design, licensing and virtualization. Andrew holds fourteen Microsoft certifications, has both a Bachelor and Masters of Science in Computer Science from Wright State University and is a Columbus (Ohio) PASS board member.
Edward Pollack
Twitter: - EdwardPollack
LinkedIn: Edward Pollack
Contact: https://www.sqlshack.com/author/edward-pollack/
Ed Pollack has over 20 years of experience in database and systems administration, which has developed his passion for performance optimization, database design, and making things go faster. He has spoken at many SQLSaturdays, 24 Hours of PASS, and PASS Summit. This led him to organize SQLSaturday Albany, which has become an annual event for New York’s Capital Region. Sharing these experiences with the community is a top priority, and encouraging everyone to take the leap into public speaking and engaging others, a passion. In his free time, Ed enjoys video games, traveling, cooking exceptionally spicy foods, and hanging out with his amazing wife and sons.
Thomas Grohser
LinkedIn: Thomas Grohser
Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.
James Serra
Twitter: - www.twitter.com/JamesSerra
LinkedIn: James Serra
Contact: http://www.JamesSerra.com
James Serra is a big data and data warehousing solution architect at Microsoft. He is a thought leader in the use and application of Big Data and advanced analytics. Previously, James was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 35 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker. He is the author of the book “Reporting with Microsoft SQL Server 2012”.
James Serra
Twitter: - www.twitter.com/JamesSerra
LinkedIn: James Serra
Contact: http://www.JamesSerra.com
James Serra is a big data and data warehousing solution architect at Microsoft. He is a thought leader in the use and application of Big Data and advanced analytics. Previously, James was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 35 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker. He is the author of the book “Reporting with Microsoft SQL Server 2012”.
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
Justin Dearing
Twitter: - zippy1981
LinkedIn: Justin Dearing
Contact: http://www.justaprogrammer.net
Justin Dearing has been working in IT in 2002. He started as a night shift AS/400 operator and rose through the ranks at a series of companies. He currently works as a developer in the capital markets industry.
Justin has served in both the development and production side of the house on Windows, Unix and Midrange Platforms. His database experience includes MongoDB, MySQL, Postgres and Microsoft SQL server. These days he programs in C#, PowerShell and PHP.
Taiob Ali
Twitter: - https://twitter.com/SqlWorldWide
LinkedIn: Taiob Ali
Contact: http://www.sqlworldwide.com
Taiob Ali, MVP Data Platform, is an accomplished technical leader with a proven record of success. For 14 years, he has worked with the Microsoft Data Platform and MongoDB both on-premise and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare. Taiob has hands-on experience in managing large database projects, massive data migration, intricate process design, testing and deployment, performance tuning, long term capacity planning. Taiob is currently working at “GMO LLC” as a Database Solution Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He is a regular speaker at local and virtual PASS chapters, SQLSaturdays, and Azure conferences.
Edward Pollack
Twitter: - EdwardPollack
LinkedIn: Edward Pollack
Contact: https://www.sqlshack.com/author/edward-pollack/
Ed Pollack has over 20 years of experience in database and systems administration, which has developed his passion for performance optimization, database design, and making things go faster. He has spoken at many SQLSaturdays, 24 Hours of PASS, and PASS Summit. This led him to organize SQLSaturday Albany, which has become an annual event for New York’s Capital Region. Sharing these experiences with the community is a top priority, and encouraging everyone to take the leap into public speaking and engaging others, a passion. In his free time, Ed enjoys video games, traveling, cooking exceptionally spicy foods, and hanging out with his amazing wife and sons.
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
Paul Popovich Jr
Twitter: - @pmpjr
LinkedIn: Paul Popovich Jr
Contact: https://pmpjr.wordpress.com/
Paul Popovich Jr. has been in the IT space for his whole career and tinkering with computers since his 486 PC back in the mid 1990s. Professionally he is a senior DBA for a large hospital system. You can find on twitter @pmpjr, email at paulpopovichjr@gmail.com.
Chris Sommer
Twitter: - @cjsommer
LinkedIn: Chris Sommer
Contact: http://www.cjsommer.com
Chris started in computing and I.T. in the mid to late 1990’s. After the dust had settled from Y2K, he found himself a bit more focused and working with database servers on the Unix platform. His first exposure to SQL Server was in 2007 and he has been working on that platform ever since. Chris is currently a Senior SQL DBA with a focus on reliability, stability and performance. He truly enjoys the building tools with PowerShell to help his fellow DBA#39;s manage their ever growing environment.
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.
Thomas Grohser
LinkedIn: Thomas Grohser
Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.
Justin Dearing
Twitter: - zippy1981
LinkedIn: Justin Dearing
Contact: http://www.justaprogrammer.net
Justin Dearing has been working in IT in 2002. He started as a night shift AS/400 operator and rose through the ranks at a series of companies. He currently works as a developer in the capital markets industry.
Justin has served in both the development and production side of the house on Windows, Unix and Midrange Platforms. His database experience includes MongoDB, MySQL, Postgres and Microsoft SQL server. These days he programs in C#, PowerShell and PHP.
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.
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.
Chris Hyde
Twitter: - ChrisHyde325
LinkedIn: Chris Hyde
Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
Derik Hammer
Twitter: - https://twitter.com/sqlhammer
LinkedIn: Derik Hammer
Contact: http://www.sqlhammer.com
I am currently working as a Database Operations Team Lead with Subway World Headquarters. Server configuration, architecture, disaster recovery, high-availability, performance tuning, and maintenance automation form the bulk of my responsibilities. Almost all of my previous experience has resided firmly in the traditional / production DBA realm. I also spend as much time as I can spare attending SQL Server community functions. Currently chapter leader for FairfieldPASS.
Sponsors
The following is a list of sponsors that helped fund the event: