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.
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.
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.
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.
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.
Machine Learning in C# - Introduction to ML.NET
Discover ML.NET: Build machine learning applications using C# and .NET. Learn data preparation, model evaluation, and deployment techniques for integrating ML capabilities into your .NET projects.
Modernizing Your Data Platform
Structured approach to modernizing data platforms, focusing on Microsoft technologies. Covers migration tools, techniques, and steps for improved performance, security, and cost-efficiency.
Performance Tuning - Getting the Biggest Bang for Your Buck
Discover essential SQL Server performance tuning techniques, from memory optimization to configuration changes, with real-world scenarios and practical solutions for immediate improvements.
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.
Getting to Know Google Cloud SQL for SQL Server
Explore Google Cloud SQL for SQL Server: architecture, provisioning, analytics, security, high availability, and replication. Learn best practices and tools for leveraging this managed database service.
Power of Electric Snakes! PySpark for Big Data and Data Science
Learn to harness PySpark for big data analytics, covering RDDs, DataFrames, transformations, and machine learning. Gain practical skills for efficient data processing and analysis using Python and Spark.
Taking Your Data Hybrid With Azure Arc Enabled Data Services
Explore Azure Arc's hybrid cloud capabilities for data services, including SQL Managed Instance deployment, encryption, and authentication, with practical demos and insights.
Give Power BI to the People - Securely Share Your Insights
Discover secure Power BI data sharing strategies, governance planning, and collaboration techniques to empower your organization while avoiding potential data breaches and privacy risks.