Microsoft will be presenting a number of sessions at the PASS Data Community Summit 2023. Read about their plans for the event and register to come if you can.
2024-05-14 (first published: 2023-11-03)
276 reads
This article shows how one can run a machine learning activity in an Azure Data Factory (ADF) pipeline.
2024-05-13
713 reads
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
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
1,300 reads
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
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
Learn how to query data in Azure Data Explorer using Python.
2024-05-06
695 reads
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
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,345 reads
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
Let’s have devs look at their own query performance. Yes, please, sign me up...
This June, LearnSQL is throwing down the gauntlet with a fresh SQL Practice challenge....
By Steve Jones
I delivered a talk today on database deployment best practices at the Denver Dev...
Hi I am brand new to Data Factory I am getting the following error...
I want to set the execution timeout in SSMS Connection properties on the 'Connect...
Comments posted to this topic are about the item The SQL Assessment API