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.
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.
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.
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.
What's New in SQL Server Tools
Explore upcoming features in Azure Data Studio and SQL Server tools, including SQL Notebooks. Learn about recent improvements and get a first look at highly requested functionalities to enhance your database management experience.
Ingesting and Managing Petabytes of Data with Azure Data Factory
Explore improvements in Azure Data Factory for simplified data integration and management, including code-free ETL/ELT and comprehensive data overview, empowering enterprises to handle petabytes of data for valuable insights.
Choice with Compatibility - SQL Server 2019 on Linux and Containers
Explore SQL Server 2019's enhanced capabilities on Linux and containers, including new features like Replication, DTC, and Polybase, for a robust enterprise database solution across diverse platforms.
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.
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.
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.
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.
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.
Introducing Azure Synapse Analytics - The End-to-End Analytics Platform
Explore Azure Synapse Analytics, a comprehensive platform integrating relational and big data systems for efficient data ingestion, preparation, modeling, and serving in a unified workspace.
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.
Comparing Predictive Models from R, Python, SSAS, and Azure ML
Explore techniques for evaluating and comparing predictive models across R, Python, SSAS, and Azure ML, with insights on integrating diverse tools for optimal data mining results.
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.
Continuous Integration with Local Agents and Azure DevOps
Explore Azure DevOps for database CI, using local agents for automated testing and validation. Learn to improve teamwork and code quality in database development.
Increase Deployment Flexibility with Feature Flags
Learn to use feature flags for flexible database deployments, enabling dark deployments and reducing production impact. Includes T-SQL code examples and demonstrations of implementation in deployment processes.