SQL Server Developer 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 SELECT Tutorial

• SQL Server Stored Procedure Tutorial

• SQL Server INSERT Tutorial

• Visual Studio 2010 and SQL Server Tutorial

• SQL Server Database Development Tutorial

• SQL Server Data Tools (SSDT) SQL Project Tutorial

• SQL Server Regex Tutorial

• SQL Server Window Functions 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