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
3,245 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
3,245 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)
301 reads
This article shows how one can run a machine learning activity in an Azure Data Factory (ADF) pipeline.
2024-05-13
1,070 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,815 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
1,282 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
The honeymoon is over, and macOS 26 Tahoe broke the Rosetta 2 emulation layer...
By Chris Yates
There are moments in technology when the ground shifts beneath our feet. Moments when...
Why Developers Shouldn’t Have sysadmin access in SQL Server 7 reasons—and exactly what to do instead It...
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Comments posted to this topic are about the item Find Invalid Objects in SQL...
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer @customername varchar(200) AS BEGIN DECLARE @added VARCHAR(100) SELECT @added = xxx IF @customername IS NOT NULL INSERT dbo.Customer ( CustomerName, AddedBy ) VALUES (@customername, @added) ENDSee possible answers