ETL in Azure Made Easy with Data Factory Mapping Data Flows
Explore Azure Data Factory's Mapping Data Flows for efficient, scalable ETL without coding. Learn to transform data using Databricks integration and graphical tools.
Data Warehousing - Which of the Many Cloud Products is the Right One for You
Explore cloud-based data warehousing options, comparing Snowflake, Databricks, and Azure solutions. Learn to choose the best fit for your environment based on size, architecture, and unique features.
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.
Modernizing Your Data Platform
Structured approach to modernizing data platforms, focusing on Microsoft technologies. Covers migration tools, techniques, and steps for improved performance, security, and cost-efficiency.
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.
Deploying Availability Groups in Virtualized Architectures
Best practices for deploying SQL Server Always On Availability Groups in virtualized environments, covering on-premises, cloud, and hybrid architectures across VMware, Hyper-V, Azure, AWS, and GCP.
Modern High Availability and Disaster Recovery Topologies
Explore innovative HA/DR solutions for SQL Server, including traditional and advanced technologies like availability groups, log shipping, VM replication, and container-based approaches for enhanced data protection.
Inside Azure SQL Database Hyperscale
Explore Azure SQL Database Hyperscale's innovative architecture, including distributed components, multi-tiered caching, and read-scale replicas. Learn about built-in scalability, high availability, and unique diagnostics for performance insights.
Data Modeling and Partitioning Patterns in Azure Cosmos DB
Explore key strategies for effective data modeling and partitioning in Cosmos DB, using real-world examples to optimize performance and scalability in NoSQL database design.
Best Practices for Deployment of SQL Server on Azure Virtual Machines
Optimize SQL Server deployment on Azure VMs: right-sizing, high availability, performance, migration, disaster recovery, and licensing for Windows and Linux environments.
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.
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.
Modernize Your SQL Applications Recently Enhanced Version Azure SQL Managed Instance
Explore Azure SQL Managed Instance's latest enhancements for modernizing SQL applications, including improved migration, security, and manageability features for optimal cloud transformation.
Developer Best Practices in SQL Server
Learn optimized T-SQL coding techniques for SQL Server, including Sarg-ability, performance improvement, SQL injection prevention, parameterization, and dynamic SQL best practices through real-world examples.
Azure SQL Is the Best Choice for Building Back-End REST API - Discuss
Explore Azure SQL's capabilities for building high-performance, scalable REST APIs with JSON support, CI/CD integration, and robust security features for modern agile development.
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.
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.
Make a Real SQL Cloud Transformation, Not Just a Migration
Explore cloud-native SQL transformation strategies, focusing on DevOps, scalability, and long-term outcomes beyond simple migration for optimal data management in the cloud era.
SQL Server Containers in Action
Explore SQL Server containers: use cases, recent improvements, and future roadmap. Hands-on demo showcases practical applications and benefits for database management and deployment.
Find - So You Can Fix - Those Troublesome Queries
Explore tools and techniques to diagnose, troubleshoot, and optimize problematic SQL Server queries, enhancing database performance and efficiency.