Performance Counters Data collection using TypePerf utility

SQL Server performance tuning and Optimizing SQL Server is part of the day to day job of a Database administrator. One of the key aspects of Performance tuning is to gather...

SQL Server DBA Interview Questions and Answers-Data File and Transaction Log File Architecture

This Blog illustrates about the most frequent questions which are asked about the Data file and Transaction Log file architecture. Intentionally I did not add any troubleshooting questionnaire in this blog...

Database Online training offers – Udemy $14.99 sale

In today's unpredictable IT world, learning is not only a straightforward thing to do — it is key to the survival in the competition. Particularly in the recession time, it is...

SQL Server DBA Interview Questions and Answers – Always ON – 2

I hope you enjoyed my last post on Always On. Here goes the final post on Always On feature. What is availability group wizard? Availability Group Wizard is a GUI using SQL...

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...

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...
SQL Server Encryption

How to use SQL Server Encryption to Secure data?

SQL Server Encryption Implementation What is Data Sensitivity? Data protection and security is one of the most important aspects of a database design nowadays. Virtually no database today can run without having...

SQL Server Database backups: Third party backup tools

While discussing about the roles and responsibilities of DBAs, backup and restore is counted as on the important activity of a Database Administrator as a day to day task. Though most...

SQL Server DBA Interview Questions and Answers – Database Mirroring – 1

In this blog I am discussing the SQL Server Interview Questions answers on Database Mirroring. This is very interesting topic and consists of very wide range of terminologies and scope. I will...

SQL Server DBA Interview Questions and Answers – Database Backups and Restore-2

Continuing my Blog series on the SQL Server DBA Interview Questions on Database Backup Restores, I am posting another set of 31 questions which will help you to understand the SQL...

APLICATIONS

SQL Server DBA Interview Questions and Answers – Always ON...

SQL Server Always On  is one of the intersting feature introduced with SQL Server 2012 version. I am listed the Questions with answers which are asked...
Skip to toolbar