SQL Aggregate Functions: Your Essential Guide & Cheat Sheet

SQL aggregate functions are your go-to tools for transforming raw data into actionable insights. They condense multiple rows into single, meaningful values, making it easier to grasp the big...

T-SQL Tuesday #174 – My Favorite Interview Question

This month is a great topic to me. I think growing and improving your career is a skill that most of  us could improve, especially in our younger years....

T-SQL Tuesday #174: Job Interview Questions

Once upon a time, I used to think of difficult technical questions to ask candidates for a DBA position. However, over time I came to understand that in most...

Power BI: Refreshable Excel Files in PBI Service

Ever since Excel made its debut in the 1980’s, it has been used as a quick way for end users to input and manipulate data on their own without...

T-SQL Tuesday #174: Your Favorite Job Interview Question

My blog has been quiet lately. I recently wrapped up a master’s program (more details on that soon, once the formal graduation is behind me) and have been immersed...

Getting Error 64 When Trying To Connect to SQL Server or Azure 

Often times when working with a client, I’ll run into issues or get emails from a client with a message like the following: A connection was successfully established with...

I like KQL and I like managing my test data – are they mates?

Test Data Management (TDM) is essential in software development to ensure your application runs smoothly and reliably across different environments. When deploying applications in Azure, Test Data Management can...

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