SQL Professional to Cosmic Superstar in 75 Minutes
Transition SQL Server skills to CosmosDB: Learn NoSQL concepts, JSON, multi-models, and key differences in monitoring and data structure. Prepare for a new approach to database management and optimization.
A Deep Dive into Execution Plans & How to Use Them
Explore SQL Server Query Optimizer's execution plans, learn to read and fine-tune them for better performance, and master troubleshooting techniques to enhance database efficiency.
Moving Data with Azure Data Factory
Learn to build native ADF pipelines, lift and shift SSIS to Azure, and use design patterns for execution and monitoring in this comprehensive overview of Azure Data Factory's cloud data engineering capabilities.
How to Put DevOps Into Action for Your Databases
Learn to implement DevOps practices for database deployments, covering source control, automated testing, and continuous integration/delivery through live demonstrations and practical insights.
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.
From Docker to Big Data Cluster - A New Era for SQL Server
Explore SQL Server's evolution from Docker support to Big Data Clusters, covering containerization, Kubernetes deployment, and integration with Python for modernized database management and analytics.
Polybase - It's What's for Dinner!
Explore Polybase, Microsoft's linked server replacement, for connecting to diverse data sources. Learn setup best practices, scale-out groups, AlwaysOn integration, and performance optimization techniques.
Migrating Oracle Workloads to Azure
Learn strategies for migrating Oracle databases to Azure, including architecture design, deployment automation, and success factors for moving to IaaS while leveraging both Oracle and Azure products.
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.
Deployment, High Availability & Performance Guidance for SQL Server Linux Azure IaaS Ecosystem
Explore deploying SQL Server on Linux in Azure, covering high availability, AD authentication, and performance optimization for production environments.
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.
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.
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.
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.
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.