Monitoring, Auditing and Alerting in SQL Server

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.

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.

Speaker

David Postlethwaite works as a SQL and Oracle DBA, Azure admin and DevOps engineer for Banking Circle in Copenhagen, Denmark. Previously he was a SQL Server and Oracle DBA for Liverpool Victoria in Bournemouth, England.

David Postlethwaite's Sessions

A Step-by-Step Guide to Building a Data-Driven Culture

Bridging the Gap: Transforming Tech Friction into Startup Success

Mirror, mirror on the wall, who can sync their data best of all

Moneyball – Build a killer Fantasy Football Team with Power BI

A Step-by-Step Guide to Building a Data-Driven Culture

What you can do to protect your SQL Server and why it matters

Introduction to Azure SQL Database

Monitoring, Auditing and Alerting in SQL Server

Top Five Disasters we've dealt with in our time as DBAs

I'm a SQL DBA. What do I do with this Oracle database?

Dynamic Data Masking in 20 Minutes

Taming the Beast - How a DBA can keep Kerberos under control

A Beginner’s Guide to Cloud Computing and SQL Azure