Michael Wall Polybase – It’s What’s for Dinner

Polybase is Microsoft’s great new replacement to linked servers. With the current version in SQL Server 2019, one can connect to multiple data sources such as Teradata, Apache, Hadoop, Oracle, and many many more. We will review best practices for setting up Polybase and its Scale-Out groups as well as showing how it interacts in an AlwaysOn Availabilty Group. When Scaling-Out (up!), Polybase is able to work harder and deliver more data. What happens when one of its node disappears? We will have a live demo demonstrating how to manage the Scale-Out group when bad things happen. In addition, the DMVs for managing Polybase will be reviewed, and finally, there will be results of the impact of using multiple nodes in the Scale-Out group on the Polybase queries!

Are you having trouble keeping up with all the new releases of SQL Server? Don’t you feel like you’ve just completed a great milestone in upgrading all your instances to SQL Server 2017 – only to find out that you are behind again? ☹ If so, this session will help you quickly get up to speed in all the new features of SQL Server 2019. The topics that will covered are Intelligent Query Processing and how it works; new security and compliance features and how they can help; and an introduction to big data clusters and high availability for complete database transparency within your organization. This session is a must see for all DBAs.

Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.