This article shows how you can easily create connections in your Power BI workspace that use Identity Authentication to connect to your data.
2025-09-05
3,276 reads
When you run a CI/CD pipeline, you often need confidential values like passwords, authentication tokens, service principal secrets etc. when you want to deploy a certain artefact. You don’t want to store those secrets directly in your pipelines as this might pose a considerable security leak. Instead, you either store them as secret variables, or […]
2025-09-02 (first published: 2025-08-04)
1,119 reads
Building pipelines in Microsoft Fabric can be complicated, and it's easy to write code that is hard to maintain. Using parameters in your connections helps to build pipelines that are easily configured.
2025-07-04 (first published: 2025-06-02)
4,826 reads
Learn about the differences and challenges with implicit and explicit measures in Power BI.
2025-02-05 (first published: 2025-01-06)
21,063 reads
In this article, you will learn how to send messages through a RabbitMQ queue and deliver those to a Microsoft Fabric Eventstream.
2024-07-12
1,583 reads
This article shows how to configure database mirroring from CosmosDB to Microsoft Fabric.
2024-06-10
1,209 reads
Learn how to optimize the size of your Power BI semantic models with the free Vertipaq Analyzer tool. Extra tips & tricks included.
2024-03-22
4,442 reads
2015-09-25 (first published: 2013-04-11)
11,994 reads
This article describes different methods for deploying your SSIS projects to a server.
2013-08-15
10,072 reads
2013-04-10
10,649 reads
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Comments posted to this topic are about the item Faster Data Engineering with Python...
Comments posted to this topic are about the item Which Result II
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
exec('SELECT ProductName FROM product;')
END;
GO
exec etl.GettheProduct
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers