Month: April 2022

JPMorgan Chase -26th April 2022

  1. Isolation levels during heavy blockings – Snapshot isolation & read commit
  2. Bulk and full recovery log behavior – Like log file size (sqlperf) & log file (Physically )
  3. Elastic pool &
  4. SP running very slow parameter sniping – Execution plan & Query plan
  5. 2 database same configure & size – VLF issue
  6. Bookmark lookup & RID lookup & Key lookup
  7. Major differences in mirroring and always on
  8. How secure you will migrate the database from On-prem to Azure
  9. How you will choose Price-tiring & DTU
  10. SQL server up & running fine but application team not able to connect – SQL browser & Firewall & port
  11. Database recovery time (Redo and Undo and analysis )
  12. SQL server hardening
  13.  How Azure server managing the Tempdb
  14. PAAS database performance tuning
  15. Query running slow
  16. Geo replication & always on cluster different
  17. How DBCC CHECKDB works
  18. Container database
  19. Cleanup SQL Server Query Store
  20. Login impersonate

WIPRO 27th April 2022

  1. Log Architecture
  2. sql cluster split brain
  3. Database migration Procedure
  4. Index seek & index scan
  5. Memory utilization is high
  6. TDE
  7. SQL server new feature
  8. SQL server rebuild index job middle of failover what will happened
  9. Memory utilization high on SQL server
  10. Which of task you feel good in your carrier
  11. Database corruption  – Page level & suspend
  12.  Master & Model & MSDB rebuild
  13.  Powershell – Silent installation
  14. Always on configuration from scratch level