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.
Hidden Gems of SQL Server 2019
Discover lesser-known features and improvements in SQL Server 2019 beyond the main highlights, exploring hidden capabilities that can enhance database management and performance.
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.
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.
Batch Execution Mode on Rowstore Indexes
Explore SQL Server 2019's Batch Execution Mode for Rowstore Indexes, its benefits, challenges, and optimal usage scenarios to significantly enhance workload performance.
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.
Managing and Monitoring SQL Server on Linux from the Command Line
Explore command-line tools for managing SQL Server on Linux, including installation, configuration, and monitoring. Learn to leverage bash for querying DMVs and gain insights for seasoned command-line users.
Database CICD - Continuous Integration and Deployment
Learn to automate database operations and deployments for efficient management of hundreds of databases, meeting industry demands for faster, streamlined processes.
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.
The Power Platform Game Changer
Comprehensive guide to building and deploying business apps using Microsoft Power Platform, covering PowerApps, Flow, SQL Server, Power BI, and Cortana with focus on security and enterprise governance.
Understanding Execution Plans
Explore SQL Server execution plans to optimize query performance. Learn to capture, read, and analyze plans, identifying potential issues and understanding key operations for efficient database queries.
Cosmos DB Develop Locally Deploy Globally
Learn to set up, use, and deploy CosmosDB for globally distributed, scalable database solutions. Explore JSON data loading, PowerBI visualization, and seamless cloud migration.
Understanding Modern Data Encryption Offerings for SQL Server
Explore SQL Server's native encryption methods, Azure Key Vault, and Always Encrypted to safeguard your data. Learn implementation techniques and potential issues for modern data security.
Accelerating the Migration of Legacy SSIS with Azure Data Factory
Explore new features for migrating legacy SSIS to Azure Data Factory, including Azure-SSIS Integration Runtime, Azure Files integration, and batch assessments using Data Migration Assistant.
Think Like the Cardinality Estimator
Explore SQL Server's cardinality estimation process to optimize query performance. Learn how to influence physical operations, handle multiple predicates, and tackle complex query plans.
Getting to Know Google Cloud SQL for SQL Server
Explore Google Cloud SQL for SQL Server: architecture, provisioning, analytics, security, high availability, and replication. Learn best practices and tools for leveraging this managed database service.
Inside the VertiPaq Engine
Explore VertiPaq engine internals, database architecture, and optimization techniques for improved performance and compression in SQL Server Analysis Services Tabular, Power BI, and Power Pivot.
Embracing Database DevOps through CI/CD
Learn to implement Database DevOps using SQL Server containers, Flyway, Kubernetes, and Azure DevOps. Explore strategies for efficient database migrations and build your first CI/CD pipeline for database deployment.
Maximize Performance for Less Cost Using Azure SQL Database Serverless
Learn to optimize Azure SQL Database serverless for intermittent workloads, automatically scaling resources and improving cost-efficiency while simplifying performance management.
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.
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.