Combining Silver Tables into a Model – Data Engineering with Fabric
This next article in the series creates objects at the gold layer for consumption by combining tables from the silver layer of the lake house.
2024-05-15
1,057 reads
This next article in the series creates objects at the gold layer for consumption by combining tables from the silver layer of the lake house.
2024-05-15
1,057 reads
In the first part of this two-part series, I covered the mostly non-technical aspects of building a data culture. While the lion’s share of the work will be getting people to work together and embrace ever deeper use of data, as a reader of Simple-Talk, a lot of this transition will be technical.
2024-05-15
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)
261 reads
This article shows how one can run a machine learning activity in an Azure Data Factory (ADF) pipeline.
2024-05-13
547 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,036 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
625 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
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....
By Steve Jones
This month is a great topic to me. I think growing and improving your...
By Brian Kelley
Once upon a time, I used to think of difficult technical questions to ask...
Is there a trigger to notify when a new SQL Agent job is created/modified?
Hello I have a view based upon a number of tables I'm selecting...
In an Azure SQL Managed Instance there is no option to create what we...
In which editions can I use Full-Text and semantic search?
See possible answers