HA - DR - Too Many Choices
Explore various high availability and disaster recovery options for SQL Server, weighing pros and cons to find the best fit for your company's needs and requirements.
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.
MDS from the Ground Up - Let Your Users Maintain Their Data
Master Data Services (MDS) empowers users to manage data quality and governance. Learn how MDS integrates with Excel, enforces data standards, and streamlines operational and analytical solutions.
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.
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.
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.
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.
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.
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.
Deploying Availability Groups in Virtualized Architectures
Best practices for deploying SQL Server Always On Availability Groups in virtualized environments, covering on-premises, cloud, and hybrid architectures across VMware, Hyper-V, Azure, AWS, and GCP.
Building Your First Hybrid Lab
Extend your local SQL Server lab to Azure with a step-by-step guide on implementing a hybrid cloud Availability Group, network connectivity, and highly available Active Directory.
Building a Home Computer Lab
Explore options for creating an affordable home computer lab to learn data technologies, from laptops to servers. Covers key considerations, tips, and virtualization for an effective setup.
Azure Synapse Analytics - A Data Lakehouse
Explore Azure Synapse Analytics, a unified service combining data warehousing and Big Data analytics. Learn about its features, scalability, and integration in modern data warehouses through demonstrations.
Modern High Availability and Disaster Recovery Topologies
Explore innovative HA/DR solutions for SQL Server, including traditional and advanced technologies like availability groups, log shipping, VM replication, and container-based approaches for enhanced data protection.
One Bite at a Time
Efficient techniques for anonymizing PII data, archiving old data, and performing garbage collection in databases. Learn to create procedures for updating large datasets while maintaining performance and avoiding blocking operators.
Best Practices for Deployment of SQL Server on Azure Virtual Machines
Optimize SQL Server deployment on Azure VMs: right-sizing, high availability, performance, migration, disaster recovery, and licensing for Windows and Linux environments.
Common Data Service - Why Is It Not Common Yet?
Explore Common Data Service's strengths and weaknesses in the Power Platform. Learn to build, ingest, and extract data through demos, understanding its role in centralizing business logic across applications.
Standardize Your Environments Leveraging Infrastructure As Code
Explore methodologies for standardizing SQL Server deployments, identify gaps, and learn how Infrastructure as Code tools like Terraform can enhance and streamline your environment setup.
Lift and Shift Your SQL Servers to Azure SQL Virtual Machines
Learn best practices for migrating SQL Servers to Azure, including assessment, sizing, and data transfer. Discover cost-saving strategies, hybrid deployments, and tools for efficient Azure migration of existing SQL infrastructure.
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.