SQL Server Professional Development 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 Backup Tutorial

  
  
  
  

• SQL Server SELECT Tutorial

  
  
  
  

• SQL Server Restore Tutorial

  
  
  
  

• SQL Server Stored Procedure Tutorial

  
  
  
  

• SQL Server INFORMATION SCHEMA Tutorial

  
  
  
  

• SQL Server Integration Services (SSIS) Tutorial

  
  
  
  

• SQL Server Reporting Services Tutorial

  
  
  
  

• SQL Server Performance Monitoring and Tuning 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