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.
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.
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.
Six Ways to Improve SQL Server Application Security
Explore six mindsets for enhancing SQL Server application security, covering encryption, key management, data governance, and more. Gain actionable strategies to improve database development security.
Azure Machine Learning 101
Explore Azure ML's no-code approach to machine learning, from data preparation to model deployment, suitable for both beginners and experienced data scientists.
Emergency! Are You Ready for Disaster to Strike?
Prepare for data center disasters and ransomware attacks through regular practice of recovery processes. Learn strategies to ensure business continuity in critical situations.
Azure Arc - Bring Azure Data Services to On-Premises, Multi-Cloud and Edge
Learn to deploy Azure data services on-premises, multi-cloud, and edge environments using Azure Arc. Gain cloud benefits, automation, elastic scaling, and unified management across hybrid infrastructures.
Empowering the SQL Server Professional with Linux Scripting
Enhance SQL Server skills with Linux scripting: learn shell scripting techniques, tips, and tricks to complement PowerShell expertise for Azure environments. Includes practical demos and a cheat sheet.
SSRS and Paginated Reports in Power BI
Explore SSRS 2019 and Paginated Reports in Power BI, covering new features, report authoring, subscriptions, and management. Learn about pixel-perfect reporting alongside interactive Power BI reports.
Ingesting and Managing Petabytes of Data with Azure Data Factory
Explore improvements in Azure Data Factory for simplified data integration and management, including code-free ETL/ELT and comprehensive data overview, empowering enterprises to handle petabytes of data for valuable insights.
Choice with Compatibility - SQL Server 2019 on Linux and Containers
Explore SQL Server 2019's enhanced capabilities on Linux and containers, including new features like Replication, DTC, and Polybase, for a robust enterprise database solution across diverse platforms.
Reporting Services - A Smart Migration Strategy
Discover strategies for migrating to Power BI Report Server, utilizing ReportServer database metadata to determine which reports and data sources to migrate, and learn PowerShell techniques for efficient extraction and migration.
Infrastructure for the DBA - An Introduction
Comprehensive overview of infrastructure layers for DBAs, covering hardware, network, storage, virtualization, and operating systems to enhance problem-solving and proactive management skills.
Data Quality Round-trip in the MS Dataplatform
Explore comprehensive data quality solutions using Microsoft's Data Platform, including Machine Learning, Azure Data Factory, and SQL Server 2019, to address and resolve data quality challenges.
Introduction to Data Governance
Demystifying data governance: Learn its importance, core concepts, and practical implementation strategies for effective organizational data management.
Turbocharge Your SQL Server with In-Memory Database
Discover how to leverage SQL Server 2019's memory-optimized technologies to enhance performance and scalability, taking advantage of modern hardware innovations for database applications.
Power BI Report Server Enterprise Architecture, Tools to Publish
Explore enterprise-grade Power BI Report Server architecture, publishing tools, and best practices for improved performance, security, and scalability in large-scale implementations.
ABCs of the Power BI REST API
Explore managing Power BI content using REST API, covering dashboards, datasets, reports, and groups. Learn to automate tasks, retrieve information, and enhance Power BI workflow efficiency.
Never Lose Data - Digging Out From Corruption
Learn essential recovery techniques to prepare for, detect, and repair various corruption-based problems in databases, ensuring data integrity and minimizing disruptions in your enterprise.
Using PowerShell on Linux
Learn to install and use PowerShell on Linux, interact with Azure and SQL Server, and discover its potential for Linux administrators. Explore use cases and resources for further learning.