What goes around comes around : T-SQL Tuesday #129

I almost died. I’m sure a lot of you already know this but just to be clear, I should have. ... Continue reading

Why a 60GB Database Backup Grew to 1TB in Size

Recently, I was alerted to a network file share that was running low on disk space. This interesting as there was only one process that used this particular location...

Azure SQL Database – Maxdop Updated

About 1.5 years I wrote about MAXDOP setting within Azure SQL DB, more specifically the fact that the default setting being 0. (https://blobeater.blog/2018/09/12/maxdop-and-azure-sql-db/) Now, you should be aware that...

Daily Coping 10 Aug 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Fixing Broken Pip

I’ve got Python 3.8 on my machine, and recently I got a note that my pip version was old. I tried to upgrade PIP recently with this command: c:python38python.exe...

How to Iterate Through A List of Objects with Terraform's for_each function

What I want to do
# create file local.users.yml
user:
- name: foobar1
email: foobar1@foobar.com
- name: foobar2
email: foobar2@foobar.com
- name: foobar3
email: foobar3@foobar.com

locals {
users_file = "local.users.yml"
users_file_content =...

Should I Transform My Data In My SQL Query?

Watch this week’s video on YouTube. Imagine you need to join two tables of data and filter the results. Perhaps you also need to convert some of the values...

What you need to know About Azure SQL backup

Most of DBA are coming from On-premise Database Servers they know very well How we can manage SQL backup using SQL Server native backup or even using SQL Server...

Adding a FK to a Table–#SQLNewblogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One thing that helps ensure your data is...

Daily Coping 7 Aug 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...