Configuration of Azure SQL Database Auditing
Enhance the security, compliance, and monitoring capabilities of your database system with Azure SQL Database Auditing, a feature-rich […]
Sites anglophones
[Video] Office Hours: The Question is Not the Problem Edition
I answer your top-voted Azure SQL DB and SQL Server questions from https://pollgab.com/room/brento and lose my temper about […]
The Importance of Retention
It is always an afterthought. New objects are created that start off small and current. New feature […]
Buy on-demand access for Summit 2023 today
The post Buy on-demand access for Summit 2023 today appeared first on SQLServerCentral.
Leveraging AI Tools for SQL Queries
Some of the many benefits that AI offers include task automation, increased productivity, and increased efficiency. As an […]
Query Exercise: Find the Best Time for Maintenance
If we’ve gotta take the database down for maintenance – perhaps a version upgrade, perhaps upgrading our own […]
Find Posts with the Wrong CommentCount: Answers & Discussion
Your Query Exercise was to find denormalization accuracy problems: checking the accuracy of a reporting column, Posts.CommentCount. There […]
We’re Starting to Automate Testing for the First Responder Kit.
Brent says: It’s really funny how the world works. I wrote what you see below in December 2023 […]
Working on Technology Off the Clock
I have always spent time learning relational databases on my own, non-work time. As the years have […]
A Simple Method to Load Excel Data
Problem When we need to load data from Excel sheets to a SQL Server table, we typically use […]
[Video] Office Hours: Ask Me Anything About the Microsoft Data ...
Forgive the hoarse voice – I’m recovering from something COVID-ish. I went through your top-voted questions from https://pollgab.com/room/brento […]
Dimensional Modelling Case Study Part 1 – Age Group
Background Age plays an important role in medicine and medical research. A patient’s ages is commonly grouped into […]
Query Exercise: Find Posts with the Wrong CommentCount
For 2024, I’m trying something new: weekly homework challenges! For this week’s query challenge, we’re going to do […]
The Mastering Azure Data Studio Series
This is the index for a series of articles on Azure Data Studio (ADS), which will help you […]
Semantic Model: More than a Simple Name Change
The animation on the top of this article tries to track the evolution of the enterprise architecture […]
Find Foreign Key Problems: Answers & Discussion
Your Query Exercise was to find foreign key problems: data that might stop us from successfully implementing foreign […]
Adding Cookie Consent to SQL Server Central
To comply with various regulatory requirements, we are adding a cookie consent form to the website. You will […]
Connecting SQL Server to SaaS applications with a Linked Server
The post Connecting SQL Server to SaaS applications with a Linked Server appeared first on SQLServerCentral.
An In-Depth Look at MIXED_PAGE_ALLOCATION and Changes in Page Allocation
When it comes to managing data in SQL Server, efficient page allocation is crucial for performance and storage […]
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 […]
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?!? […]