John Mccormack

Information & Communications Technology

SQL Microsoft SQL Server Azure SQL Database Azure SQL Server SQL Server DBA sql server aws

Paisley, Scotland, United Kingdom

John Mccormack

Principal DBA @ Monster

I've been working as a DBA since 2012. I work on SQL Server, Azure SQL DB and AWS RDS as well as other cloud and big data solutions. I hold the MCSE: Data Management and Analytics and I am an AWS Certified Solutions Architect Associate.

Current sessions

7 ways for data teams to save money in Azure

Operating in the cloud means it is easy to just spin up new instances in minutes but without careful planning and regular review, your costs can run away from you.

Get on top of your cloud costs and start saving money by putting these 7 tips into action.

In this fast paced session, we discuss the principles of cost optimisation as a key component or architecting optimal cloud solutions as well as 7 tips which specifically help you save money in Azure. Many of the tips have similar cloud agnostic tips which can help you optimise costs with any major public cloud provider.

This can also work as a lightning talk however we can't delve as deep into the how and why if it's presented that way,


SQL Community has got your back - Enterprise ready tools at no cost

So your company has no budget for fancy 3rd party tools. Don’t worry, the SQL community has got your back.

It’s hard to believe how many free tools are available to data professionals. It’s even more amazing just how good these tools are. These are very mature and tested projects that I split into three main subject areas.

1. Realtime analysis, troubleshooting and performance tuning
2. Automation and productivity enhancement
3. Governance and controls

In this talk, I discuss some of the tools I couldn’t live without that are free to use and developed by members of the SQL Community. I’ll talk about how you can use them to make your job easier and how to convince your boss that they are safe to use.

These tools will save you time and money, and if used correctly can greatly enhance your skills and personal value as a DBA.

The target audience is DBAs and people who look after SQL Servers or Azure SQL databases, even if they don't call themselves DBAs. Although it may seem aimed only at people who work at companies who don't like buying 3d party solutions, each product I discuss has no better paid for solution in the market in my opinion.