SQLBits Courses

A Data Engineer, Scientist and Analyst Walk Into a Bar

Explore data professional roles, essential skills, and real-world collaboration in data projects through personal journeys and industry insights.

• YouTube
• 45 minutes
• Self-Paced
• Free Video

SQL Server on Azure VM - Configuring for Price-Performance

Boost SQL Server performance on Azure VMs cost-effectively. Learn optimization techniques for enhanced price-performance ratio in virtual environments.

• YouTube
• 49 minutes
• Self-Paced
• Free Video

SQL Horror Stories - Cautionary Tales and Coding Tips

Explore hilarious and cringe-worthy SQL coding mishaps with Kevin Kline, learning valuable tips and tricks from these cautionary tales.

• YouTube
• 21 minutes
• Self-Paced
• Free Video

Best Practices in PostgreSQL Tuning - Navigating Key Performance Bottlenecks in the Cloud

Optimize PostgreSQL performance in cloud environments through practical techniques for diagnosing and solving common bottlenecks, enhancing database efficiency and health.

• YouTube
• 36 minutes
• Self-Paced
• Free Video

Confidential Development with Always Encrypted Using Enclaves

Explore Always Encrypted with secure enclaves for Azure SQL, learning best practices for developing applications with parameterized queries and collations.

• YouTube
• 43 minutes
• Self-Paced
• Free Video

Designing and Building AI Applications with Vector Search Using Azure OpenAI and Azure Cosmos DB

Design and build AI applications using vector search with Azure OpenAI and Azure Cosmos DB, enhancing your skills in creating advanced AI solutions.

• YouTube
• 50 minutes
• Self-Paced
• Free Video

Unlocking Database Automation with dbatools - Practical Use Cases and Real-World Insights

Revolutionize SQL Server automation with dbatools. Learn practical applications for migrations, availability groups, data management, and backup/restore processes from real-world scenarios.

• YouTube
• 50 minutes
• Self-Paced
• Free Video

Load Testing Fabric: Determining Hold Capacity for Large Datasets

Discover techniques for testing Fabric's capacity to handle large-scale data processing, from ingestion to PowerBI visualization, for enterprise-level workloads.

• YouTube
• 48 minutes
• Self-Paced
• Free Video

Perfecting Business Continuity for Azure SQL DB

Explore optimal database configurations for business continuity across application tiers in Azure SQL DB. Gain insights into robust strategies for uninterrupted operations.

• YouTube
• 47 minutes
• Self-Paced
• Free Video

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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• Free Video