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 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.
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
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
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 …
PowerShell Dynamic Parameters and SQL Server
Have you ever been in a situation that you want to call a cmdlet or a function with a parameter that depends on a conditional criteria that is available as a list? In this article I will show a technique where you can use PowerShell Dynamic Parameters …
New Power BI Explore this Data Feature: An Alternative to Excel Pivot Tables
The post New Power BI Explore this Data Feature: An Alternative to Excel Pivot Tables appeared first on SQLServerCentral.
Dijkstra's Algorithm
Introduction This article celebrates a classic algorithm [1] of Dijkstra (1930 – 2002) which finds a path of minimal cost between any pair of nodes in an undirected graph. His procedure is widely recognized as a fundamental tool for examining communica …
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 foreign keys, and we need to find data that’s going to violate our desired keys. We’re going to use the St …
Being A Bit Less Comfortable in 2024
I hate coming up with ideas for editorials, but my last editorial of the year gives me a very simple topic just staring me in the face: New Year’s Resolutions. Love them or hate them (or it we are honest, a good bit of both,) this end of one …
[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. https://youtu.be/prkpWssHsaE Here’s what we covered: 00:00 Start 03:04 TheMooneyFlyer: Hey Brent, how do you work on op …
SQL Window Functions Series: NTILE()
Continuing our journey through SQL’s handy window functions, we now tackle the NTILE() function. After exploring LAG(), LEAD(), RANK(), and DENSE_RANK(), NTILE() stands out for splitting data into clear, ordered groups. It’s perfect for grading perform …
Kickstart the year with our free Livestream! Navigating the database landscape in 2024
The post Kickstart the year with our free Livestream! Navigating the database landscape in 2024 appeared first on SQLServerCentral.
Two-Dimensional Interval Packing Challenge
Packing intervals is a classic SQL task that involves packing groups of intersecting intervals to their respective continuous intervals. In mathematics, an interval is the subset of all values of a given type, e.g., integer numbers, between some low va …
Who’s Hiring in the Microsoft Data Platform Community? January 2024 Edition
Is your company hiring for a database position as of January 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 in …
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.