Speaker

David Postlethwaite

David Postlethwaite

SQL Server and Oracle DBA, Azure and PowerBI admins

Copenhagen, Denmark

David Postlethwaite has been a SQL Server and Oracle DBA since 2008.
He now lives and works in Copenhagen supporting databases, Azure, NetApp, security, auditing, mentoring and whatever else his company asks him to work on.
In a previous life he was a .NET developer and way back in history a Windows and Netware administrator.

Area of Expertise

  • Information & Communications Technology

Topics

  • SQL Server DBA
  • Oracle DBA
  • Azure admin

Auditing Azure SQL Database with Log Analytics- How, where and what

If you have built an Azure SQL database you will have probably seen the Auditing option in the Portal.
But what exactly does this give us ?

In this presentation we will look at Auditing in Azure SQL database.
How to correctly configure auditing.
Setting up the necessary Diagnostics
Viewing the data in Azure Analytics.
Introduction to the Kusto Query Language
Azure SQL Analytics to monitor performance (still in Preview after 4 years)
Azure SQL Security Insights
Putting it all together with Azure Workbooks

Beware of the Dark Side - A Guided Tour of Oracle for the SQL DBA

Today, SQL Server DBAs are more than likely at some point in their careers to come across Oracle and Oracle DBAs. To the unwary this can be very daunting and, at first glance, Oracle can look completely different with little obvious similarities to SQL Server.
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.

At the end of this session you will have a better understanding of Oracle and the differences between the Oracle RDBMS and SQL Server.
Although you won’t be ready to be an Oracle DBA it will give you a foundation to build on.

From Zero to Hero: Accidental SQL Server DBAs Survival Guide

This conference session will provide a comprehensive survival guide for individuals who are new or accidental SQL Server Database Administrators (DBAs). The presentation will cover key concepts and best practices to effectively manage SQL Server instances and databases, including installation, configuration, security, backup and recovery, monitoring, performance tuning, and troubleshooting.
Attendees will learn practical tips and tricks for
• Managing security
• Backup and restore strategies
• Regular maintenance
Whether you are a developer, IT professional, or accidental DBA, this session will equip you with the essential knowledge and skills to confidently manage SQL Server environments and ensure optimal performance and uptime. By following the guidance provided in this survival guide, you will be able to quickly move from being a novice to a hero in SQL Server administration.

SQL Server Management Studio Tips and Tricks

SQL Server Management Studio is at the heart of any SQL Server DBA or developer’s day. We take it for granted but rarely do we take a look at how we can customise or improve it to make our day to day work easier and more productive.
This presentation will take look at many of the hidden features and shortcuts that you had forgotten about or didn’t know were there including some new features in SSMS 2017.
At the end of this session you will have learnt at least one new feature of SSMS that you can use to improve your productivity.

Taming the Beast – How a SQL DBA can keep Kerberos under control

The word Kerberos can strike fear into a SQL DBA as well as many Windows Server Administrators.
What should be a straight forward and simple process can lead to all sorts of issues and trying to resolve them can turn into a nightmare.
This talk looks at the principle of Kerberos, how it applies to SQL Server and what we need to do ensure it works

Using Azure Policies to control yourAzure environment

Have you wanted to control or check what your users do in Azure?

Maybe stop them from creating resources in the wrong data centre, or force them to create tags on new resources,
Or audit your VMs for weak passwords, check that your VMs have a Azure backup enabled, that all your Azure SQL have TDE enabled, even check if your SQL has a public IP address and then disable it

Azure Policy allows you to enforce and control the properties of a resource. We can use policies to apply different rules to different resources, so that they stay compliant to your IT standards

Join me as we take a gentle look at what we can do with policies to control our Azure environment

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

Gethyn and David have been DBAs for far too long. Between them, they have had to deal with their fair share of interesting times

Come and hear about our top five disasters and how we managed, or not, to dig ourselves or our team out of a hole.

This will be a fun session discussing some of the strange things that have happened to us in the combined 35 years we have been doing this.

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

How secure is your SQL Server?

What steps do you take to ensure that your SQL Server is safe from attack?
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.

What that means is that there is a set of guidelines, or best practices, agreed upon by the industry that suggests the best things to do to make our SQL Servers secure.

In this session, listen to David and Gethyn discussing these best practices, see if you agree with them, and see how many you have implemented.

David Postlethwaite

SQL Server and Oracle DBA, Azure and PowerBI admins

Copenhagen, Denmark