Interview Questions Archives - Technology with Vivek Johari

Top 50 Azure Sql Troubleshooting Interview Questions And Answers

Top 50 Azure SQL Automatic Tuning Interview Questions and Answers (Beginner to Advanced)

Vivek Johari / July 25, 2026

Prepare for Azure SQL Administrator and Azure DBA interviews with this comprehensive collection of 50 Azure SQL Automatic Tuning interview questions and answers. Covering beginner to advanced topics, this guide explains Automatic Tuning, Query Store, FORCE LAST GOOD PLAN, CREATE INDEX, DROP INDEX, Intelligent Insights, performance optimization, monitoring, troubleshooting, and real-world scenarios to help you succeed in interviews and the DP-300 certification exam.

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

Azure SQL, Interview Questions

Top 50 Azure SQL Cost Optimization Interview Questions and Answers (Beginner to Advanced)

Vivek Johari / July 25, 2026

Prepare for Azure SQL Administrator and Azure DBA interviews with this comprehensive collection of 50 Azure SQL Cost Optimization interview questions and answers. Covering beginner to advanced topics, this guide explains DTU vs vCore, serverless compute, reserved capacity, elastic pools, auto-pause, storage optimization, monitoring, resource scaling, pricing models, and real-world cost-saving strategies to help you succeed in interviews and the DP-300 certification exam.

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

Top 50 Azure Sql Backup Restore Interview Questions And Answers Copy

Azure SQL, Interview Questions

Top 50 Azure SQL Backup & Restore Interview Questions and Answers (Beginner to Advanced)

Vivek Johari / July 24, 2026

Prepare for Azure SQL Administrator and Azure DBA interviews with this comprehensive collection of 50 Azure SQL Backup & Restore interview questions and answers. Covering beginner to advanced topics, this guide explains automated backups, point-in-time restore (PITR), geo-restore, long-term retention (LTR), backup redundancy, recovery strategies, business continuity, disaster recovery, Azure SQL Managed Instance backups, and real-world scenarios to help you succeed in interviews and the DP-300 certification exam.

Top 50 Azure SQL Backup & Restore Interview Questions and Answers (Beginner to Advanced) Read Post »

Azure SQL, Interview Questions

Top 50 Azure SQL High Availability & Disaster Recovery Interview Questions and Answers (Beginner to Advanced)

Vivek Johari / July 24, 2026

Prepare for Azure SQL Administrator and Azure DBA interviews with this comprehensive collection of 50 High Availability (HA) and Disaster Recovery (DR) interview questions and answers. Covering beginner to advanced topics, this guide explains geo-replication, auto-failover groups, backup and restore, business continuity, RPO, RTO, failover strategies, Azure SQL Managed Instance, SQL Server Always On, and real-world scenarios to help you succeed in interviews and the DP-300 certification exam.

Top 50 Azure SQL High Availability & Disaster Recovery Interview Questions and Answers (Beginner to Advanced) Read Post »

Top 50 Azure Sql Administrator Interview Questions And Answers

Azure SQL, Interview Questions

Top 50 On-Premise to Azure SQL Migration Interview Questions and Answers (Beginner to Advanced)

Vivek Johari / July 22, 2026

Ace your Azure SQL migration interview with this complete guide featuring 50 interview questions and detailed answers. Learn migration strategies, assessment tools, Azure Database Migration Service (DMS), Azure SQL Database, Azure SQL Managed Instance, Azure Migrate, downtime planning, performance tuning, security, and post-migration validation. Ideal for freshers, experienced DBAs, Azure professionals, and DP-300 certification candidates.

Top 50 On-Premise to Azure SQL Migration Interview Questions and Answers (Beginner to Advanced) Read Post »

Top 50 Azure Sql Optimization Interview Questions And Answers

Azure, Azure SQL, 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 SQL, Interview Questions, SQL Server

Azure SQL Interview Questions and Answers (50 Questions for Freshers & Experienced DBAs)

Vivek Johari / July 22, 2026

Ace your next Azure SQL interview with this comprehensive guide featuring 50 carefully selected interview questions and expert answers. Cover Azure SQL Database, Managed Instance, security, performance tuning, backups, high availability, monitoring, migration, and real-world troubleshooting scenarios for freshers, experienced DBAs, and DP-300 aspirants.

Azure SQL Interview Questions and Answers (50 Questions for Freshers & Experienced DBAs) Read Post »

Interview Questions, SQL Server

Top 30 SQL Server Interview Queries with Solutions & Detailed Explanations

Vivek Johari / July 17, 2026

Prepare for SQL Server interviews with 30 essential query-based questions. Learn practical solutions, detailed explanations, optimization tips, and real-world SQL examples.

