John McCormack DBA

SQL Server Databases and Cloud

  • Personal
    • About
  • Free Training
    • SQL Server on Amazon RDS (Free Course)
    • Free practice questions to help you pass DP-900
  • Save money in Azure
    • Azure IaaS SQL Backups – Stop burning money
    • Your Azure SQL Database and Managed Instance is too big
    • Turn the cloud off at bedtime to save 70%
    • Your Azure SQL Virtual Machine might be too big
    • Save money with Azure SQL DB serverless
    • Save up to 73% with reserved instances
    • Delete unused instances to save money in Azure
  • Hire me
    • 60 minute cost optimization
    • Let me solve your SQL Server problems
    • Take a look at my Sessionize speaker’s profile

DataGrillen 2022 – Photos and notes

8th June 2022 By John McCormack Leave a Comment

I’m just back from DataGrillen 2022. As ever, I wanted to put together a short post and use the opportunity to share some things I learned, and share some photos of the event. First of all, thanks for such a hospitable welcome from William Durkin and Ben Weissman and congratulations for hosting a very successful event.

On top of everything else that goes into planning a complex event like this, they also had an added responsibility this time to keep people free of covid as far as was reasonably possible. This meant mandatory testing, vaccine passports and masking wearing (inside only). It was a small price to pay after two years of online conferences only.

The barbecue event was on the middle night after the sessions. There was a great choice of food and everything was cooked really well, and of course there were complimentary beers to wash it down.

Following on from the main event which comprised of two days of technical sessions, the host town of Lingen was celebrating the historic Kivelingsfest, a medieval festival dating back hundreds of years. As a result, many of the conference attendees stayed on an extra day to attend the festival which was great fun.

It was home on Sunday but not before we got the chance to celebrate André Kamman’s by taking a boat trip along Amsterdam’s canals.

Datagrillen 2022 photos

  • DataGrillen 2022 Keynote slide
  • Andrew Pruski DeepDive into Docker presentation
  • Jess and Sander presenting
  • Argenis talks about ransonware
  • Monica Rathbaun talks Azure SQL DB performance
  • John Martin speaks to the room
  • The Data Dance Teacher Robert French
  • Beer in the final session of the day
  • Barbecue food
  • Glass of beer
  • kivelingsfest fun
  • Amsterdam canal boat
  • Amsterdam canal boat with large greenhouse in background
  • Fire at Kivelingfest Lingen

DataGrillen 2022 Sessions

These are the sessions I attended. I tried to fit in as much as possible from the two day event.

John Martin – Performing successful cloud migrations – Chalk & talk

It was a very informal delivery by John who guided us through a timeline and the phases of a successful cloud migration. It was a cloud agnostic session so the key information could be used with any major cloud provider.

Andrew Pruski – A deep dive into Docker

I wanted to attend this as I haven’t used Docker a great deal and I wanted to learn more. Andrew provided a great overview and worked through some very well prepared demos. I am keen to try to follow these up by visiting his github repo for the content.

Gianluca Sartori – Time Series for relational people

Gianluca gave a great overview of the differences between relational and time series databases and went on to review a few. He settled on influxdb and demonstrated in detail how it could be used along with Grafana and Telegraf agent (TIG stack) to provide really useful metrics. I do use the TIG stack in my work but I learned about some great settings for dealing with or discarding older data that I plan to take forward.

Monica Rathbun – Performance tuning Azure SQL Database

This session was packed to the rafters and extremely hot, yet Monica’s enthusiastic and engaging style made it so easy to stay focused on the message. The message was delivered well and easy to understand. I took away some key information here regarding query store and readable secondary databases. Overall, it was my favourite session of DataGrillen 2022.

Argenis Fernandez – Ransomware sucks. Beef up your databases against it.

This had to be close contender for my top session. Argenis knew what he was talking about and it showed. He gave very good advice and I have returned home with a checklist that I will need to turn into an action plan.

André Kamman – Looking under the hood of the parquet format

I’m familiar with parquet as I use AWS Athena a lot however I’ve never really looked under the hood. I honestly expected this session to be a bit above me but André’s communication style made it very accessible for attendees of all knowledge levels and easy to follow along.

Jess Pomfret and Sander Stad – Deploying Azure Resources with PowerShell Azure Functions

Jess and I were fellow newcomers at Data Grillen in 2019. I always enjoy her sessions so this was not to be missed. It was my first time seeing Sander and the two presenters worked well to deliver this session. I left convinced that I need to change at least one part of my automation routine to include Azure functions, so I will hopefully be checking them out this week. (If time allows, the trouble with conferences is you return home with SO many ideas)

