Reporting for Developers
Explore Power BI and SQL Server Reporting Services for developers. Compare features, development environments, and integration capabilities to choose the best platform for your reporting needs.
HA - DR - Too Many Choices
Explore various high availability and disaster recovery options for SQL Server, weighing pros and cons to find the best fit for your company's needs and requirements.
Linux Fundamentals for SQL Server DBAs
Explore SQL Server on Linux: installation, configuration, and management. Learn essential Linux commands and file systems for DBAs transitioning to this open platform.
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.
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.
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.
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.
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.
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.
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.
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.
SQL Migration to Azure - Best Practices, Accelerators, and Production Case Studies
Explore SQL workload migration to Azure, covering best practices, tools, and real-world case studies. Learn end-to-end migration lifecycle and determine the best approach for your organization.
Revenge - The SQL
Discover humorous and creative SQL techniques to enforce best practices, prevent errors, and maintain control over your database environment. Learn unconventional methods to address common DBA challenges.
Understanding Modern Data Encryption Offerings for SQL Server
Explore SQL Server's native encryption methods, Azure Key Vault, and Always Encrypted to safeguard your data. Learn implementation techniques and potential issues for modern data security.
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.
Think Like the Cardinality Estimator
Explore SQL Server's cardinality estimation process to optimize query performance. Learn how to influence physical operations, handle multiple predicates, and tackle complex query plans.
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.
Getting Started with PowerShell as a DBA
Learn PowerShell fundamentals for DBAs: syntax, TSQL translation, and practical applications. Discover how this powerful tool can enhance your database administration skills and workflow efficiency.