Tuesday – Data Tuesday
Every Tuesday we have videos related today. These will focus on Azure Synapse Analytics and related technologies such as Azure Data Explorer (Kusto) and more…
Why not a date and time table in Power BI instead?
We had a video talking about creating a Date and Time table in your Microsoft Fabric Warehouse. There were some comments centered around "why"??? Why not do that in Power BI? Patrick shows you!
A Few Ways GENERATE_SERIES Will Revolutionize Your Microsoft Fabric Warehouse Experience
Want to create a series of data within a Microsoft Fabric Warehouse? Patrick looks at how GENERATE_SERIES can help you instead of doing INSERT after INSERT which doesn't perform well. Scripts: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Fabric/20241017%20-%20Generate%20Series.zip GENERATE_SERIES (Transact-SQL) https://learn.microsoft.com/sql/t-sql/functions/generate-series-transact-sql?view=sql-server-ver16 [...]
Some GOTCHAs when using Mirroring in Microsoft Fabric
Mirroring in Microsoft Fabric can be very powerful but setting them up can sometimes have some frustrations. Patrick walks you through the challenges he hit and how he got around it. What is Mirroring in [...]
Unleashing Data for OneLake with Mirroring in Microsoft Fabric
Learn how to replicate your database to Microsoft Fabric using Mirroring! Patrick walks you through how you can do this with Azure SQL Database and CosmosDB and join across the two. What is Mirroring in [...]
Expert Guide: GitHub Integration for Microsoft Fabric
We talked about Git integration with Azure DevOps in the past, but now you can integrate GitHub with Microsoft Fabric! Once things are configured most things are the same because it's just Git! Adam walks [...]
Which Microsoft Fabric SQL Analytics Endpoint should you use?
Both the Microsoft Fabric lakehouse and warehouse have a SQL Analytics Endpoint. But they have different limitations. Which one is the right one to use? Patrick breaks it down! Better together: the lakehouse and warehouse [...]