SQL Server Developer Tips and Tricks

Latest SQL Server Tips

• 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

• Configuring Distributed Availability Groups Between Failover Clusters on Different Active Directory Domains – Part 1

• SQL Database Overview

• Recover Script from Recently Closed Tab in SSMS You Forgot to Save

• Steps for Upgrading Always On SQL Servers and Skipping Versions

• How to Avoid Making Remote Desktop Connections to SQL Server

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

• SQL Server 2022 The hybrid data platform