Southampton Data Platform and Cloud Meeting - 5th February 2020

Welcome to Southampton Data Platform and Cloud Group, this event is hosted at 2 Venture Road, Southampton Science Park near Chilworth. When entering the Science Park, turn off the A27 onto University Parkway. Not Manor Road.

Please be aware that in order to attend we need you to register in advance as there is limited space and we need to know how many people to order pizza for. Please also remember to unregister if you can no longer attend. Thanks :-)

Agenda

18:15 - Doors Open

18:30 - Introductions

18:45 - Christian Bolton - AWS Primer for SQL Server professionals

A light-hearted introduction to the Amazon Web Services cloud platform covering options for SQL Server deployment, cost optimization and Amazon's other database offerings

19:45 - Break and Pizza

20:15 - Mikey Bronowski - Multi-server agent jobs administration with happy faces and pigeons

This talk will be about multi-server administration using MSX and TSX servers. Built-in feature you may have seen, but was too scared to play with. Will show you how to configure multi-server environment and how to manage it with least possible resources.

What SQL Server and pigeons have in common? Not much, besides that you do not want to be a pigeon - pigeon post to be specific.
I have been a DBA pigeon in my past. Managing hundreds of SQL Servers and visiting every single SQL Agent to setup the maintenance jobs, backup jobs or any jobs that would help me to keep the servers up and running. Sometimes using SQL scripts, other times Powershell scripts to deploy or update new jobs, but it was still the same ol' way. Flying between instances like a bird. Until, one day, I found out about MSX and TSX! And now my life is full of happy faces! I want your face to be happy too.

In this session you will learn how easy is to setup this hidden and forgotten feature of SQL Server. Will show you how quick is to make a master server and add some new target servers. If you discover an urge to go back to your shop and make a revolution - you can leave before the end - to save the world! Your world!

The pigeon says: "coo roo-c'too-coo"

21:15 - Prize Draw & Close

Sponsors

A massive thanks to our Spectrum IT. Without them we would not be able to host this event for free. SpectrumIT kindly provide funding for the room, pizza and a £20 Amazon Voucher.

Bios:
Mikey Bronowski
What I do? I select, I select stars!

Data enthusiast with mathematics background in relation with SQL Server for over 10 years. Works as a database administrator (Microsoft SQL Server) responsible for environments upgrades and migrations. Holds certificates MCP, MCSE Data Platform.

Not long ago Poland Data Community member, now proud Leeds Data Platform User Group active member.

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

Italian calcio fan and traveler.