HCL Group MS SQL DBA Interview Questions and Answers

Explanation of differences between logshipping, mirroring, tempdb corruption, master db corruption, and agents used in replication

• Logshipping involves copying and restoring transaction logs from one server to another for disaster recovery.

• Mirroring involves maintaining an exact copy of a database on a secondary server for failover purposes.

• Tempdb corruption can occur due to hardware failures, software bugs, or other is...read more

A pull request is a method of submitting contributions to a project on GitHub for review and merging.

• Pull requests are commonly used in version control systems like Git to propose changes to a codebase.

• They allow developers to collaborate and discuss changes before merging them into the main branch.

• Pull requests typically include a description of the changes, related issues, and any necessary tests or documentation.

• Rev...read more

Stateful set is a Kubernetes controller that manages the deployment and scaling of a set of pods with persistent storage.

• Stateful set ensures that each pod in the set has a unique identity and stable network identity.

• Stateful set pods are created in order and are not replaced until they are deleted.

• Stateful set is commonly used for stateful applications like databases where each pod requires persistent storage.

• Example:...read more

Steps involved in migration process

• Assess current environment and identify migration goals

• Choose migration method (manual, scripted, tool-based)

• Prepare target environment and perform data migration

• Test migrated data and applications for functionality

• Implement post-migration tasks like user training and support

Migrating from SQL Server 2008 to 2019 involves upgrading the database, transferring data, and testing for compatibility.

• Perform a side-by-side upgrade by installing SQL Server 2019 on a new server and transferring databases using backup and restore or detach and attach methods.

• Use the Data Migration Assistant tool to assess compatibility issues and plan for any necessary changes.

• Update applications and scripts to ensu...read more

DBA backups in SQL are essential for data protection and disaster recovery.

• Regularly schedule full, differential, and transaction log backups to ensure data is protected.

• Store backups in secure locations to prevent data loss in case of hardware failure or corruption.

• Test backups regularly to ensure they can be restored successfully in case of emergency.

I am a dedicated and experienced MS SQL DBA with a strong background in database administration and performance tuning.

• Over 5 years of experience working as a MS SQL DBA

• Proficient in database administration tasks such as backup and recovery, performance tuning, and security

• Skilled in troubleshooting and resolving database-related issues

• Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Serv...read more