SQL Server Professional Development Tips and Tricks

Latest SQL Server Tips

• AWS Cost Optimization

  
  
  
  

• SOC 2 Audits to Analyze Policies, Procedures and Technology for Data Protection

  
  
  
  

• Automatically Generate Restore Database SQL Server Scripts

  
  
  
  

• Change Management for DBAs to Install and Track Database Changes

  
  
  
  

• 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 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

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

  
  
  
  

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

  
  
  
  

• Modern, Simple and Scalable SQL Server Disaster Recovery

  
  
  
  

• Load Testing Storage Performance for SQL Server