SQL Server Developer Tips and Tricks

Latest SQL Server Tips

• Microservice Application with Azure Container Apps, Dapr and Bicep

  
  
  
  

• Build a Streaming Data Architecture with Apache Kafka and Zookeeper

  
  
  
  

• Azure Database for MySQL Flexible Server Administrative Tasks

  
  
  
  

• Azure Cost Optimization Tools

  
  
  
  

• SQL Server Query Store for Query Performance History

  
  
  
  

• Apache Kafka for Streaming Real-Time Data

  
  
  
  

• Limit Cost Threshold for Parallelism for Small SQL Queries

  
  
  
  

• Change Advisory Boards (CAB) for Change Management

  
  
  
  

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

• Tackling the Gaps and Islands Problem with T-SQL Window Functions

  
  
  
  

• Reduce Cost for SQL Server Workloads on AWS using Optimize CPUs Feature

  
  
  
  

• Load Testing Storage Performance for SQL Server