Monitoring, Auditing and Alerting in SQL Server
2022TL; DR
This presentation will go through some of the things that I do in my SQL estate to ensure that the instances keeps working, are secure, safe and that I am informed quickly when something bad happens.
Session Details
You've built your shiny new SQL Server and everything looks great
But what next?
What should you do to keep your servers working in tip top condition
What house-keeping tasks should you be doing?
What alerts should you setup?
What shoud you be auditing?
How do you know if someone is tampering with your carefully crafted settings?
This presentation will go through some of the things that I do in my SQL estate to ensure that the instances keeps working, are secure, safe and that I am informed quickly when something bad happens.
3 things you'll get out of this session
Speakers
David Postlethwaite's other proposed sessions for 2026
A Step-by-Step Guide to Building a Data-Driven Culture - 2026
Bridging the Gap: Transforming Tech Friction into Startup Success - 2026
From Zero to Hero: Accidental SQL Server DBAs Survival Guide - 2026
Mirror, mirror on the wall, who can sync their data best of all - 2026
Moneyball – Build a killer Fantasy Football Team with Power BI - 2026
What you can do to protect your SQL Server and why it matters - 2026
David Postlethwaite's previous sessions
What you can do to protect your SQL Server and why it matters
The CIS Benchmarks, from the Centre of Internet Security (CIS), are a set of globally recognized and consensus-driven best practices to help us implement and manage our cybersecurity defences.
In this 20-minute session, listen to David and Gethyn discussing these best practices, see if you agree with them, and see how many you have implemented.
Top Five Disasters we've dealt with in our time as DBAs
Come and hear our top five disasters and how we managed them (or not)
I'm a SQL DBA. What do I do with this Oracle database?
This talk sets out to explain some of the terminology, the differences and the similarities between Oracle and SQL Server and hopefully make Oracle not look quite so intimidating.
Dynamic Data Masking in 20 Minutes
In this 20 minute session we will have an overview and demos of Dynamic Data Masking which allows us to obfuscate data in real time