Best, Better, Hyperscale! The Last Database You Will Ever Need in the Cloud
Explore Azure Hyperscale: a cloud-native, scalable database solution offering SQL Server features for innovation and future-proofing. Learn deployment patterns, best practices, and its underlying architecture.
Hidden Differences Between Azure ML Products Revealed
Explore Azure ML products, their differences, and use cases. Learn to create end-to-end ML workflows, integrate with SQL Server, and manage models in production using various Azure tools.
Removing the SELECT * - Helping Your App Developers and Yourself
Optimize database performance by understanding ORM frameworks, LINQ, and application impact. Learn to improve queries, enhance developer collaboration, and boost your value as a data professional.
Azure Data Studio - The Challenger
Explore Azure Data Studio's features, benefits, and comparison to SQL Server Management Studio. Learn about its cross-platform capabilities, monitoring tools, and use cases.
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.
Columnstore Indexes in 2017-2019
Explore recent enhancements to Columnstore Indexes in SQL Server 2017-2019, focusing on performance improvements for Data Warehouses and BI solutions. Learn about new features and fixes for high-scale environments.
SQL Server and Azure Data - What to Use When
Explore SQL Server deployment options across on-premises, cloud, and hybrid environments. Learn decision-making strategies for modernizing your data platform and choosing the right solution for your needs.
How Do I Ensure My Azure Modern Data Warehouse Is Secure
Comprehensive guide to securing Azure-based data platforms, covering network security, client connections, firewalls, VNET rules, and Azure AD. Includes SQL security features and encryption options for robust data protection.
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.
Query Optimization Statistics - Driving Force Behind Performance
Explore SQL Server query optimization statistics, their impact on performance, and techniques to address common issues for improved query execution.
AI Cognitive Services - Vision 101
Introduction to Azure's Computer Vision and Custom Vision APIs, covering basics, model creation, training, and implementation using Python in Azure Notebooks.
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.
Aggregations in Power BI
Explore high-performance data analysis using Power BI Aggregations. Compare with Analysis Services, learn implementation strategies, and understand architectural approaches for optimized analytical solutions.
Working with SQL Server Containers to Build Database Solutions
Explore efficient SQL Server solution deployment using containers, covering basic and advanced methods, real-world scenarios, and cross-platform portability for streamlined database management.
Choosing Your Cloud - Step 2 in Your Cloud Migration Journey
Explore cloud vendor strengths, migration tools, and service mapping for OLTP and BI-stack migrations. Learn to evaluate single-vendor benefits and challenges for informed cloud platform selection.
Azure SQL Database Edge - Overview
Explore Azure SQL Database Edge: optimized for edge computing with streaming support, machine learning, and "develop once, deploy anywhere" capabilities. Learn about features, deployments, and customer scenarios.
Query Store In-Depth
Explore Query Store's capabilities, quirks, and real-world applications for troubleshooting performance issues in SQL Server, including updates for SQL Server 2019.
Azure SQL Database - Lessons Learned from the Trenches
Discover best practices, tips, and monitoring techniques for optimizing Azure SQL Database performance in production environments, based on real-world Microsoft CSS support cases and customer engagements.
Handling Role Playing Dimensions in Tabular Models
Explore various methods for implementing role-playing dimensions in tabular models, including DAX expressions, with a focus on model maintainability and user experience in data analysis.
Azure Data Studio Extension Development
Learn to develop extensions for Azure Data Studio using Typescript, exploring APIs, GitHub hosting, and marketplace sharing. Gain practical skills through a live demonstration of building a functional extension.
Azure DevOps Pipelines for BI
Learn to implement DevOps practices for SQL databases, Analysis cubes, and SSIS packages using Azure DevOps Pipelines. Discover techniques for code tracking, compile-time checking, and efficient deployments.