Checking in with Power Apps, Flow, and Power BI
Create a Power App for location check-ins, integrate with Flow to update Power BI data, and build a report displaying user locations on a map using Microsoft's Power Platform tools.
So, You Want to Be an Azure Data Engineer When You Grow Up?
Explore Azure Data Engineer role: certifications, skills, and duties. Learn about storage, security, DevOps, and automation. Gain insights for certification exams and career advancement in cloud data engineering.
The ABCs of BDCs - Big Data Clusters for Beginners
Explore SQL Server 2019's Big Data Clusters: architecture, deployment, and capabilities for combining relational and non-relational data, enhancing your big data skills and career prospects.
Machine Learning with SQL Server - From the Edge to the Cloud
Explore machine learning options in SQL Server ecosystem, from edge devices to cloud, covering training, testing, and operationalization for various workloads and design patterns.
The Battle of Cloud Data Warehouses - Snowflake, Synapse, and More
Explore cloud data warehousing solutions, comparing Snowflake, Synapse, Redshift, and BigQuery. Learn key principles, features, and how these platforms revolutionize data management and analysis.
DevOps - SSDT Makes Deployment Consistent
Learn to deploy database code consistently and accurately using Azure DevOps pipeline. Explore techniques for setting up database objects, including security and reports, for successful and repeatable deployments across different environments.
Guiding User Experiences With Advanced Reporting Features
Explore advanced Power BI features to enhance user experience: bookmark capture, button configurations, report tooltips, and measure-based formatting for improved report design and interactivity.
Lift and Shift Your SQL Servers to Azure SQL Virtual Machines
Learn best practices for migrating SQL Servers to Azure, including assessment, sizing, and data transfer. Discover cost-saving strategies, hybrid deployments, and tools for efficient Azure migration of existing SQL infrastructure.
PowerShell for DBA Beginners
Learn to automate SQL deployments and upgrades using PowerShell, starting with basics and progressing to multi-server scripts using JSON files.
Execution Plans - Where Do I Start?
Learn to read and understand SQL Server execution plans, crucial for optimizing query performance and troubleshooting slow queries. Discover how to obtain plans and interpret them effectively.
Big Data Clusters First Birthday
Celebrating SQL Server Big Data Clusters' first year, showcasing enhancements, and previewing future developments for accelerating data engineering and science projects.
ORMs and the DBA - How to Keep Both Happy
Explore strategies to mitigate ORM-related issues, improve performance, and satisfy both developers and DBAs. Learn to audit SQL, optimize code, and use tools for better ORM implementation.
Pay Less, Get More - A Guide to SQL Server Licensing
Optimize SQL Server licensing costs with expert guidance on editions, models, and scenarios for virtual environments, high availability, and non-production setups.
Deploying and Managing SQL Server with dbatools
Automate SQL Server deployment and management using dbatools PowerShell module. Learn installation, configuration, and operations techniques for efficient multi-system administration.
App Modernization and Migration from End to End
Comprehensive guide to app modernization and data migration using Microsoft tools, focusing on SSIS to ADF and SQL Server to Azure SQL MI transitions with practical demonstrations.
Advanced Development Pipelines
Explore multi-threaded builds, database dependencies, container-based agents, and environment automation for advanced development pipelines in this comprehensive session.
Design Your Data Vault and Load It With Azure Data Factory
Explore Data Vault methodology for data warehouse design and learn how to populate it using Azure Data Factory's Mapping Data Flows, with insights on ETL patterns and practical implementation.
Unlock Business Value From Your SQL Server Backups as You Head to the Cloud
Discover how to seamlessly migrate SQL Server to the cloud while ensuring robust data protection. Learn about platform-independent backup solutions that enable data mobility and instant retrieval, unlocking business value from your backups.
Scaling a DWH Beyond the Petabyte
Learn strategies for planning, architecting, and scaling data warehouse infrastructure from terabytes to petabytes using real-world examples for on-premises and cloud solutions.
Unlocking The Data Lake With Azure Synapse SQL Serverless
Explore and transform massive data in Azure data lakes using SQL Serverless for Synapse. Learn to leverage T-SQL for analytics, BI, and ML at petabyte scale.
The Art of Data Classification and Protection
Learn to classify, report, and audit data using SQL Server tools to enhance data protection, comply with regulations, and prevent breaches. Gain practical skills for effective data management and security.