SQLBits Courses

Web Scraping Puppy Data with Microsoft Fabric - 2nd Leg

Learn web scraping techniques using CSS Selectors in Power Query, m code, and PySpark within Microsoft Fabric to extract puppy data from websites.

• YouTube
• 22 minutes
• On-Demand
• Free Video

Operational Insights for Hybrid and Multi-Cloud SQL Inventory Using Azure Arc SQL Server

Gain performance, inventory, and security insights for SQL Servers across hybrid and multi-cloud environments using Azure Arc for comprehensive management.

• YouTube
• 49 minutes
• On-Demand
• Free Video

Building a Copilot Chatbot for the SQLBits Website

Explore the creation process of a Copilot chatbot for the SQLBits website, learning key steps and insights for event-specific AI integration.

• YouTube
• 20 minutes
• On-Demand
• Free Video

A Deep Dive into Microsoft Fabric Data Warehouse

Explore Microsoft Fabric Data Warehouse's capabilities and strategies for effective utilization in this comprehensive deep dive led by industry experts.

• YouTube
• 51 minutes
• On-Demand
• Free Video

Business Continuity of On-Premise SQL Servers Using Azure Services Through Arc

Leverage Azure Arc to enhance on-premises SQL Server management with automated backups, point-in-time restore, long-term retention, and monitoring for mission-critical clusters.

• YouTube
• 46 minutes
• On-Demand
• Free Video

ACID in SQL Server: What It Is, How It Works, and How to Live More Adventurously

Explore ACID compliance in SQL Server, focusing on Isolation and Durability, and learn how to optimize database transactions for better performance.

• YouTube
• 52 minutes
• On-Demand
• Free Video

Using ALLEXCEPT or ALL/VALUES in DAX Calculations

Optimize DAX calculations by mastering when to use ALL/VALUES instead of ALLEXCEPT for improved performance and clarity in data analysis.

• YouTube
• 22 minutes
• On-Demand
• Free Video

Realtime Streaming of Flight Data with Microsoft Fabric

Stream and analyze real-time aircraft data using Microsoft Fabric, showcasing Eventstream, KQL database, and Power BI for visualizing flight patterns above SQLBits venue.

• YouTube
• 44 minutes
• On-Demand
• Free Video

Navigating Data Governance in the Age of Generative AI

Explore LLMs' impact on data analytics, their advantages, and governance challenges. Gain insights to effectively integrate AI into data strategies while maintaining proper oversight.

• YouTube
• 50 minutes
• On-Demand
• Free Video

Upgrade to First Class with Calculation Groups for Power BI

Master Calculation Groups in Power BI Desktop and Tabular Editor. Explore creation techniques, functionality, and best practices for implementing multiple Calculation Groups effectively.

• YouTube
• 50 minutes
• On-Demand
• Free Video

Reducing Costs and Building New Analytics Capabilities in Power BI with Power Automate

Streamline data analytics tasks using Power Automate to reduce transformation time and improve analyst efficiency in Power BI.

• YouTube
• 20 minutes
• On-Demand
• Free Video

Flight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud Cockpit

Extend Azure's features to your entire SQL estate, regardless of location or platform, using Azure Arc for comprehensive management and innovation.

• YouTube
• 22 minutes
• On-Demand
• Free Video

Navigating the Skies of Data: A Flight Through Feature Stores

Explore Feature Stores' role in streamlining ML projects, acting as a control tower for efficient feature management in data processes.

• YouTube
• 20 minutes
• On-Demand
• Free Video

The Swiss Cheese Security Pattern - Building Secure Data Architectures

Adopt a multi-layered approach to data security, minimizing risks through strategic architecture and mindset shifts in asset protection.

• YouTube
• 46 minutes
• On-Demand
• Free Video

Mastering Rapid Power BI Development with ChatGPT - A Deep Dive

Leverage ChatGPT to enhance Power BI development, generating power queries, images, cmdlets, and complex DAX with SVG and CSS for rapid and efficient data visualization.

• YouTube
• 50 minutes
• On-Demand
• Free Video