December 2021 Meetup

We will be teaming up with Southampton User Group for our meetup. As we won't be seeing each other in person it allows us to join the communities and host a joint user group.

Agenda

18:30 - Jess Pomfret - Life Hacks: dbatools edition

dbatools is an open source PowerShell module with over 500 commands to assist you with managing your SQL Server estate. This session will walk through several life hacks that you can take back to work and quickly implement to make your life easier and impress your friends.

This session’s life hacks will include, among others:

• How to answer your boss’ question quickly
• Is my database in full recovery model?
• When was my last backup?
• Testing your environment for best practices
• Is max memory set appropriately?
• Is TempDb configured optimally?
• Exporting/backing up server configurations
• Do you have everything you need if your server dies?

About the speaker: "Jess Pomfret is a Data Platform Architect and a Microsoft MVP. She started working with SQL Server in 2011, and enjoys the problem-solving aspects of performance tuning and automating processes with PowerShell.

She also enjoys contributing to dbatools and dbachecks, two open source PowerShell modules that aid DBAs with automating the management of SQL Server instances. She has also contributed to the SqlServerDsc module, adding several new resources to use when configuring your SQL Servers.

She grew up in the South West of England and outside of her DBA life enjoys Crossfit, cycling and watching proper football.

----------------------------------------------------------------------------------------------------
19:30 - Mikey Bronowski - Automate management tasks using elastic jobs in Azure SQL Database.

The good ol' agent, SQL Server Agent, is known widely in the DBA world. It is powerful, but... Azure SQL Database requires something more, something different. Meet elastic Elastic Database agent and its jobs!

About the speaker: I select stars from the Space.
What do I do? I select, I select stars!

Data enthusiast with a mathematics background. Working with SQL Server for over 15 years. Works as a database engineer (Microsoft SQL Server) responsible for environments upgrades and migrations. Microsoft Certified Trainer with a couple of certificates. Blogger at (bronowski.it). Since 2021 Microsoft Data Platform MVP.

Not long ago Poland Data Community member, now proud UK Data Platform active member.

When not working or teaching, learns new things or attends various data/technical conferences and meetups.

Italian Calcio fan and traveller.