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
5,464 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,483 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)
6,942 reads
Learn about the differences and challenges with implicit and explicit measures in Power BI.
2025-02-05 (first published: 2025-01-06)
26,395 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,688 reads
This article shows how to configure database mirroring from CosmosDB to Microsoft Fabric.
2024-06-10
1,363 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,909 reads
2015-09-25 (first published: 2013-04-11)
12,003 reads
This article describes different methods for deploying your SSIS projects to a server.
2013-08-15
10,090 reads
2013-04-10
10,694 reads
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
By Steve Jones
This month we have a new host, which I am grateful for. So many...
I needed to do some research because there is more to #temp tables than...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
Comments posted to this topic are about the item The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers