Azure SQL Database Archives - Technology with Vivek Johari

Azure Monitor for Azure SQL: Complete Monitoring Guide for DBAs (DP-300 & Real-World)

Vivek Johari / July 22, 2026

Master Azure Monitor for Azure SQL with this comprehensive guide for DBAs, Azure professionals, and DP-300 candidates. Learn Azure Monitor architecture, metrics, Log Analytics, KQL queries, diagnostic settings, alerts, Action Groups, SQL Insights, Workbooks, Service Health, Resource Health, automation, cost optimization, troubleshooting, and real-world monitoring best practices.

Azure Monitor for Azure SQL: Complete Monitoring Guide for DBAs (DP-300 & Real-World) Read Post »

Azure SQL Database, Interview Questions, SQL Server

Top 50 Azure SQL Data Security Interview Questions and Answers (Beginner to Advanced)

Vivek Johari / July 22, 2026

Master Azure SQL data security with this comprehensive guide featuring 50 interview questions and detailed answers. Cover essential security concepts including Transparent Data Encryption (TDE), Always Encrypted, Dynamic Data Masking, Row-Level Security (RLS), Microsoft Defender for SQL, auditing, authentication, authorization, Azure AD integration, and security best practices for freshers, experienced DBAs, and DP-300 certification candidates.

Top 50 Azure SQL Data Security Interview Questions and Answers (Beginner to Advanced) Read Post »

Azure, Azure SQL Database, Database Migration, Migration to Azure SQL Database

Azure SQL Migration Methods: The Complete Step-by-Step Guide for Seamless Database Modernization

Vivek Johari / July 21, 2026

Planning to migrate SQL Server to Azure SQL? This comprehensive guide explains every Azure SQL migration method, including Azure Database Migration Service (DMS), Backup & Restore, BACPAC, Transactional Replication, Log Shipping alternatives, and Azure Data Studio Migration Extension. Learn when to use each approach, their pros and cons, prerequisites, and best practices for a successful cloud migration.

Azure SQL Migration Methods: The Complete Step-by-Step Guide for Seamless Database Modernization Read Post »

Azure, Azure SQL Database, Performance Tuning

How to Identify Underutilized Azure SQL Databases and Reduce Costs

Vivek Johari / July 20, 2026

Learn how to identify underutilized Azure SQL Databases using built-in monitoring tools and Dynamic Management Views (DMVs). Discover practical techniques to right-size your databases, reduce Azure costs, and improve resource utilization without sacrificing performance.

How to Identify Underutilized Azure SQL Databases and Reduce Costs Read Post »

Azure SQL Database, DBA

Azure SQL DBA Cheat Sheet

Vivek Johari / July 17, 2026

Keep this Azure SQL DBA Cheat Sheet handy for essential commands, monitoring, Query Store, DMVs, security, backups, performance tuning, and administration best practices.

Azure SQL DBA Cheat Sheet Read Post »

Azure SQL Database, Database optimisation, Performance Tuning, SQL Server

SQL Server / Azure SQL Performance Tuning Cheat Sheet

Vivek Johari / July 17, 2026

Master SQL Server and Azure SQL performance tuning with this practical cheat sheet covering Query Store, execution plans, indexing, DMVs, wait statistics, memory, CPU optimization, and performance best practices.

SQL Server / Azure SQL Performance Tuning Cheat Sheet Read Post »

Azure, Azure SQL Database, Database optimisation, Performance Tuning, SQL Server

Using Query Store to Identify Expensive Queries in Azure SQL Database

Vivek Johari / July 17, 2026

Learn how Query Store helps identify expensive queries in Azure SQL Database. Discover how to analyze CPU, duration, logical reads, execution plans, and query regressions to improve database performance.

Using Query Store to Identify Expensive Queries in Azure SQL Database Read Post »