Birmingham Data Platform - Making Your Emergency Toolkit & Chatbots for the DBA

Microsoft Data Platform Group - Birmingham
Microsoft Data Platform Group - Birmingham
Public group

Ricoh Digital Services

54 Hagley Rd Birmingham · West Midlands

How to find us

Sign in at reception, and someone will take you to the room

Location image of event venue

Details

Microsoft Data Platform Group Birmingham - Thu 14th Nov 2019, 6.15pm

*** Registration on MeetUp required for venue security ***

Session 1: Making Your Emergency Toolkit (Rich Benner)

Session 2: Chatbots for the DBA (Stuart Moore)

Agenda

6.15pm – 6:30pm Meet & Greet

6:30pm - 7:30pm: Making Your Emergency Toolkit (Rich Benner)

You’ve just been given a server that is having problems and you need to diagnose it quickly. This session will take you through designing your own toolkit to help you quickly diagnose a wide array of problems.

We will walk through scripts that will help you pinpoint various issues quickly and efficiently.

This session will take you through;

What’s on fire? – These scripts will help you diagnose what’s happening right now

Specs – What hardware are you dealing with here (you’ll need to know this to make the appropriate decisions)?

Settings – are the most important settings correct for your workload?

Bottlenecks – We’ll see if there are any areas of the system that are throttling us.

By the end of this session, you should have the knowledge of what you need to do in order to start on your own kit. This kit is designed to be your lifeline to fix servers quickly and get them working. All code we’ll go through is either provided as part of this presentation or are open source/community tools.

7:30pm - 8:00pm Break & Pizza

8:00pm – 9:00pm Chatbots for the DBA (Stuart Moore)

Want a single place to see all your database alerts? Want to be able to respond to able to respond to them in the same tool even when away from your main computer? Want to let people self serve their database needs?

We’ll be looking at using simple chatbots within Slack and Teams to let you achieve all of that and more.

Venue

This session will be held at Ricoh Digital Services.

Address: 54 Hagley Rd, Birmingham, B16 8PE

Parking: Over the road at Broadway Plaza
https://broadway-plaza.co.uk/Parking

Other Details

We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know.

Dress code: relaxed

Event Organiser Contact Details

If you need any further details or have any requests for this or future Data Platform Group events, please contact get in touch.

Alex Whittles
Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex)
Email: [masked]

Reiss McSporran
Twitter: @McReiss (https://twitter.com/McReiss)
Email: [masked]

Microsoft Data Platform Group - Birmingham
Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum)

Speaker Profiles

Rich Benner is a performance tuning DBA who specialises in making SQL Servers and their queries run faster. Rich is a technical speaker and loves giving back to the community. Recent talks are at PASS East Midlands user group as well as at SQLBits (the largest SQL Server conference in the UK).

Stuart Moore
20+ years as a professional data wrangler. Microsoft Data Platform MVP, Data Relay organiser, major contributor to the dbatools project, and runs 2 local usergroups in his spare time.

Sponsors
We're delighted to yet again have the awesome RP Analytics recruitment sponsoring the pizza for the event, thanks!

Ricoh are generously providing the venue for us, thanks Ricoh!

Purple Frog handle the organisation.