SQL Server DBA Tips and Tricks

Latest SQL Server Tips

• SQL Server Index Maintenance Checklist

• Build Distributed Availability Groups to migrate SQL Server databases to a different AD Domain - Part 2

• My Favorite T-SQL Enhancements in SQL Server 2022

• PowerShell for the DBA - CMDLETs and Advanced Functions

• Snowflake for Microsoft SQL Server Developers - Transactions - Part 1

• Synapse Analytics vs Snowflake for Delta Format Files, Machine Learning, Table Relationships and Constraints

• Implementing Fact-to-Dimension Mapping on Lakehouse using Synapse Mapping Data Flow

• Getting Started with Query History and Table Designer in Azure Data Studio

SQL Server Tutorials

• SQL Server Backup Tutorial

• SQL Server Restore Tutorial

• SQL Server INFORMATION SCHEMA Tutorial

• SQL Server Performance Monitoring and Tuning Tutorial

• MySQL to SQL Server Conversion Tutorial

• SQL Server Graphical Query Plan Tutorial

• SQL Server Query Performance Guidelines Tutorial

• SQL Server Transaction Log Tutorial

SQL Server Webcasts

• Validating and Enriching SQL Server data with Unison

• Easily Encrypt SQL Server Databases and Backups - All Versions and Editions

• Performance Troubleshooting SQL Server with Native Tools

• Disaster: LIVE! - SQL Server from disaster to operational