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.
Backup SQL Server on Linux Databases using SQL Server Agent on Windows
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 rows between systems from a basic design perspective. This isn’t specific to any ETL tool but rather the basic patterns for moving data. …
[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 for the holidays and knock ’em out: Here’s what we covered this episode: 00:00 Start 03:29 TheyBlameMe: Hav …
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 on how the tool works, and this one continues the series, taking a look at another extension: the SQL Server Profiler extension. The other articles in …
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 Managed Instances, and more. Wanna watch me use it? Take the class. To get the new version: Download the updated FirstRes …