Category: SQL Terminologies
March towards SQL Server : Day 7 – SQL DBA Interview Questions Answers – All about SQL Server Agent and Its Components

March towards SQL Server : Day 7 – SQL DBA Interview Questions Answers – All about 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 ...

READ MORE +
0
March towards SQL Server : Day 6 – SQL DBA Interview Questions Answers – All about SQL Server Services

March towards SQL Server : Day 6 – SQL DBA Interview Questions Answers – All about 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 ...

READ MORE +
0
March towards SQL Server : Day 5 – SQL DBA Interview Questions Answers – Data File and Transaction Log File Architecture

March towards SQL Server : Day 5 – SQL DBA Interview Questions 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 ...

READ MORE +
0
March towards SQL Server : Day 4 – SQL DBA Interview Questions Answers – Database Architecture and Database Properties

March towards SQL Server : Day 4 – SQL DBA Interview Questions Answers – Database Architecture and Database Properties

This article comprises of Questions answers series on Database Architecture and various Database Properties. Intentionally I skipped Database Recovery Models, Backups, Restore, ...

READ MORE +
0
March towards SQL Server : Day 3 – SQL DBA Interview Questions Answers – SQL Server Architecture

March towards SQL Server : Day 3 – SQL DBA Interview Questions Answers – SQL Server Architecture

I am writing this blog based upon the Experience and knowledge which I gained after reading lot of Articles, Blogs, and Microsoft Documentation on SQL Server Architecture. ...

READ MORE +
0
March towards SQL Server : Day 2 – SQL DBA Interview Questions Answers – Security Permissions

March towards SQL Server : Day 2 – SQL DBA Interview Questions 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 ...

READ MORE +
0
March towards SQL Server : Day 1 – SQL DBA Interview Questions Answers – Installation

March towards SQL Server : Day 1 – SQL DBA Interview Questions 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, ...

READ MORE +
2
SQL DBA Cheatcode Part 3 : Few Important Queries for any DBA

SQL DBA Cheatcode Part 3 : Few Important Queries for any DBA

In continuation of our DBA Cheatcode series :-   I started this series on Queries\T-SQL commands that we use in our day to day operations or those queries which should ...

READ MORE +
2
10 Interesting things that ‘CAN NOT’ be done in SQL Server

10 Interesting things that ‘CAN NOT’ be done in SQL Server

I was just thinking about few interesting facts about SQL Server properties which are good to be known for a SQL Server DBA. You can not add data and log files in master and ...

READ MORE +
0
Common Human Errors as DBA (Part 3)

Common Human Errors as DBA (Part 3)

  In continuation of the series of “Common Human Errors as DBA” – here I am posting Third Part of it. You may check others here. Part 1 & Part 2 Poor naming ...

READ MORE +
0
Is tempdb configured correctly?

Is tempdb configured correctly?

Let’s learn about tempdb and some of the best practices about tempdb. Before doing this, let’s talk about tempdb and its usage. A Tempdb is a system database that is available ...

READ MORE +
0
Common Human Errors as DBA (part 2)

Common Human Errors as DBA (part 2)

You must have read my previous post (Part-1) about Common Human Errors as DBA and how to avoid them. Here is another post of the same series. Third error - Data or Log file ...

READ MORE +
0
MAXDOP – What is best approach to use it!!!

MAXDOP – What is best approach to use it!!!

The Maximum Degree of Parallelism (MAXDOP) setting will determine the degree to which SQL server will attempt to parallel process transactions which are received from the ...

READ MORE +
0
Database Engine Instances (SQL Server): A Quick Refresher

Database Engine Instances (SQL Server): A Quick Refresher

SQL Server instance of the Database Engine is nothing but a copy of the sqlservr.exe executable that runs as an operating system service. This means for each running SQL Server ...

READ MORE +
0
Common Human Errors as DBA (part 1)

Common Human Errors as DBA (part 1)

“Human Error” is not a new word. Most of the time if there is screwed up done by any one – these golden words are used. For sure, these are the Human Errors and its hard to ...

READ MORE +
0