What is OneLake in Microsoft Fabric?
Learn about Microsoft Fabric and OneLake which is a single logical data lake for the entire Fabric platform in your organization.
2023-12-29
Microsoft Fabric (Azure Synapse, Data Engineering, etc.)
What is Microsoft Fabric all about?
In this article, we will introduce Microsoft Fabric and how it relates to Power BI Premium Capacity we will turn to the mechanics of capacity utilization, and we will briefly look at how to monitor the performance loads of our Fabric resources.
2023-12-22
Source Control with GIT, Power BI and Microsoft Fabric
Source control is fundamental when dealing with projects and sharing code between multiple developers. Power BI present some challenges related to source control. But it’s finally providing us with a solution to these challenges. Let’s analyse this piece-by-piece.
2023-12-18
What are Warehouses in Microsoft Fabric?
In this article, we look at using Microsoft Fabric to build a data warehouse and some things you should know about doing this.
2023-11-20
Using Pipeline Return Value in Azure Data Factory and Azure Synapse Analytics
Learn how you can return data from one ADF pipeline for use in another.
2023-11-01
5,270 reads
Provisioning Microsoft Fabric: A Step-by-Step Guide for Your Organization
See how to get started with Microsoft Fabric.
2023-08-21
8,472 reads
Archive to the Lake
Microsoft Fabric changes the paradigm for how you might store data in your warehouse.
2023-08-07
242 reads
Create Your First Pipeline in Microsoft Fabric
Learn how to get started with a Microsoft Fabric pipeline.
2023-08-02
4,555 reads
Create Dynamic External Table in Azure synapse Analytics
This script creates an external table in Synapse.
2023-08-21 (first published: 2023-07-26)
1,263 reads
What is OneLake in Microsoft Fabric?
Get ready to be blown away! The highly anticipated Microsoft Build in May 2023 has finally unveiled its latest and greatest creation: the incredible Microsoft Fabric - an unparalleled Data Intelligence platform that is guaranteed to revolutionize the tech world! fig 1: OneLake for all Data One of the most exciting things in Fabric I […]
2023-07-26
5,382 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers