The goal of the Pensacola Data Professionals user group is to provide free training on a variety of topics surrounding the Microsoft Data Platform for local DBAs and Data professionals. We'll be hosting nightly meetings typically every other month, as well as, hosting a PASS SQLSaturday event that is held one time per year. The monthly meetings will consist of volunteer speakers, both experienced and those wanting to get into technical presenting; good eats provided by our sponsors; open forum discussion and networking time. Meetings will be held the last Thursday of the month.
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, retrieve, extract, import, shape, model and analyze the tons of free and interesting data available in the wild. From daily NYC subway turnstile data to coastal accident statistics gathered by the Coast Guard, this data is just waiting to be loaded into your favorite analytics tools like Power BI Desktop or Jupyter Notebooks to yield interesting and often unexpected results.
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.