Janis Griffin

HiHo! HiHo! SQL Server on Linux, we go!

Are you being forced to the ‘Cloud’ to reduce costs? SQL Server 2017 now runs on Windows, Linux, and Docker containers.

Now SQL Server can be installed on Linux in order to provide a consistent database platform across Window and Linux servers, as well as on-premises and in the cloud. This presentation will discuss the advantages of using SQL Server on Linux, comparing architecture, cost and performance. Several demonstrations on installing and maintaining SQL Server on different Linux distributions and Docker will be shown, as well as best practice considerations for production/development environments. Also, several useful Linux commands for monitoring, managing and backing up SQL Server will be demonstrated. Finally, client connectivity and tools will be discussed – plus the new Azure Data Studio UI with the ability to add monitoring widgets will be demonstrated.

Alfred Burnett

Simplify Database Performance and Management

Database management is complex. Database professionals are increasingly being asked to manage not only larger numbers of database instances, but multiple database platforms. Open source and NoSQL databases along with cloud adoption are all having a major impact, and DBAs are now expected to ensure the best performance and stability of this cross-platform database environment. But what if you could meet growing demands faster and with less risk? This means you’d get more time to innovate and focus on important projects. In this session, you’ll learn how to proactively manage all your database platforms from end to end. Items of discussion include: · Scoring optimal availability and performance out of Enterprise and Standard edition databases · Managing hundreds of database instances with ease · Maintaining databases both on-premises and in the cloud · Decreasing overhead by managing databases with little to no impact on performance

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!

Please come join us next Wednesday night at 1830 HRS PST for an all-star lineup of speakers on a variety of topics including #DeveloperAdvocacy (Tim Combs), #communityorganizing (Joe Dunn), #powerbi (Paul Turley), #AzureDataStudio (Jody Pilsworth), and #SQLServer #hardware (Glenn Berry)!

It's going to be a fun night! Come register at:

https://register.gotowebinar.com/register/3677754653419920656

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.