How to Deploy SQL Server Containers on Kubernetes in Azure
Explore deploying SQL Server containers on Azure Kubernetes Service. Learn container creation, SQL Server deployment, and automation techniques for scalable and highly available database management.
TDE, Encryption, and Compliance With Azure Key Vault - Zero To Hero
Learn to secure and comply with data regulations using SQL Server TDE, encryption, and Azure Key Vault. Covers basics to advanced topics, including AlwaysON and hybrid cloud scenarios.
Managing ETL Change Using BIMLScript
Automate ETL processes using BIMLScript and metadata to easily adapt to source file changes, demonstrated with US census data and applicable to SSIS and Azure Data Factory.
Encrypting Data Within SQL Server
Explore SQL Server encryption options, data privacy laws, and performance impacts. Learn to classify sensitive data, implement Always Encrypted, and audit data usage for enhanced security.
Head to Head - SSIS Versus Azure Data Factory
Comparative analysis of SSIS and Azure Data Factory, exploring strengths, weaknesses, and real-world applications for data movement and transformation in SQL Server environments.
Reduce Cost by Tuning Queries on Azure DBaaS
Learn techniques to optimize queries on Azure SQL Database, improving performance and potentially reducing costs by lowering resource demands and compute size requirements.
Surviving the Next Azure Outage Like a Boss
Learn strategies to protect SQL Server instances from Azure outages. Explore HA/DR solutions, Azure Site Recovery, Availability Zones, and Fault Domains to ensure business continuity during cloud service disruptions.
Datacenter and/or Cloud - When to Use One, the Other, or Both
Learn to categorize workloads, evaluate SLAs, and choose optimal data locations between cloud, datacenter, or hybrid solutions. Includes cost estimation and SLA validation techniques.
DataOps - Deploy SQL Server Databases Using Azure Pipelines
Learn to automate SQL Server database deployments using Azure Pipelines and Visual Studio Database Projects. Covers creating projects, manual deployments, and setting up automated pipelines with secure credential management.
Let's Automagically Stage 100 Tables - For SSIS or ADF - With Biml - Live
Explore how Business Intelligence Markup Language (Biml) can automate SSIS package creation and generate JSON for ADF pipelines, streamlining data transformation processes from on-premises to Azure.
Accelerate Migrations of Legacy SQL Server and SSIS with Azure Data Factory
Streamline SQL Server and SSIS migration to Azure using ADF. Learn to provision SSIS-IR, run SSIS packages in ADF pipelines, and leverage DMA and DMS for efficient batch migrations.
Azure SQL Database - Maximizing Cloud Performance and Availability
Optimize Azure SQL Database performance and availability for mission-critical applications. Learn best practices, configuration tips, and troubleshooting techniques to maximize cloud resources and achieve 99.995% uptime.
Privacy and Security by Design in a Cloud Environment
Learn security and privacy design principles for cloud architectures, with practical implementation examples and best practices for integrating these crucial aspects into your solutions.
10 Cool Things You Can Do With Azure Databricks
Discover 10 practical Azure Databricks applications through live demos, including VS Code integration, streaming with Event Hub, and Delta time travel, enhancing your data engineering skills.
Using Open Source Software to Collect Performance Metrics
Learn to set up an inexpensive system using Telegraf, InfluxDB, and Grafana to collect and visualize SQL Server performance metrics, aiding in troubleshooting and capacity planning.
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.
Enabling End to End Scenarios with Data Virtualization in SQL Server 2019
Explore SQL Server 2019's data virtualization for seamless querying of Oracle tables, with enhanced features like data classification and server-based auditing for comprehensive data management solutions.
Real-time Sentiment Prediction in SQL Server
Explore CosmosDB's capabilities for high-volume transactions, global distribution, and diverse data types. Learn to set up a local instance, load JSON data, create PowerBI visualizations, and seamlessly transition to the cloud.
Dipping Your Toes In - Azure Data Lake for DBAs
Explore Azure Data Lake basics, including storage, security, and U-SQL. Learn how this technology complements relational database skills and discover real-world use cases for data professionals.
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.
Neither Here Nor There - Hybrid AO SQL Architecture On-Prem - Azure
Explore hybrid Always On SQL architecture, transitioning from on-premises to Azure Cloud. Learn configuration, troubleshooting, and best practices for global architecture in this eToro case study.