Our latest MS Tech Bit is LIVE! @sqlballs.bsky.social#MicrosoftFabricyoutu.be/iWepPEUUO_4@joshluedeman.bsky.social@dbabulldog.bsky.social
You want an End to End tutorial using Real-Time Analytics in #MicrosoftFabric! Look no further! We did this a while ago, but the screens have changed and new capabilities were added and some were moved. Bradley Ball, aka @SQLBalls , walks you through how to Track the International Space Station live streaming the geoposition into Microsoft Fabric and then building a Power BI Report on the KQL Database! Chapters 00:00 Don't You Hate it When 01:59 Demo Logic App Setup 02:50 Demo Microsoft Fabric KQL Database 03:10 Demo Set up Geolocation Event Stream in Microsoft Fabric 05:34 Demo Import Event Stream Data in KQL DB 07:02 Demo Configure Event Stream & Logic App for Astronaut Data 08:23 Demo Import Astronauts Event Stream into KQL Database 09:10 Demo Building KQL Queries we will use in our Power BI Report 11:45 Demo Building the Power BI Report Microsoft Fabric event streams https://learn.microsoft.com/en-us/fabric/real-time-analytics/event-streams/overview Real-time Tracking the International Space Station with Microsoft Fabric! #microsoftfabric https://youtu.be/-HhU7yLyuUU Real-time Tracking the International Space Station with Microsoft Fabric Part 2! https://www.youtube.com/watch?v=_RFvcPBNiOk Blog that inspired the video https://www.linkedin.com/pulse/real-time-monitoring-international-space-station-microsoft-sharma/ Anshul Sharma - GitHub Repo from the video https://github.com/anshulsharmas/fabric-iss-demo Stream real-time events from a custom application to Microsoft Fabric KQL Database for real-time reporting https://learn.microsoft.com/en-us/fabric/real-time-analytics/event-streams/stream-real-time-events-from-custom-app-to-kusto /******************* /CONNECT WITH US!! /******************* Tales from the Field Twitter: https://twitter.com/TalesftField Linkedin: https://www.linkedin.com/company/100091910/ Blusky: https://bsky.app/profile/talesfromthefield.bsky.social Bradley Ball Twitter: https://twitter.com/SQLBalls Linkedin: https://www.linkedin.com/in/sqlballs/ Blusky : https://bsky.app/profile/sqlballs.bsky.social Daniel Taylor Twitter: https://twitter.com/dbabulldog Linkedin: https://www.linkedin.com/in/danieltaylor3/ Blusky: https://bsky.app/profile/dbabulldog.bsky.social Neeraj Jhaveri Twitter: https://twitter.com/neeraj_jhaveri Linkedin: https://www.linkedin.com/in/neerajjhaveri/ Blusky: https://bsky.app/profile/neerajny.bsky.social Josh Luedeman Twitter: https://twitter.com/joshluedeman Linkedin: https://www.linkedin.com/in/joshluedeman/ Blusky: https://bsky.app/profile/joshluedeman.bsky.social Andrés Padilla Twitter: https://twitter.com/nodestreamio Linkedin: https://www.linkedin.com/in/andrespadillaandrade/ #realtime #streaming #analytics #microsoftfabric #powerbi #kqlwalkthrough #kql #internationalspacestation #nasa #space
Our latest MS Tech Bits is LIVE! @dbabulldog.bsky.social#AzureSQLyoutu.be/wHItwD7e9_A@sqlballs.bsky.social@joshluedeman.bsky.social
Want to learn how to Monitor your #AzureSQL #Databases? Looking for #performance #insights or gaining a greater understanding of what is going on with your ...
Our Latests MS Tech Bits is LIVE! @sqlballs.bsky.socialyoutu.be/kMVtHt_q8pI@joshluedeman.bsky.social@dbabulldog.bsky.social
Bradley Ball, aka @SQLBalls, walks us through how to install, setup, and configure a data gateway. Then how to register that data Gateway in Microsoft Fabric. We then use a Data Pipeline to import data from #SQLServer2022 into #MicrosoftFabric! Chapters 00:00 Importing Data with Microsoft Fabric 01:21 Demo - Our SQL 2022 Data 01:42 Demo Install on-premises data gateway 02:31 Demo Configure SQL Server 2022 Connection 03:36 Demo Super Importaint Configure your ADLS Gen 2 Storage for Staging 03:57 Demo Create Data Pipeline 05:01 Demo Configure Staging 05:45 Demo Validate Data Import Install an on-premises data gateway https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install /******************* /CONNECT WITH US!! /******************* Tales from the Field Twitter: https://twitter.com/TalesftField Linkedin: https://www.linkedin.com/company/100091910/ Blusky: https://bsky.app/profile/talesfromthefield.bsky.social Bradley Ball Twitter: https://twitter.com/SQLBalls Linkedin: https://www.linkedin.com/in/sqlballs/ Blusky : https://bsky.app/profile/sqlballs.bsky.social Daniel Taylor Twitter: https://twitter.com/dbabulldog Linkedin: https://www.linkedin.com/in/danieltaylor3/ Blusky: https://bsky.app/profile/dbabulldog.bsky.social Neeraj Jhaveri Twitter: https://twitter.com/neeraj_jhaveri Linkedin: https://www.linkedin.com/in/neerajjhaveri/ Blusky: https://bsky.app/profile/neerajny.bsky.social Josh Luedeman Twitter: https://twitter.com/joshluedeman Linkedin: https://www.linkedin.com/in/joshluedeman/ Blusky: https://bsky.app/profile/joshluedeman.bsky.social Andrés Padilla Twitter: https://twitter.com/nodestreamio Linkedin: https://www.linkedin.com/in/andrespadillaandrade/
Our Latest MS Tech Bits is LIVE!! @dbabulldog.bsky.social#ManagedInstanceyoutu.be/eRMH27EmT48@sqlballs.bsky.social@joshluedeman.bsky.social
Join Daniel Taylor, aka @DBABulldog , as we discover the game-changing features of the Next-gen General Purpose service tier in Azure SQL Managed Instance! In just a few minutes, learn how to boost performance, optimize costs, and upgrade your existing instances. Dive into the future of cloud databases with us! Chapters 00:00 Intros 00:50 Enable & Disable Next-gen General Purpose Documentation 01:01 Why Next-Gen General Purpose? 02:18 Enable Next-gen General Purpose 02:36 A look at compute & storage when Next-Gen general purpose is enabled 03:54 Disable Next-gen General Purpose 04:20 Closing and leave comments down below Use Next-gen General Purpose service tier - Azure SQL Managed Instance https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/service-tiers-next-gen-general-purpose-use?view=azuresql Overview of Azure SQL Managed Instance resource limits https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql
Our Latest MS Tech Bits is LIVE! @sqlballs.bsky.socialyoutu.be/iJY9TGFHggE@joshluedeman.bsky.social@dbabulldog.bsky.social@neerajny.bsky.social
Jin Bradley Ball, aka @SQLBalls , to learn how to refresh Your Power BI Semantic Model with Ease! Discover how the Semantic Model Refresh activity in Data Factory for Microsoft Fabric simplifies the process of connecting and refreshing your Power BI datasets. Learn to navigate the preview feature with our step-by-step guide, ensuring your data pipelines run smoothly and efficiently. Don’t miss out on the power to streamline your data management – watch now and take control of your Power BI refreshes! Chapters 00:00 Semantic Model Refresh 01:40 Demo Build our Pipeline 02:54 Demo Review Report and Sentiment Analysis of Deadpool 2 Use the Semantic model refresh activity to refresh a Power BI Dataset (Preview) https://learn.microsoft.com/en-us/fabric/data-factory/semantic-model-refresh-activity
Our latest MS Tech Bits is LIVE! @sqlballs.bsky.social#WebScraping#Python#MicrosoftFabricyoutu.be/xr5kJjtxzzo@dbabulldog.bsky.social@joshluedeman.bsky.social@neerajny.bsky.social
In this Web Scraping tutorial we are going to be looking at BeautifulSoup and Requests! In this video learn how to perform web scraping with Python using the Beautiful Soup library with Bradley Ball, aka @SQLBalls , where we will walk through a free online tutorial and show how you can use #python #webscraping in #MicrosoftFabric using #BeautifulSoup ! Chapters 00:00 Why are we learning about Web Scraping? 02:28 Demo - Tutorial and notebook 03:38 Demo - Prettify the HTML output 04:15 Demo - Retrieving data from individual tags 06:08 Demo - Looping through page data 07:12 Demo - Loading data into Arrays and then a Data Frame 07:50 Demo - Write the data to a Microsoft Fabric Lakehouse 08:40 Demo - Validate the data in our Lakehouse & via SSMS Web Scraping in Python with Beautiful Soupand Requests by Dr. Prof Jan Kirenz https://www.kirenz.com/blog/posts/2022-05-02-web-scraping-in-python-with-beautiful-soup-requests-and-pandas/ Bradley Ball Github - Web Scriping with Python Tutorial Beautiful Soup Microsoft Fabric https://github.com/sqlballs/SQLScripts/tree/main/Web%20Scraping%20with%20Python%20Tutorial%20Beautiful%20Soup%20Microsoft%20Fabric Build a Web Scraper with Python in 5 Minutes by Natassha Selvaraj https://www.kdnuggets.com/2022/02/build-web-scraper-python-5-minutes.html Develop, execute, and manage Microsoft Fabric notebooks https://learn.microsoft.com/en-us/fabric/data-engineering/author-execute-notebook /******************* /CONNECT WITH US!! /******************* Tales from the Field Twitter: https://twitter.com/TalesftField Linkedin: https://www.linkedin.com/company/100091910/ Blusky: https://bsky.app/profile/talesfromthefield.bsky.social Bradley Ball Twitter: https://twitter.com/SQLBalls Linkedin: https://www.linkedin.com/in/sqlballs/ Blusky : https://bsky.app/profile/sqlballs.bsky.social Daniel Taylor Twitter: https://twitter.com/dbabulldog Linkedin: https://www.linkedin.com/in/danieltaylor3/ Blusky: https://bsky.app/profile/dbabulldog.bsky.social Neeraj Jhaveri Twitter: https://twitter.com/neeraj_jhaveri Linkedin: https://www.linkedin.com/in/neerajjhaveri/ Blusky: https://bsky.app/profile/neerajny.bsky.social Josh Luedeman Twitter: https://twitter.com/joshluedeman Linkedin: https://www.linkedin.com/in/joshluedeman/ Blusky: https://bsky.app/profile/joshluedeman.bsky.social Andrés Padilla Twitter: https://twitter.com/nodestreamio Linkedin: https://www.linkedin.com/in/andrespadillaandrade/
Our latest MS Tech Bits is live! @dbabulldog.bsky.social#AzureSQLyoutu.be/qr1Qxwao68M@sqlballs.bsky.social@joshluedeman.bsky.social@neerajny.bsky.social
Do you know how to monitor your databases in Azure? Fresh off of the @SQLBits conference key note announcements Daniel Taylor, aka @DBABulldog , walks you t...
Our latest MS Tech Bits is LIVE! @sqlballs.bsky.socialyoutu.be/I09E-0RlgNc@joshluedeman.bsky.social@dbabulldog.bsky.social@neerajny.bsky.social
One of the biggest changes ever in the world of data and analytics is here! With Microsoft Fabric Database Mirroring you no longer need to forklift your dat...
Our Latest MS Tech Bits is LIVE! @dbabulldog.bsky.socialwww.youtube.com/watch?v=k1qF...@sqlballs.bsky.social@joshluedeman.bsky.social@neerajny.bsky.social
Join Daniel Taylor, aka @DBABulldog , as he unveils the intricacies of #AzureSQL ’s #Elastic #Jobs #alerting and #scaling capabilities. This insightful sess...
Our latest MS Tech Bits is LIVE! @sqlballs.bsky.socialyoutu.be/viOOdenrS9A@joshluedeman.bsky.social@neerajny.bsky.social@dbabulldog.bsky.social
Big #news Fabricators! We have been waiting for some of the grainular #security solutions to be introduced for #MicrosoftFabric! Today Bradley Ball, aka @SQ...