Using Machine Learning Pipeline Execution Activity in Azure Data Factory
This article shows how one can run a machine learning activity in an Azure Data Factory (ADF) pipeline.
2024-05-13
455 reads
Articles
Read Data Stored in a Lake Database using Azure Synapse Analytics
In this article, we look at how to read data stored in a lake database using Azure Synapse Analytics to help reduce overall Azure costs.
2024-05-13
Identifying Customer Buying Pattern in Power BI - Part 2
In this article, we develop the Power BI DAX formula for basket analysis. It is the technique used in retail industry for market based analysis.
2024-05-10
943 reads
Database Subsetting and Data Extraction
Let’s start by defining a subset and why you would require a data subset? When dealing with the development, testing and releasing of new versions of an existing production database, developers like to use their existing production data.
2024-05-10
SQL Server Filtered Index Essentials Guide
Learn about using filtered indexes for SQL Server tables and some of the potential issues you might be faced with when using a filtered index.
2024-05-08
Ingest and Retrieve data from an ADX Cluster Using Python
Learn how to query data in Azure Data Explorer using Python.
2024-05-06
608 reads
Snake draft sorting in SQL Server, part 2
In my previous post, I showed how to borrow a snake draft concept from fantasy football, or a packing technique from the shipping industry, to distribute different portions of a workload to run in parallel.
2024-05-06
Database Dashboards in Azure Data Studio
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. In this article, I want to look at the database dashboards and how you can customize them. The other articles in this series on ADS works […]
2024-05-03
2,043 reads
Managing Failed Pipeline Runs in Azure Data Factory
In this article, we look at how to setup different ways to handle pipeline failures and notifications when working with Azure and Azure Data Factory.
2024-05-03
Metadata Driven Pipelines – Data Engineering with Fabric
This article explains metadata driven pipelines and shows an example in Microsoft Fabric.
2024-05-01
1,867 reads
Blogs
T-SQL Tuesday #174: Your Favorite Job Interview Question
My blog has been quiet lately. I recently wrapped up a master’s program (more...
I like KQL and I like managing my test data – are they mates?
By HeyMo0sh
Test Data Management (TDM) is essential in software development to ensure your application runs...
T-SQL Tuesday 174 - Your Favorite Job Interview Questions
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Summarizing Raw Sales Data with Group Summaries and Final Summary
Greetings, I need to transform data returned in a query from several tables as...
Subscription to Oracle DB not working after upgrading subscriber to Oracle 19c
Hi Replication and publisher configured on the same sql server 2022 version. Subscription to...
Script to Merger duplicate indexes
Hello, I am trying to firgure out how to merge duplicate indexes using a...
Question of the Day
The Query Traceflag
If I want to enable a trace flag for a specific query, how do I do it?
See possible answers