A Fine Slice Of SQL Server
Hristo Hristov is speaking my language:
Multivariate analysis in data science is a type of analysis that tackles multiple input/predictor and output/predicted variables. This tip explores the problem of predicting air pollution measured in particulate matter (PM) concentration based on ambient temperature, humidity, and pressure using a Bayesian Model.
Click through for a detailed code sample and explanation.
Leave a CommentAndy Brownsword takes a peek at the three most common types of join operators, plus a bonus:
When reviewing our execution plans we’ll see joins executed using different operators. The type of operator is chosen based on the data that’s available to join and how the optimiser wants to execute it.
In this post we’ll take a look at what the operators are, when they are used, and how they work. These are the operators we’ll cover:
- Nested Loop Joins
- Merge Joins
- Hash Match Joins
- (Bonus) Adaptive Joins
Read on for a quick overview of which works best when.
Leave a CommentJon Vöge isn’t content with slicers:
When building Translytical Task Flows for Power BI / Fabric, you’ll quickly come head to head with a few limitations:
- They won’t work in Embedded scenarios
- They won’t work with PBIR and PBIP formats
- They natively only support inputs coming from the three new slicer types: Text, Button and List Slicers (all of which are in preview at the time of writing).
Read on to see how you can partially get around the third limitation.
Leave a CommentGilbert Quevauvilliers does a bit of connecting:
In this blog post I am going to show you how to use the powerful Semantic Link Labs library for Tabular Object Model (TOM) for semantic model manipulation.
The goal of this blog post is to give you an understanding of how to connect using TOM, then based on the documentation use one of the functions.
Don’t get me wrong the documentation is great, but when implementing it, it works a little differently and I want others to know how to use it, so it can automate and simplify some repetitive tasks.
Read on for the instructions and some of the things you can do with the Semantic Link Labs library in Microsoft Fabric.
Leave a CommentTaiob Ali summarizes this month’s T-SQL Tuesday:
I would like to thank all the participants of T-SQL Tuesday #189. If I missed your post, it was not intentional. Please let me know, and I will add it to this list.
I am proud of this community and feel lucky to be a small part of it. I admire everyone who joined the blog party and shared their thoughts on how AI is changing our careers, as well as your thoughts on AI tools.
Click through to see the responses.
Leave a CommentAlexander Korotkov deals with hot page issues:
When many sessions try to insert into the same B-tree leaf page, classic exclusive page locking serializes progress and wastes time on sleep/wake cycles. We’re introducing a batch page insertion path that lets the session holding the page lock insert for itself and its neighbors. The result: dramatically reduced lock waits, and big gains at high client counts (2X throughput boost starting from 64 clients in our benchmark).
Click through to see how it differs from normal PostgreSQL behavior on what is one of the more common performance problems on busy OLTP systems.
Leave a CommentReza Rad merges tables together:
Power Query gives you the capability of joining (merging) tables together using key columns, and there are multiple types of Merge types to choose from. There is another way to merge tables especially when the data source is a relational database system. In this article and video, You will learn how this options works.
Click through for the article and accompanying video.
Leave a Comment