SQL Server Troubleshooting

All about SQL Server Error logs

SQL Server error logs are one of the important stuff to check whenever DBA face issues in the SQL Server instance. It contains lot of information about the Issues, Errors, Backup related information and Database consistency check occurrences based on the Trace Flag configuration of SQL Server instance. SQL Server error log file is recycled […]

Permission & Security SQL Server

SQL DBA Interview Questions and Answers – Security Permissions

1) What is Authentication and Authorization? What is the difference between both? Authentication is the process of verifying who you are. Logging on to a PC with a username and password is authentication. Authorization is the process of verifying that you have access to something. Authorization is gaining access to a resource (e.g. directory on […]

SQL Server Installations & Configuration Interview Question

SQL Server DBA Interview Questions and Answers-Installation

I have been thinking since long time to pen down a comprehensive series on most commonly asked DBA Interview questions. I have planned to segregate the entire questions series, topic wise to make it easier to explore. So in this post I am writing about the most commonly asked SQL Server Questions  on SQL Server installation […]