Comparing Groups for Similarities in Power Query – Using Cosine Similarity
The post Comparing Groups for Similarities in Power Query – Using Cosine Similarity appeared first on SQLServerCentral.
[Video] Office Hours: Long Answers Edition
Today’s questions from https://pollgab.com/room/brento require a little bit longer answers: Here’s what we covered: 00:00 Start 03:20 Josef: What is table partitioning, and can it improve performance? Does its effectiveness depend on the un …
I Feel Sorry for Untrained Developers Using Entity Framework.
Most of the time, I love Entity Framework, and ORMs in general. These tools make it easier for companies to ship applications. Are the apps perfect? Of course not – but they’re good enough to get to market, bring in revenue to pay salaries, …
A Use Case for Memory-Optimized Tempdb Metadata
I recently had an interesting production SQL Server issue that turned out to be very easy to fix. The fix doesn’t fit every workload or server, but for the limited use cases described below, it’s a simple configuration change. The general best practice …
SQL Server OPTION RECOMPILE for Simple Queries
The post SQL Server OPTION RECOMPILE for Simple Queries appeared first on SQLServerCentral.
How to Load a Fabric Warehouse: Data Engineering with Fabric
The data warehouse in Microsoft Fabric was re-written to use OneLake storage. This means each and every table in the warehouse is based on the Delta file format. Staying away from single transactions will keep the warehouse performing at its best. W …
Who’s Hiring in the Microsoft Data Platform Community? January 2025 Edition
Is your company hiring for a database position as of January 2025? 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 …
Data Documents and Common Sense
The post Data Documents and Common Sense appeared first on SQLServerCentral.
Why you should avoid Implicit Measures in your Power BI model
Everyone who has dabbled around with Power BI knows probably the concept of measures (if not, here’s a good refresher). Measures are calculations using the DAX formula language (which kinds of resemble Excel formulas, at least the easy calculations do) …
Improved RCSI Ghost Cleanup in SQL Server 2022
The post Improved RCSI Ghost Cleanup in SQL Server 2022 appeared first on SQLServerCentral.
Leveraging the “STUFF” Function for Enhanced Data Representation and String Manipulation
Abstract In the realm of data management and business intelligence, effective data representation becomes crucial for deriving actionable insights. This is true specially when dealing with raw data, where inconsistencies and scattered information acros …
Oracle Architecture Overview
I often fall back to the tried-and-true methods to understanding Oracle environments. Yes, sometimes the older ways are best, but understanding where Oracle has been and where it’s going is essential to us building the best products to support this ent …
2024: the year in books
Back in 2009 I started posting a summary at the end of the year of what I read during the year and people have been enjoying it so I did it every year afterward until 2019 and then restarted for 2023 (see 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, …
Five changes to SQL Server I’d love to see
I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very few of my dreams ever come true. Still, it’s fun every once in a while, to be whimsical about the way I wished SQL Server worked. Especially in January because, …
[Video] Office Hours in Tokyo, Japan
For the last Office Hours of the year, I’m coming to you from Tokyo, the last stop on my 3-week tour of China and Japan. This was a big Epic Life Quest task for me, for sure, something I’ve wanted to do for decades. Let’s bring you al …