5 Advanced Online SQL DBA Training Courses to Learn in 2024 and Beyond

Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most valuable asset: their information. But basic SQL knowledge won't get you far when it's time...

A New Word: ioia

ioia – n.the wish that you could see statistics overlaid on every person you encounter – checking the signal strength of their compatibility, a measure of their trustworthiness. I...

Dynamically Unpivot columns in SQL

Picture this, your data ingestion team has created a table that has the sales for each month year split into different columns. At first glance, you may think “what’s...

Friday Basics: RPO and RTO

I did a post last month titled RTO and RPO are myths unless you've tested recovery, but I only briefly covered what RPO and RTO are. This post goes...

Comment on Two methods of deployment Azure Data Factory by Kamil Nowinski

In reply to <a href="https://azureplayer.net/2021/01/two-methods-of-deployment-azure-data-factory/#comment-22448">Mahesh</a>.

In the past (few years ago) I used <a href="https://github.com/DataThirstLtd/azure.databricks.cicd.tools" rel="nofollow ugc">azure.databricks.cicd.tools</a>, but the tool is deprecated now.
Take a look at Databricks latest & greatest...

Degrees and Trade Schools

Can we normalize a couple of things? 1 – Trade Schools. Back in the 80’s trade classes in high school and post high school were frowned upon, or looked...

Non-Functional Requirements

I have found that non-functional requirements (NFRs) can be hard to define for a given solution. I’ve seen teams struggle with NFRs. However, to ensure I’m speaking the same...

Redgate Summit Comes to the Windy City

I love Chicago. I went to visit three times in 2023: a Redgate event, a volleyball tournament, and a wedding. Each time was a lot of fun and I...

Techorama 2024 – Slides

You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on github.
The post Techorama 2024 – Slides first appeared on Under the kover of business intelligence.

Unlock the Power of Your Data: From Basic to Advanced Data Analysis

Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers to questions that can drive your business forward. To unlock this potential, you need the...