Identifying Customer Buying Pattern in Power BI - Part 1
In this article, we discuss market-based analysis techniques for customer purchasing patterns for different products over the years in Power BI.
2024-04-19
2,607 reads
Articles
Pagination and ordering by large values
Pagination is a technique for limiting output. Think of Google search results, shopping the electronics category on Amazon, or browsing tagged questions on Stack Overflow. Nobody could consume all of the results in a single shot, and no site wants to spend the resources required to present them all to us
2024-04-19
Full vs. Incremental Loads – Data Engineering with Fabric
Learn how to perform full and incremental loads in Fabric with a little SparkSQL.
2024-04-17
6,567 reads
Get the most out of SQL Server Agent logs
If you haven’t migrated your workloads to a managed database platform yet, you’re probably still relying on SQL Server Agent for various maintenance and other scheduled tasks. Most of the time, these processes just work. But when it’s time to troubleshoot, it can be cumbersome to get to the root of some problems.
2024-04-17
Disaster Recovery and High Availability Solutions in SQL Server
Learn about disaster recovery and high availability options in SQL Server with details on the tradeoffs you make when choosing from Availability Groups, Log Shipping, Database Mirroring, and Replication.
2024-04-15
6,372 reads
Finding Sister Locations to Help Each Other: Answers & Discussion
This week’s query exercise asked you to find two kinds of locations in the Stack Overflow database.
2024-04-15
Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts
Learn how it works and how to use the DENSE_RANK() function in your code.
2024-04-12
3,605 reads
Department of Redundancy Department
Ever wonder all the reasons that we use databases instead of file systems? While we don’t think of it too much anymore, the first reason that databases came into existence was to remove redundancies.
2024-04-12
SQL Server Plan Cache Bloat Performance Impacts
Learn about the SQL Server plan cache and how SQL Server caches query plans, and the potential of plan cache bloat which could impact performance.
2024-04-10
Joining Queries in Azure Data Factory on Cosmos DB Sources
This article shows how you can use two Cosmos DB dataets in Azure Data Factory and join them on a common column.
2024-04-08
1,424 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers