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.
Deep Dive into Blocking and Deadlocks Troubleshooting
Comprehensive exploration of SQL Server Concurrency Model, focusing on blocking issues and deadlocks. Learn to troubleshoot using standard tools and a specialized Blocking Monitoring Framework.
How to Build an Impactful KPI Scorecard in Power BI
Learn to create professional KPI scorecards in Power BI using DAX, custom visuals, and design best practices. Master matrix tables, conditional formatting, and sparklines for impactful data visualization.
SQL Server Machine Learning Services in Production
Discover best practices for deploying and maintaining SQL Server Machine Learning Services, including R package management, code deployment, and troubleshooting techniques for seamless integration.
SQL Server 2019 - Your Next Modern Data Platform
Comprehensive overview of SQL Server 2019's features, including improved performance, data integration capabilities, and advanced security, highlighting its evolution as a modern data platform.
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.
MDS from the Ground Up - Let Your Users Maintain Their Data
Master Data Services (MDS) empowers users to manage data quality and governance. Learn how MDS integrates with Excel, enforces data standards, and streamlines operational and analytical solutions.
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.
Protect Your Data by Design - Creating a Data Masking Strategy
Learn to create a comprehensive data masking strategy to protect sensitive information, overcome implementation challenges, and ensure data security in pre-production environments.
Missing T-SQL Querying Features for Handling NULLs and for Data Analysis
Explore advanced T-SQL querying techniques for handling NULLs and data analysis, covering missing SQL Server features and effective workarounds for improved database performance and functionality.
Everything You Wanted to Know About Implementing Temporal Tables
Discover SQL Server's Temporal Tables: automate data history tracking, simplify time-based analysis, and explore new querying syntax for efficient data management and auditing.
Data Munging to Wrangling - 7 Steps to Mastering Data Preparation for Data Science
Discover essential techniques for data preparation in AI/ML projects. Learn to source, clean, and transform data effectively, enhancing the quality and predictive power of machine learning models.
dbatools - A PowerShell Toolkit for the DBA
Explore dbatools PowerShell module for efficient SQL Server management. Learn installation, automation of routine tasks, and advanced features to streamline database administration workflows.
Power BI Premium - Is it for Your Company and Worth It
Comprehensive overview of Power BI Premium features, benefits, and costs to help companies decide if it's the right investment for their data analytics needs.
Code Like a Snake Charmer - Introduction to Python
Learn Python basics, data manipulation, and integration with Microsoft tools for enhanced data analytics and machine learning capabilities.
AI for the DBA
Explore the AI ecosystem for DBAs, covering basics, support skills, and in-depth understanding to thrive in AI. Learn about architecture and operationalizing models using Azure ML Server.
SQL Server Migration - The Last Mile
Explore post-migration steps for SQL Server upgrades, focusing on data accuracy, query performance, and leveraging new optimization features to minimize risks and improve workload efficiency.
Back Up and Restore a SQL Server Database If You're Not a DBA
Learn essential database backup and restore techniques, including data files, recovery models, and automation, to safeguard your SQL Server data and prevent job-loss scenarios during disasters.
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.