DBA / Database

What is msdb in SQL Server?

How do transactions work in SQL Server?

What is mirroring in SQL Server and how does it differ from replication?

What is the difference between Always On Availability Groups and regular replication?

How does the locking mechanism and lock escalation work in SQL Server?

How does database recovery work from full + differential + transaction log backups?

How did you determine that these specific indexes on these columns would help improve query performance?

What queries accelerate indexes and why?

What are the transaction isolation levels in SQL Server?

What system databases are available in MS SQL Server?

Tell me about the architecture of MS SQL Server

Tell me how you made backups on the project that you used.

What is Query Store in SQL Server and where is it located?

How do backups work in SQL Server (full, differential, transaction log)?

What types of database queries do we have?