Top 30 SQL Server Interview Queries with Solutions & Detailed Explanations Read Post »

DBA, Interview Questions, SQL Advanced, SQL Server

Mastering the “Gaps and Islands” Problem in SQL Server: Finding Consecutive Day Streaks

Vivek Johari / July 16, 2026

Learn how to solve the SQL Server Gaps and Islands problem to identify consecutive day streaks using ROW_NUMBER(), CTEs, and practical real-world examples.

Mastering the “Gaps and Islands” Problem in SQL Server: Finding Consecutive Day Streaks Read Post »

10 Remote Job Interview Questions That Can Make Or Break Your Chances In 2026

Career Advice, Interview Questions, Interview Tips

10 Remote Job Interview Questions You Need to Nail in 2026

Megha Johari / July 6, 2026

“Your skills got you the interview. Your answers will decide whether you get the offer.” Remote work is no longer

10 Remote Job Interview Questions You Need to Nail in 2026 Read Post »

Database Designing, Database Modeling, Database optimisation, DBA, Interview Questions, SQL Normalization, SQL Server, SQL Tips

Database Normalization vs Denormalization: When to Use Each

Vivek Johari / December 18, 2025

Introduction to Database Design Concepts Database design is the foundation of efficient data management systems. It determines how data is

Database Normalization vs Denormalization: When to Use Each Read Post »

Database Modeling, Database optimisation, DBA, Imp SQL Difference, Interview Questions, SQL Server, SQL Temporary Tables, SQL Tips

Temp Table vs Global Temp Table vs Temp Variable: The Ultimate Performance Comparison

Vivek Johari / November 26, 2025

Introduction: Why Temporary Structures Matter in SQL Server SQL Server provides several ways to store temporary data: temp tables, global

Temp Table vs Global Temp Table vs Temp Variable: The Ultimate Performance Comparison Read Post »

AI, Interview Questions

AI in Interviews – Friend or Foe?

Megha Johari / August 28, 2025

Job interviews have always been nerve-wracking, but now there’s a new player in the room: Artificial Intelligence. Companies are increasingly

AI in Interviews – Friend or Foe? Read Post »

Interview Questions, SQL Server

SQL Joins Tricky Interview Questions

Vivek Johari / April 17, 2019

In this article, I have tried to explain the SQL Join concepts with the help of the Interview questions which interview candidate faces regularly.

SQL Joins Tricky Interview Questions Read Post »

Interview Questions, SQL Advanced, SQL Indexes

Interview question – Is Clustered index on column with duplicate values possible?

Vivek Johari / August 13, 2015

Through this article, we are going to discuss three important interview questions of SQL which are given below:- 1) Can

Interview question – Is Clustered index on column with duplicate values possible? Read Post »

Interview Questions

Question of the Month (July)

Vivek Johari / August 3, 2015

Question of the Month Suppose we have a table emp_plan which contains 4 columns “Empid” (employeeid), Planid (Projectid), Startdate(Allocation Start date)

Question of the Month (July) Read Post »

Interview Questions, SQL Basic, SQL Server

Script to find complete months between two given dates

Vivek Johari / July 10, 2015

Complete months between two given dates Below script will help in finding the complete months within the 2 given dates.

Script to find complete months between two given dates Read Post »

Interview Questions, SQL Basic, SQL Server, SQL Tips

Script to find the complete weeks within two given dates

Vivek Johari / July 10, 2015

Complete weeks within two given dates Sometimes we need to find out the complete weeks within two given dates. Below

Script to find the complete weeks within two given dates Read Post »

Interview Questions

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

Top 50 Azure SQL Automatic Tuning Interview Questions and Answers (Beginner to Advanced)

Top 50 Azure SQL Backup & Restore Interview Questions and Answers (Beginner to Advanced)

Top 50 Azure SQL High Availability & Disaster Recovery Interview Questions and Answers (Beginner to Advanced)

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

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

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

Azure SQL Interview Questions and Answers (50 Questions for Freshers & Experienced DBAs)

Top 30 SQL Server Interview Queries with Solutions & Detailed Explanations

Mastering the “Gaps and Islands” Problem in SQL Server: Finding Consecutive Day Streaks

10 Remote Job Interview Questions You Need to Nail in 2026

Database Normalization vs Denormalization: When to Use Each

Temp Table vs Global Temp Table vs Temp Variable: The Ultimate Performance Comparison

AI in Interviews – Friend or Foe?

SQL Joins Tricky Interview Questions

Interview question – Is Clustered index on column with duplicate values possible?

Question of the Month (July)

Script to find complete months between two given dates

Script to find the complete weeks within two given dates