SQL Server Interview Question SQL Server Agents

SQL Server DBA Interview Questions and Answers – SQL Server Agent and Its Components

This blog contains Question answers about the most frequently used tool by a Database Administrator i.e. SQL Server Agent. I tried to cover all the questions related to each and
SQL Server Interview Question SQL Server Agents SQL Terminologies

SQL Server DBA Interview Questions and Answers – SQL Server Services

This blog is all about the SQL Server Services which are required for the functionality of SQL Server components. It also contains Questions answers about the important parameters and SQL
Database Objects DBA Stuff Performance Tuning Scripts Troubleshooting

How to capture SQL Server blocking information

Many a times Application team report SQL Server Blocking issues. In this article I will explain about Blocking and Its cause. Due to this blocking issue Application team asks the
SQL Server Interview Questions SQL Terminologies

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
Indexes Scripts SQL Server

How to move Indexes (Cluster and Non Cluster) from Primary File group to New File group?

As a DBA, many times there are requirements to segregate data in a Database into multiple file groups. There can be many reasons like below: Performance issues (Disk I\O) Disk