Improving Database Code Quality with Unit Tests
Learn to implement unit testing for T-SQL code, enhancing database quality. Discover tools and techniques for automated testing, test-driven design, and integrating tests into your development workflow.
A Game of Hierarchies - Graph Processing with SQL Server 2019
Explore hierarchies and graph processing in SQL Server 2019 using "Game of Thrones" examples. Learn best practices for transforming complex data structures into useful information.
SQL and MongoDB - When Two Worlds Collide
Explore hybrid SQL-NoSQL solutions, focusing on integrating MongoDB with SQL Server. Learn scenarios, implementation techniques, and performance considerations for leveraging strengths of both database types.
What's New in Security for Azure SQL - MI
Explore cutting-edge Azure SQL security innovations, including network security, authentication, data encryption, and management. Gain insights into new customer scenarios and opportunities unlocked by these technologies.
Reporting Services - A Smart Migration Strategy
Discover strategies for migrating to Power BI Report Server, utilizing ReportServer database metadata to determine which reports and data sources to migrate, and learn PowerShell techniques for efficient extraction and migration.
Azure DevOps Pipelines for BI
Learn to implement DevOps practices for SQL databases, Analysis cubes, and SSIS packages using Azure DevOps Pipelines. Discover techniques for code tracking, compile-time checking, and efficient deployments.
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.
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.
Database Modernization Best Practices and Lessons Learned Through Customer Engagements
Discover real-world examples and engineering best practices for modernizing SQL and Non-SQL platforms to Azure SQL PaaS, leveraging Microsoft's Data 1st strategy for complex modernizations.
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.
Getting Started with Azure Data Studio
Learn to use Azure Data Studio: customize, create insights, use extensions, work with notebooks, and develop your own extensions. Master this cross-platform tool for data-related tasks and T-SQL editing.
A Self-Tuning Fill Factor Technique for SQL Server
Discover a technique for optimizing SQL Server index fill factors, reducing fragmentation and bad page splits, leading to significant performance improvements in OLTP databases.
PowerShell for DBA Beginners
Learn to automate SQL deployments and upgrades using PowerShell, starting with basics and progressing to multi-server scripts using JSON files.
App Modernization and Migration from End to End
Comprehensive guide to app modernization and data migration using Microsoft tools, focusing on SSIS to ADF and SQL Server to Azure SQL MI transitions with practical demonstrations.
Unlocking The Data Lake With Azure Synapse SQL Serverless
Explore and transform massive data in Azure data lakes using SQL Serverless for Synapse. Learn to leverage T-SQL for analytics, BI, and ML at petabyte scale.
SQL Professional to Cosmic Superstar in 75 Minutes
Transition SQL Server skills to CosmosDB: Learn NoSQL concepts, JSON, multi-models, and key differences in monitoring and data structure. Prepare for a new approach to database management and optimization.
Developer Best Practices in SQL Server
Learn optimized T-SQL coding techniques for SQL Server, including Sarg-ability, performance improvement, SQL injection prevention, parameterization, and dynamic SQL best practices through real-world examples.
From Docker to Big Data Cluster - A New Era for SQL Server
Explore SQL Server's evolution from Docker support to Big Data Clusters, covering containerization, Kubernetes deployment, and integration with Python for modernized database management and analytics.