Performance Optimization with Azure SQL Database
Discover built-in Azure tools for identifying and resolving database performance issues, enhancing customer experience and streamlining troubleshooting processes.
SQL Server 2019 Big Data Clusters Architecture - Modernizing Your Data Platform
Explore SQL Server 2019's big data cluster architecture, integrating SQL Server with HDFS for petabyte-scale storage and leveraging Kubernetes for scalable data processing and virtualization.
Introduction to SQL Server Temporal Tables
Learn SQL Server temporal tables for versioning and historical data analysis. Explore creation, querying, and practical applications of this powerful feature for time-based data management.
What's New in SQL Server 2019
Explore SQL Server 2019's enhancements in performance, security, Linux support, and Big Data Clusters. Learn about new features and improvements across the SQL Engine and Availability groups.
Log Shipping in SQL Server - High Availability and Disaster Recovery
Explore SQL Server log shipping for HA and DR, covering fundamentals, setup, use cases, and custom configurations. Gain practical insights through demos for server migration and business continuity.
High Availability - Disaster Recovery 101
Learn SQL Server 2019 HA/DR strategies to meet RTO/RPO goals. Compare technologies, design solutions, and develop policies for effective implementation in various scenarios.
Desenvolvimento e Administração em SQL Server com Python
Integração do Python com SQL Server para desenvolvimento de aplicações e administração de infraestrutura em ambientes de bancos de dados, explorando as capacidades multiplataforma e poliglotas do SQL Server desde a versão 2017.
SQL Notebooks in Azure Data Studio for the DBA
Explore SQL Notebooks in Azure Data Studio for DBAs: simplify workflows, create diagnostic query notebooks, and discover practical use cases for daily database administration tasks.
My Romantic Relation with Powershell Generally - and with dbatools Especially
Discover the power of PowerShell and dbatools for efficient database management. Learn practical scenarios like automatic restore testing, log shipping, migrations, and upgrades to enhance your DBA skills.
A Beginner's Guide to Becoming a Performance Tuner
Discover hidden performance killers in SQL Server through worst practices. Learn server configuration, T-SQL parallelism, and TempDB issues to jumpstart your journey as a performance tuner.
The Evolution of the DBA in the Age of Cloud
Explore how cloud computing and automation are reshaping the DBA role, and learn strategies to adapt and thrive as a data professional in this evolving landscape.
Storage 101 for the DBAs
Learn essential storage concepts for SQL Server, including IO basics, best practices, and troubleshooting tips to optimize performance and quickly diagnose issues.
The Care and Feeding of SQL Server
Learn essential SQL Server administration tasks: backups, integrity checks, index maintenance, disk management, and alerting. Gain foundational knowledge for effective database management and maintenance.
SQL Server 2017 Database Engine Enhancements - Why You Should Upgrade to It
Explore SQL Server 2017's Database Engine enhancements, including improved query processing, scalability features, and reasons to upgrade from previous versions.
MSAs, GMSAs, and Groups - Use SQL Without Traditional User Accounts
Explore Active Directory features for enhanced SQL security, including AD Groups, MSAs, and GMSAs. Learn to simplify access management and reduce risks in database environments.
Query Analysis Deep Dive - 13 Causes of a Slow Query
Comprehensive exploration of 13 common query performance issues, providing practical solutions and a checklist for optimizing slow SQL queries.
Virtual SQL Server Performance Deep Dive
Explore virtualization's impact on SQL Server performance, covering CPU scheduling, storage, networking, and optimization techniques for maximum efficiency in virtual environments.
DataOps - Deploy SQL Server Databases Using Azure Pipelines
Learn to automate SQL Server database deployments using Azure Pipelines and Visual Studio Database Projects. Covers creating projects, manual deployments, and setting up automated pipelines with secure credential management.
Should I Move My Production SQL Server Workloads to Containers
Explore the pros and cons of containerizing SQL Server workloads, examining architectural differences, advantages, and challenges to help decide if containers are right for your production environment.
Improving Availability in SQL Server and Azure SQL Database with Accelerated Database Recovery and Resumable Operations
Discover innovations in SQL Server 2019 and Azure SQL Database that enhance database availability, reduce downtime, and streamline maintenance operations for improved performance and reliability.
Data Classification and Masking - The What and How of Data Protection
Learn techniques for protecting sensitive data across systems using SSMS and SQL Server tools. Explore data classification, dynamic and static masking to ensure data security while maintaining accuracy for testing and analytics.