Sites anglophones

We’re Starting to Automate Testing for the First Responder Kit.

Publié le 16 janvier 2024 sur

Brent says: It’s really funny how the world works. I wrote what you see below in December 2023 and scheduled it for publication on January 16th (today), hoping to get help from the community to get this process started. On January 9, before the p …


Working on Technology Off the Clock

Publié le 16 janvier 2024 sur

I have always spent time learning relational databases on my own, non-work time. As the years have passed, I have spent less of my own free time on technical learning and writing for many reasons, but still, I spend plenty of my own time learning about …


A Simple Method to Load Excel Data

Publié le 15 janvier 2024 sur

Problem When we need to load data from Excel sheets to a SQL Server table, we typically use a data flow task. This task doesn’t have the flexibility that we often need and requires a strict orchestration of components to be able to work consistently. T …

[Video] Office Hours: Ask Me Anything About the Microsoft Data Platform

Publié le 12 janvier 2024 sur

Forgive the hoarse voice – I’m recovering from something COVID-ish. I went through your top-voted questions from and did my best: Here’s what we covered: 00:00 Start 03:03 DBANoob: We have EF code that …

Dimensional Modelling Case Study Part 1 – Age Group

Publié le 12 janvier 2024 sur

Background Age plays an important role in medicine and medical research. A patient’s ages is commonly grouped into small number of age ranges, reflecting the severity of certain disease on different age groups. With COVID-19 still ravaging the world, i …

Query Exercise: Find Posts with the Wrong CommentCount

Publié le 11 janvier 2024 sur

For 2024, I’m trying something new: weekly homework challenges! For this week’s query challenge, we’re going to do some data validation. Pop open the Stack Overflow database and check out the CommentCount column on the Posts table: In …

The Mastering Azure Data Studio Series

Publié le 10 janvier 2024 sur

This is the index for a series of articles on Azure Data Studio (ADS), which will help you understand how to work with this tool and become productive when developing or managing code on SQL Server. The articles in this series are: Getting Started with …


Semantic Model: More than a Simple Name Change

Publié le 10 janvier 2024 sur

The animation on the top of this article tries to track the evolution of the enterprise architecture since SQL Server 7.0 introduced tools for ETL, Semantic model and much more. Some of you probably remember these tools as SSIS and SSAS. At that t …


Find Foreign Key Problems: Answers & Discussion

Publié le 10 janvier 2024 sur

Your Query Exercise was to find foreign key problems: data that might stop us from successfully implementing foreign keys in the Stack Overflow database. Question 1: Write queries to find the problematic data. Montro1981’s thorough answer broke t …

Adding Cookie Consent to SQL Server Central

Publié le 10 janvier 2024 sur

To comply with various regulatory requirements, we are adding a cookie consent form to the website. You will see this banner at the bottom if you have not accepted or rejected cookies before. You can control which types of cookies and data you are allo …

Connecting SQL Server to SaaS applications with a Linked Server

Publié le 10 janvier 2024 sur

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

Publié le 10 janvier 2024 sur

When it comes to managing data in SQL Server, efficient page allocation is crucial for performance and storage utilization. In recent years, there have been significant changes in the way SQL Server allocates pages for data storage, specifically with t …

Announcing the 2024 Data Professional Salary Survey Results.

Publié le 9 janvier 2024 sur

This is the 8th year now that we’ve been running our annual Data Professional Salary Survey, and I was really curious to see what the results would hold this year. How would inflation and layoffs impact the database world? Download the raw data h …


Optimized locking in Azure SQL Database

Publié le 8 janvier 2024 sur

I don’t think I’ve ever had a great impression of Azure SQL Database as a place for production applications. In its early days, it was missing several important features (like data compression). While that hole has been plugged, there are s …


Machine learning K-Means applied to SQL Server data

Publié le 8 janvier 2024 sur

Introduction In this article, we will use K-Means applied to SQL Server using Python. We will learn what is the K-Means algorithm, how to use Python to create charts, and how to connect to SQL Server. The data in SQL Server will be segmented in cluster …

Pages :