Microsoft Fabric: Import On Premise SQL Server Data into Fabric SQL Database!

Azure SQL Database in Microsoft Fabric, aka Fabric SQL Database, aka #FabSQL is here! Now we need to get data into it! In this video Bradley Ball, aka ‪@SQLBalls‬ , guides you through installing an On Premise Data Gateway, connecting it to your #MicrosoftFabric Tenant, and then building a Dynamic Data Pipeline to import the data into Fabric SQL DB! Chapters 00:00 Dynamic Import for Fabric SQL Database 00:58 Demo Enable Fabric SQL Database at the Tennant 01:36 Demo Create Fabric SQL Database 02:03 Demo Install On Premise Data Gateway 02:52 Demo Create Connection to On Premise SQL Server 03:38 Demo T-SQL Query to Dynamically Get Tables & Schemas 03:58 Demo Create Dynamic Data Pipeline to Import Data 07:18 Demo Validate Data Transfer 08:01 Demo Check the Mirror for Replication SQL database in Microsoft Fabric (Preview) https://learn.microsoft.com/en-us/fab... Microsoft Fabric decision guide: choose a SQL database https://learn.microsoft.com/en-us/fab... Install an on-premises data gateway https://learn.microsoft.com/en-us/dat... Data Factory documentation in Microsoft Fabric https://learn.microsoft.com/en-us/fab... Ingest data into your Warehouse using data pipelines https://learn.microsoft.com/en-us/fab... /******************* /CONNECT WITH US!! /******************* Tales from the Field Twitter:   / talesftfield   Linkedin:   / 100091910   Blusky: https://bsky.app/profile/talesfromthe... Bradley Ball Twitter:   / sqlballs   Linkedin:   / sqlballs   Blusky : https://bsky.app/profile/sqlballs.bsk... Daniel Taylor Twitter:   / dbabulldog   Linkedin:   / danieltaylor3   Blusky: https://bsky.app/profile/dbabulldog.b... Neeraj Jhaveri Twitter:   / neeraj_jhaveri   Linkedin:   / neerajjhaveri   Blusky: https://bsky.app/profile/neerajny.bsk... Josh Luedeman Twitter:   / joshluedeman   Linkedin:   / joshluedeman   Blusky: https://bsky.app/profile/joshluedeman... Andrés Padilla Twitter:   / nodestreamio   Linkedin:   / andrespadillaandrade