Double-Header Covering Migrations with AGs and Data, Data Everywhere

Pensacola Data Professionals
Pensacola Data Professionals
Public group

1000 College Blvd

1000 College Blvd · Pensacola, FL

How to find us

We are located in a meeting room to the left of the front doors of the library on College Rd.

Location image of event venue


Beginning at 6:30, we'll have Elizabeth Noble teaching us how to "Migrate Your Database(s) with Distributed AGs". You find yourself needing to migrate to new hardware or new operating system. If you're running SQL Server 2016+, you're in luck! Distributed Availability Groups (AGs) may just be the solution you want.

In this session, Elizabeth will explain the purpose and usages of Distributed AGs, create a Distributed AG and the associated AGs, and perform a mock data center migration.

NOTE: This session is an intermediate level. Attendees are expected to already be familiar with Availability Groups.

Elizabeth's BIO: Elizabeth Noble is a Database Engineer in the metro Atlanta area. When she was introduced to her first database over 10 years ago, it was love at first sight. Her passion is to help others improve the quality and speed of deploying database changes through automation. When she is not trying to automate all of the things, she can be found spending time with her dogs, playing disc golf, or taking a walk at the gym.

At 7:30ish, Rodney Landrum will present "Data, Data Everywhere, a lot of it is free". This session focuses on the techniques to discover, consume and analyze the limitless amounts of open data sets available for the taking. Pick any topic of interest and chances are there is a data set just waiting to be loaded into your favorite (and free) analytics tools. This process often yields fascinating results like you will see demonstrated in this session.

Rodney's BIO: I spend 82.25 percent of my time thinking about proving concepts, writing about, talking about and implementing solutions for SQL Server technologies. I have an affinity for HADR, Reporting, BI, data analysis, SQL internals, capacity planning, architecture, virtualization, performance tuning and optimization and aggregations. The other 22 percent of my time I spend working on how to make accurate percentages. I work from home out of my Office Del Castillo. I am an author, sometimes-blogger and presenter on SQL technologies. I am happily back in Pensacola from Orlando, where the traffic was miserable.