Let's Automagically Stage 100 Tables - For SSIS or ADF - With Biml - Live
Explore how Business Intelligence Markup Language (Biml) can automate SSIS package creation and generate JSON for ADF pipelines, streamlining data transformation processes from on-premises to Azure.
Modern Excel - The Supercomputer Hiding on Everyone’s Desktop
Discover game-changing Excel tools for data-driven decisions. Learn multi-source import, rapid data shaping, portable formulas, and insightful reporting techniques to supercharge your spreadsheet skills.
Accelerate Migrations of Legacy SQL Server and SSIS with Azure Data Factory
Streamline SQL Server and SSIS migration to Azure using ADF. Learn to provision SSIS-IR, run SSIS packages in ADF pipelines, and leverage DMA and DMS for efficient batch migrations.
CosmosDB - Designing and Troubleshooting Lessons
Learn to design, query, and troubleshoot high-performance Cosmos DB solutions through hands-on labs covering partition design, SQL API querying, and request optimization techniques.
Innovative Data Modeling for Cool Data Warehouses
Explore agile data warehouse modeling techniques beyond traditional norms. Learn to build flexible, auditable solutions adaptable to various industries, leveraging MDM and Azure for enhanced performance and data integration.
Should I Move My Production SQL Server Workloads to Containers
Explore the pros and cons of containerizing SQL Server workloads, examining architectural differences, advantages, and challenges to help decide if containers are right for your production environment.
Bringing Source Control to BI World
Discover how to implement source control in Business Intelligence environments, improving version management, tracking changes, and facilitating parallel development for databases, cubes, and reports.
Data Modeling and Prototyping in Power BI Desktop
Explore rapid data modeling and prototyping using Power BI Desktop. Learn to connect, cleanse, and model data from various sources, creating quick reports for project approval without licensing costs.
Improving Database Code Quality with Unit Tests
Learn to implement unit testing for T-SQL code, enhancing database quality. Discover tools and techniques for automated testing, test-driven design, and integrating tests into your development workflow.
Azure SQL Database - Maximizing Cloud Performance and Availability
Optimize Azure SQL Database performance and availability for mission-critical applications. Learn best practices, configuration tips, and troubleshooting techniques to maximize cloud resources and achieve 99.995% uptime.
Privacy and Security by Design in a Cloud Environment
Learn security and privacy design principles for cloud architectures, with practical implementation examples and best practices for integrating these crucial aspects into your solutions.
10 Cool Things You Can Do With Azure Databricks
Discover 10 practical Azure Databricks applications through live demos, including VS Code integration, streaming with Event Hub, and Delta time travel, enhancing your data engineering skills.
Using Open Source Software to Collect Performance Metrics
Learn to set up an inexpensive system using Telegraf, InfluxDB, and Grafana to collect and visualize SQL Server performance metrics, aiding in troubleshooting and capacity planning.
Improving Availability in SQL Server and Azure SQL Database with Accelerated Database Recovery and Resumable Operations
Discover innovations in SQL Server 2019 and Azure SQL Database that enhance database availability, reduce downtime, and streamline maintenance operations for improved performance and reliability.
Dynamic SQL - Writing Efficient Queries on the Fly
Learn to create fast, efficient queries using Dynamic SQL for automating complex processes, facilitating reporting, and solving seemingly impossible problems. Explore best practices, applications, and maintenance techniques.
A Game of Hierarchies - Graph Processing with SQL Server 2019
Explore hierarchies and graph processing in SQL Server 2019 using "Game of Thrones" examples. Learn best practices for transforming complex data structures into useful information.
Enabling End to End Scenarios with Data Virtualization in SQL Server 2019
Explore SQL Server 2019's data virtualization for seamless querying of Oracle tables, with enhanced features like data classification and server-based auditing for comprehensive data management solutions.
Real-time Sentiment Prediction in SQL Server
Explore CosmosDB's capabilities for high-volume transactions, global distribution, and diverse data types. Learn to set up a local instance, load JSON data, create PowerBI visualizations, and seamlessly transition to the cloud.
Data Classification and Masking - The What and How of Data Protection
Learn techniques for protecting sensitive data across systems using SSMS and SQL Server tools. Explore data classification, dynamic and static masking to ensure data security while maintaining accuracy for testing and analytics.
Dipping Your Toes In - Azure Data Lake for DBAs
Explore Azure Data Lake basics, including storage, security, and U-SQL. Learn how this technology complements relational database skills and discover real-world use cases for data professionals.
SQL PowerShell 2019 - The Lingua Franca for the Data Platform
Explore PowerShell's versatility in managing diverse data platforms, from Excel to Azure SQL. Learn object-based data handling, code documentation, and sharing through PowerShell Notebooks for seamless integration across Microsoft data products.