What's New in the SQL Server Tools?
Explore upcoming SQL Server tools and user experiences, featuring demos on Jupyter notebooks and SQL database projects, presented by the SQL Server product team.
The Good, Bad, and Ugly of Migrating SQL Server to Public Clouds
Explore the challenges and best practices for migrating SQL Server to public clouds like Azure, AWS, and GCP. Learn from real-world experiences to ensure a successful transition from on-premises to cloud environments.
Charticulator - Create Custom Visual with No Code in Power BI
Learn to create custom Power BI visuals using Charticulator without coding. Explore the tool's environment, chart creation process, and importing custom visuals into Power BI desktop.
Building Data Lakes in Azure
Learn to build and leverage data lakes in Azure using Databricks and Synapse Analytics. Explore key services, implementation strategies, and querying techniques for modern data environments.
Dr. DMV with Jupyter Notebooks
Comprehensive guide to using Dynamic Management Views for SQL Server diagnostics, leveraging Jupyter Notebooks to detect and resolve performance issues with detailed result interpretation.
Congratulations, You Are Now a DBA
Essential roadmap for new DBAs: daily, weekly, and monthly checklists for SQL Server administration, data protection, and server maintenance. Learn key responsibilities and long-term career prospects in data-driven decision-making.
Extending Your Use of Extended Events
Explore advanced Extended Events techniques for SQL Server troubleshooting. Learn to leverage targets, actions, and predicates for innovative problem-solving beyond traditional Trace capabilities.
Azure Arc - From Edge to Core to Hybrid Cloud
Explore Azure Arc's role in extending Azure data services to on-premises, multi-cloud, and edge environments, enhancing SQL Server capabilities and enabling edge computing for valuable data insights.
SQL Server Business Intelligence on Amazon RDS
Explore SQL Server Integration Services, Analysis Services, and Reporting Services on Amazon RDS. Learn cost-saving strategies, configuration, security, and reliability for Microsoft BI toolkit on cloud infrastructure.
Splitting Up Your Work in Chunks
Techniques for efficient data processing through chunking: balancing set-based operations and loops, improving performance, handling application impact, and managing interrupted operations.
Diversity, Belonging, & Allyship - Essential DBA Skills for the Data Professional
Explore essential non-technical skills for data professionals: embracing diversity, fostering belonging, and practicing allyship. Learn techniques to cultivate inclusive cultures and become a better ally in the tech industry.
Monitoring and Tuning Your Database as a Service Performance
Learn strategies for monitoring and optimizing database performance in cloud-based "as-a-service" environments, exploring built-in tools and purpose-built solutions to ensure optimal database health and query efficiency.
Building a Highly-Available, Scalable Application with Amazon Aurora
Learn to build high-performance applications using Amazon Aurora, a MySQL- and PostgreSQL-compatible database. Explore scalability, high availability, disaster recovery, and global replication for open source databases on AWS.
The Right Tool for the Right Job - Serving Data From SQL Server
Strategies for efficient data retrieval from SQL Server, comparing methods like stored procedures and ORMs. Includes implementation examples in .NET and tips for performance tuning and database structuring.
Data Governance for Beginners
Learn data governance basics for Microsoft Data Platform, including master data management and data stewardship. Discover practical steps for implementation and documentation to enhance organizational data value.
Let Me Automate You - Take Power BI To The Next Level
Discover advanced Power BI automation techniques using CLI, PowerShell, and C#. Learn to streamline administration tasks, implement continuous integration, and create artifacts automatically.
Normalization Beyond Third Normal Form
Explore higher Normal Forms in database design, debunking myths and enhancing your skills. Learn to identify, check, and understand the consequences of violations for improved database architecture.
Database Administration Through the Ages
Explore modern DBA roles across platforms, leveraging existing skills for maintenance, monitoring, and disaster recovery on Windows, Linux, Azure SQL DB, and containers. Future-proof your career in database administration.
Data Engineering Brick-by-Brick - An Intro To Azure Databricks
Explore Azure Databricks for cloud-based big data analytics. Learn cluster setup, collaborative notebooks, and machine learning integration. Discover its role in modern cloud data warehousing.
What's Going On in My Power BI Environment?
Discover effective methods for monitoring and managing your Power BI environment, including usage tracking, license management, and data collection automation using Azure and PowerShell.
Microsoft Power BI for the Data Engineer
Explore Power BI's capabilities for enterprise-grade insights, performance, governance, and security over massive datasets. Learn simplified data modeling and visualization techniques for actionable insights.