SQL Server Business Intelligence 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 Integration Services (SSIS) Tutorial

  
  
  
  

• SQL Server Reporting Services Tutorial

  
  
  
  

• SQL Server Analysis Services (SSAS) Tutorial

  
  
  
  

• SQL Server Report Builder 3.0 Tutorial

  
  
  
  

• SQL Server Analysis Services (SSAS) Administration Tutorial

  
  
  
  

• My First SQL Server Business Intelligence Project Tutorial

  
  
  
  

• SQL Server Master Data Services Tutorial

  
  
  
  

• SQL Server DAX 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