Announcing the 2024 Data Professional Salary Survey Results.
This is the 8th year now that we’ve been running our annual Data Professional Salary Survey, and I […]
Sites anglophones
Optimized locking in Azure SQL Database
I don’t think I’ve ever had a great impression of Azure SQL Database as a place for […]
Machine learning K-Means applied to SQL Server data
Introduction In this article, we will use K-Means applied to SQL Server using Python. We will learn what […]
PowerShell Dynamic Parameters and SQL Server
Have you ever been in a situation that you want to call a cmdlet or a function […]
New Power BI Explore this Data Feature: An Alternative to ...
The post New Power BI Explore this Data Feature: An Alternative to Excel Pivot Tables appeared first on […]
Dijkstra's Algorithm
Introduction This article celebrates a classic algorithm [1] of Dijkstra (1930 – 2002) which finds a path of […]
Query Exercise: Find Foreign Key Problems
For 2024, I’m trying something new: weekly homework challenges! For this week, let’s say we’ve decided to implement […]
Being A Bit Less Comfortable in 2024
I hate coming up with ideas for editorials, but my last editorial of the year gives me […]
[Video] Office Hours: Oddball Questions Edition
The last Office Hours of 2023 featured some oddball questions from https://pollgab.com/room/brento. Not bad, just … odd. Here’s […]
SQL Window Functions Series: NTILE()
Continuing our journey through SQL’s handy window functions, we now tackle the NTILE() function. After exploring LAG(), LEAD(), […]
Kickstart the year with our free Livestream! Navigating the database ...
The post Kickstart the year with our free Livestream! Navigating the database landscape in 2024 appeared first on […]
Two-Dimensional Interval Packing Challenge
Packing intervals is a classic SQL task that involves packing groups of intersecting intervals to their respective […]
Who’s Hiring in the Microsoft Data Platform Community? January 2024 ...
Is your company hiring for a database position as of January 2024? Do you wanna work with the […]
Comparing Azure Analysis Services with On-Premises SQL Server Analysis Services
The post Comparing Azure Analysis Services with On-Premises SQL Server Analysis Services appeared first on SQLServerCentral.
Backup SQL Server on Linux Databases using SQL Server Agent ...
The post Backup SQL Server on Linux Databases using SQL Server Agent on Windows appeared first on SQLServerCentral.
Warehouse Load Patterns – Part 2 – Load Patterns
This continues and finishes my two-part series on warehouse load patterns. There are many methods to transfer […]
[Video] Office Hours: Holiday Speed Round Edition
Most of the https://pollgab.com/room/brento questions from this episode had really short and sweet answers. Let’s take a break […]
The Profiler Extension in Azure Data Studio (ADS)
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […]
Updated First Responder Kit and Consultant Toolkit for December 2023
New this month: more work on letting sp_Blitz run with limited permissions, nicer Markdown output, sp_BlitzLock compatibility with […]
Eager Aggregation in SQL queries
Aggregation is a widely used way to summarize the content of a database. It is usually expressed […]
[Video] Working on First Responder Kit Pull Requests
For this month’s First Responder Kit releases, I worked through most of the pull requests live on my […]
Understanding Maximum Server Memory in SQL SERVER
Editor: For SQL developers looking to optimize their SQL Server’s performance, one crucial aspect to understand and implement […]
Most Overlooked Features in Power BI
The post Most Overlooked Features in Power BI appeared first on SQLServerCentral.
Introducing the MongoDB Document
MongoDB is a document database. As such, the data is stored as individual documents. A document is […]
The Annual Data Professional Salary Survey Closes This Week!
Take the Data Professional Salary Survey now. The 2020s have been tough: a pandemic, a recession, layoffs, and […]
Building Reports with Power BI vs Tableau from SQL Server ...
The post Building Reports with Power BI vs Tableau from SQL Server Data appeared first on SQLServerCentral.
Docker Security Principles Overview
The post Docker Security Principles Overview appeared first on SQLServerCentral.
Creating a Hyperscale Database in Azure Using the Azure Portal
Data is the lifeblood of contemporary enterprises in the digital age. Managing and growing databases to fulfill these […]
[Video] Office Hours: 21 Good Questions
This one is a 3-part episode: I take 21 questions from https://pollgab.com/room/brento and then later, work on First […]
Counting more efficiently
Nearly a decade ago, I wrote a post called “Bad habits : Counting rows the hard way.” […]
[Video] Office Hours: Wrong Side of the Bed Edition
I woke up on the wrong side of the bed after a nap. How does that even happen?!? […]
Sending resource alerts on Managed Instance using db_mail
The post Sending resource alerts on Managed Instance using db_mail appeared first on SQLServerCentral.
Why Don't You Upgrade in Place?
Ask a senior-level SQL Server or Windows administrator about doing in-place upgrades and you’ll likely get a negative […]
Interesting Aurora MySQL Feature: The Buffer Pool Survives Restarts
“Documentation! Hey, look at that.” Lemme start this off by saying this is probably irrelevant to you. (It’s […]
Le DataOps pour Power BI et Microsoft Fabric
Petit article de retour sur un événement communautaire du Club Power BI Les communautés sont des groupes […]
Using a SQL Tokenizer
Imagine this: you have several directories full of SQL script files, and you need to know where […]
Configuring an SSIS ForEach Loop for Multiple File Types
The Problem The SSIS Foreach Loop component has a limitation when it comes to selecting different sets of […]
Using Spark Jobs for Multiple Lakehouse Maintenance in Microsoft Fabric
I have published videos and articles before about Lakehouse maintenance. In this article I want to address […]
Searching an Encrypted Column
When encrypting a database column, equality searching can be preserved by using a deterministic encryption algorithm. A deterministic […]
Running Azure CosmosDB queries from SQL Server using ODBC driver
The post Running Azure CosmosDB queries from SQL Server using ODBC driver appeared first on SQLServerCentral.
MySQL Error Log Management in DevOps Operations
When it comes to the development and operations (DevOps), one thing stands out as a critical aspect […]
[Video] Office Hours: Sunshine Edition
You know how this works: you posta the questions at https://pollgab.com/room/brento, and I giva the answers: Here’s what […]
Fabric Notebooks and Deployment Pipelines
On my article about Fabric source control extended features, I explained how Microsoft included the notebooks on […]
[Video] Office Hours: Really Good Questions Edition
Y’all were on fire in this one! You posted great questions at https://pollgab.com/room/brento and I worked through ’em: […]
SQL GROUP BY Alias – An Oracle feature that would ...
The post SQL GROUP BY Alias – An Oracle feature that would be great in SQL Server appeared […]
What Would You Ask Your Predecessor? Get Answers with ChatGPT.
So many times in my career, I’ve come across a questionable query, table design, or server configuration decision, […]
Exploring PostgreSQL Indexes
In this blog, we continue our exploration on PostgreSQL indexes which we started here. In that article, […]
What is subsetting, what are the advantages, and how does ...
The post What is subsetting, what are the advantages, and how does it make test data management easier? […]
Identify log write limits on Azure SQL Managed Instance using ...
The post Identify log write limits on Azure SQL Managed Instance using QPI library appeared first on SQLServerCentral.
SQL Window Functions Series: LAG() and LEAD()
In the realm of data analysis, being able to understand the relationships between sequential data points is paramount. […]