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.
Azure SQL Is the Best Choice for Building Back-End REST API - Discuss
Explore Azure SQL's capabilities for building high-performance, scalable REST APIs with JSON support, CI/CD integration, and robust security features for modern agile development.
Splitting Up Your Work in Chunks
Techniques for efficient data processing through chunking: balancing set-based operations and loops, improving performance, handling application impact, and managing interrupted operations.
The Right Tool for the Right Job - Serving Data From SQL Server
Strategies for efficient data retrieval from SQL Server, comparing methods like stored procedures and ORMs. Includes implementation examples in .NET and tips for performance tuning and database structuring.
Make a Real SQL Cloud Transformation, Not Just a Migration
Explore cloud-native SQL transformation strategies, focusing on DevOps, scalability, and long-term outcomes beyond simple migration for optimal data management in the cloud era.