SQL Server Developer Tips and Tricks

Latest SQL Server Tips

• Monitor for Hung SQL Server Agent Jobs

  
  
  
  

• Limit Data Scanning and Excess Query Plans in Amazon Athena

  
  
  
  

• What are Kusto Query Language (KQL) databases in Microsoft Fabric?

  
  
  
  

• Solving Date Range SQL Server Query Performance Issues with OPTION RECOMPILE

  
  
  
  

• How to install SQL Server 2022 step by step

  
  
  
  

• Learn Spark SQL Date and Time Functions

  
  
  
  

• PowerShell Commands to Administer Virtual Machines on Amazon AWS - Part 2

  
  
  
  

• Array Based Snapshots for the SQL Server DBA

  
  
  
  

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

• SQL Server 2022 New Storage Features

  
  
  
  

• Best Practices for Cloud-Based Modern .NET Apps and SQL Server