Kennametal interview

 

1. Difference’s between delete & truncate
2. purpose of login & contained database & login and user diff
3. how to configure the log-shipping
4. why system database are in full recovery mode
5. Mirroring procedure
6. Difference between FCI & always on
7. Point in time recovery
8. importance of resource database
9. Migration procedure

 

Merck blue jean interaction 10th June 2019

1. How to migrate SQL server 2005 to 2017 (DMA)
2. SQL query ruining slowly
3.  How can we restrict SA password,
4. Azure backup & restore service vault & bakpac files
5. Always on configuration & cluster
6. always on new features in SQL server 2017