Who’s Changing the Table? Answers and Discussion
Your challenge for this week was to find out who keeps mangling the contents of the AboutMe column in the Stack Overflow database. Conceptually, there are a lot of ways we can track when data changes: Change Tracking, Change Data Capture, temporal tabl …
SQL Server Filtered Index Essentials Guide
The post SQL Server Filtered Index Essentials Guide appeared first on SQLServerCentral.
SQL ConstantCare® Population Report: Spring 2024
The short story: SQL Server 2019 appears poised to swallow the SQL Server market altogether, hahaha. The long story: ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates? Let’s …
How to Build Metadata Driven Pipelines in Microsoft Fabric
Over the past years, “traditional” ETL development has morphed into data engineering, which has a more disciplined software engineering approach. One of the benefits of having a more code-based approach in data pipelines is that it has beco …
[Video] Office Hours: Ask Me Anything About Azure and Microsoft Databases
Back at home in the office, time to settle in with a nice caffeine-free Diet Coke and go through your top-voted questions from https://pollgab.com/room/brento. Why caffeine-free? Because I slug multiple coffees first thing in the morning when I wake up …
Ingest and Retrieve data from an ADX Cluster Using Python
Introduction Azure Data Explorer (ADX) helps to analyze high volumes of data in near real-time. The Azure Machine Learning (AML) Python SDK v2 is an updated Python SDK package. It helps to build a single command or a chain of commands like Python funct …
The Curious Case of… missing log information
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some t …
Who’s Hiring in the Microsoft Data Platform Community? May 2024 Edition
Is your company hiring for a database position as of May 2024? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must includ …
Database Dashboards in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the database dashboards and how you can customize them. T …
Managing Failed Pipeline Runs in Azure Data Factory
The post Managing Failed Pipeline Runs in Azure Data Factory appeared first on SQLServerCentral.
Query Exercise: Who’s Changing the Table?
For this week’s Query Exercise, your challenge is to find out who keeps messing up the rows in the Users table. Take any size version of the Stack Overflow database, and the Users table looks like this: People are complaining that from time to ti …
It’s Time For Our Annual Anniversary Sale!
I first registered BrentOzar.com way back in May 2001. Over the years, some things in databases have changed a lot, but some things still remain the same. Every year, people get handed applications and databases, and they’re told, “The back …
Metadata Driven Pipelines – Data Engineering with Fabric
What is a metadata driven pipeline? Wikipedia defines metadata as “data that provides information about other data.” As a developer, we can create a non-parameterized pipeline and/or notebook to solve a business problem. However, if we must solve the s …
PySpark Secrets to use with Fabric
PySpark is a powerful language for data manipulation and it’s full of tricks. Let’s discover some of them. Control the Type of a NULL column If you are creating a pysspark dataframe, but one of the columns contains only null values (None), …
Join Me at the PASS Data Community Summit in November!
On November 4 in Seattle, I’m presenting a new pre-conference workshop! Tuning T-SQL for SQL Server 2019 and 2022 You’ve been working with SQL Server for a few years, and you’re comfortable writing queries and reading execution plans. …