Install SSMS using Powershell DSC
Introduction In the previous article, we have seen how to install the SQL Server database engine using Powershell […]
Sites anglophones
Free Video Training: Estimation and Statistics by Dave Ballantyne
It’s hard to find good 400-500 level SQL Server training at any price, let alone free. Dave Ballantyne’s […]
Lancement de la chaine YouTube Data Chouette
Nous avons démarré une nouvelle chaîne YouTube pour les passionnés de données : https://www.youtube.com/@DataChouette Apprenez, explorez et […]
Server Dashboards in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […]
Adding a new AI usage policy to Simple-Talk
I used to think plagiarism was my worst thing to deal with as an editor. That is […]
What PowerBI Questions Do You Have for Eugene Meidinger?
Eugene Meidinger, aka SQLGene.com, makes Power BI concepts easy and accessible. He’s got a free introduction to Power […]
State of the Database Landscape 2024: Shifting skills to match ...
The post State of the Database Landscape 2024: Shifting skills to match constant demands appeared first on SQLServerCentral.
Django's ORM vs. Raw SQL: When to Use Which
When it comes to building websites, how you work with your database can make a huge difference in […]
Top-Down and Bottom-Up Approaches in Microsoft Fabric
Nikola Ilic, best known as Data Mozart, published a great article and video about how to make […]
Query Exercise: Find Tagged Questions Faster.
For this week’s Query Exercise, we’re going to start with an existing query that has performance problems from […]
Finding the Best Time for Maintenance: Answers & Discussion
Your Query Exercise was to find the best time to do database maintenance by querying the Users table, […]
Code Visibility: Browsing through Flyway Migration Files
The post Code Visibility: Browsing through Flyway Migration Files appeared first on SQLServerCentral.
Save 5% on SQLBits Registration with BRENT5.
Going to the SQLBits conference in March? Whether you’re registering in-person or attending virtually, save 5% on your […]
State of the Database Landscape Results 2024
Every year, Redgate surveys technologists to ask a big question (through lots of little questions, naturally.) This […]
Querying MongoDB Documents
MongoDB provides an efficient environment for storing document data at scale. However, most of your interactions with […]
Understanding the Importance of Data Lineage in Modern Data Management
The post Understanding the Importance of Data Lineage in Modern Data Management appeared first on SQLServerCentral.
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 […]
[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.