T-SQL Tuesday 174 - Your Favorite Job Interview Questions

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Kevin Feasel
(blog | twitter) asks us about job interview questions.

What is your...

Full-Text Search in SQL Server: A Comprehensive Guide

Introduction Full-Text Search in SQL Server is a feature that provides linguistic search capabilities against text data in SQL Server tables. It allows for searching of character-based data types...

Reading JSON Data with Python

Recently I’ve been looking at archiving some data at SQL Saturday. As a start, I needed to read some of the archive data I have in Python. This post...

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...

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...

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...

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...

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...

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.