Best Practices for Branching Database Code in Git
Learn best practices for branching database code in Git, covering strategies for different team sizes and release requirements. Explore popular branching models and their strengths, with special focus on database-specific considerations.
Emergency! Are You Ready for Disaster to Strike?
Prepare for data center disasters and ransomware attacks through regular practice of recovery processes. Learn strategies to ensure business continuity in critical situations.
Infrastructure for the DBA - An Introduction
Comprehensive overview of infrastructure layers for DBAs, covering hardware, network, storage, virtualization, and operating systems to enhance problem-solving and proactive management skills.
Turbocharge Your SQL Server with In-Memory Database
Discover how to leverage SQL Server 2019's memory-optimized technologies to enhance performance and scalability, taking advantage of modern hardware innovations for database applications.
Query Optimization Statistics - Driving Force Behind Performance
Explore SQL Server query optimization statistics, their impact on performance, and techniques to address common issues for improved query execution.
Never Lose Data - Digging Out From Corruption
Learn essential recovery techniques to prepare for, detect, and repair various corruption-based problems in databases, ensuring data integrity and minimizing disruptions in your enterprise.
Query Store In-Depth
Explore Query Store's capabilities, quirks, and real-world applications for troubleshooting performance issues in SQL Server, including updates for SQL Server 2019.
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.
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.
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.
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.
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.
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.
What is Power BI Doing to My Database?
Explore Power BI's impact on databases, including query types, frequency, and volume. Learn essential considerations for DBAs before, during, and after Power BI deployment in organizations.
Deploying SQL Server Big Data Clusters
Learn to deploy SQL Server Big Data Clusters, demystify Kubernetes, and compare on-prem vs cloud deployments. Gain practical tools and scripts for immediate implementation.
DevOps - SSDT Makes Deployment Consistent
Learn to deploy database code consistently and accurately using Azure DevOps pipeline. Explore techniques for setting up database objects, including security and reports, for successful and repeatable deployments across different environments.
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.
Execution Plans - Where Do I Start?
Learn to read and understand SQL Server execution plans, crucial for optimizing query performance and troubleshooting slow queries. Discover how to obtain plans and interpret them effectively.
ORMs and the DBA - How to Keep Both Happy
Explore strategies to mitigate ORM-related issues, improve performance, and satisfy both developers and DBAs. Learn to audit SQL, optimize code, and use tools for better ORM implementation.
Pay Less, Get More - A Guide to SQL Server Licensing
Optimize SQL Server licensing costs with expert guidance on editions, models, and scenarios for virtual environments, high availability, and non-production setups.