Heini Ilmarinen – Less Clicking, More Coding! Azure Data Platform Development Using Infrastructure as Code

I’ve dipped my toe into Terraform but I’ve used BICEP and Cloud formation a bit more. After Heini’s session, I get the benefits of Terraform and I’ve added it to my ever increasing list of things to review. A great session in which Heini did well to keep us engaged all the way through.

Robert French – Goldilocks and the three business bears; story telling for business

This was the last session of a very busy two days. They broke the mould when they made Robert and as expected, his session also broke the mould. Robert delivered the session with unmatchable energy, kind of at a blistering pace but the pace was just right at the same time. He got through a huge amount of visual aids. He gave great advice on where you eyes are drawn to in report, how to make key data pop out and how to usual colours and fonts carefully.

Filed Under: front-page, SQL Server, Training Tagged With: data grillen, datagrillen, kivelingsfest

Free practice questions to help you pass DP-900

26th January 2021 By John McCormack 3 Comments

pass DP-900 checklist

Pass DP-900 certification from Azure

These are a series of free practice questions and tests to help you pass DP-900 – Microsoft Azure Data Fundamentals. They are written completely by me based on my review of the publicly available course materials. Unlike some sites, these are not exam dumps, so are a perfectly honest and legitimate way to study towards your Azure DP-900 certification.

These practice questions should be seen as a supplement to Microsoft Learn and not a replacement. My number one tip for passing Azure DP-900 is to complete the free learning paths on Microsoft Learn for the DP-900 course.

This series is a work in progress so please keep coming back for more questions and quizzes. I didn’t want to wait until everything was published before sharing this help with you. I hope that you enjoy the practice questions and good luck with your mission to pass DP-900.

I’d also appreciate any feedback if any of the answers appear to be incorrect or if the questions are too easy or too hard.


More questions, quizzes and links are added almost daily. Bookmark this page and come back for new practice questions to help you pass DP-900.

DP-900 practice question links ⬇

Azure Data Fundamentals Learning Paths

  • Explore core data concepts
    • Explore core data concepts
    • Explore roles and responsibilities in the world of data
    • Describe concepts of relational data
    • Explore concepts of non-relational data
    • Explore concepts of data analytics
  • Explore relational data in Azure
  • Explore non-relational data in Azure
  • Explore modern data warehouse analytics in Azure

IT Certification Category (English)728x90

Filed Under: Certification, DP-900, front-page, Training Tagged With: certifications, dp-900, training

Zero Budget DBA – SQLBITS 2020

2nd October 2020 By John McCormack Leave a Comment

Zero Budget DBA – SQLBITS 2020

SQLBits 2020At SQLBits 2020, I presented the session: The Zero Budget DBA | SQL Community has got your back. The session aimed to highlight some free of charge tools which make life easier for DBAs and other data professionals.

SQLBits usually make past sessions available online. When this occurs, I’ll link to it here so you can rewatch. In the meantime, the session slides and scripts are available to download from my Github profile.

The data source I used for the Paisley Police Department was just a simple csv of Detroit 911 calls from Data.World.

I hope you enjoyed the session. If you have any questions, please feel free to tweet me.

John

Filed Under: front-page, Training Tagged With: DBATools, DLM Dasshboard, First Responder Kit, maintenance solution, sp_whoisactive, sqlbits, statistics parser

Monitor your sql rds instance using CloudWatch

11th August 2020 By John McCormack Leave a Comment

Monitor your SQL RDS instance using CloudWatch

This is a short video on how to monitor your sql rds instance using CloudWatch. Cloudwatch is the built in tool from AWS which can be used to monitor many different resources. Here, we specifically talk about RDS for SQL Server. I also talk you through how to set up alarms to notify you when things go bad, such as high CPU alarms.

Download slides

Course homepage

Filed Under: AWS, AWS RDS, AWS SQL Server, Training

How Multi-AZ Works For SQL Server on RDS

4th August 2020 By John McCormack Leave a Comment

How Multi-AZ Works For SQL Server on RDS

This is a short video about How Multi-AZ Works For SQL Server on RDS. I didn’t feel a demo was needed this time jsut for the sake of it. Enabling Multi-AZ is a click of a button or one line of PowerShell or CLI.

Important: Please read this post for further information. I’ve highlighted some key points in my presentation but there is no point in me simply listing out everything or reading the post verbatim. There is some really great info in this post however so it is well worth reading.

Download slides

Course Homepage | Next video

Filed Under: AWS, AWS RDS, AWS SQL Server, SQL Server, Training

  • 1
  • 2
  • 3
  • Next Page »
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

John McCormack · Copyright © 2025

 

Loading Comments...