Category: SQL Terminologies
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 +
3
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
Database Accidents : Unwanted Restore

Database Accidents : Unwanted Restore

Number of times, while working as a DBA many accidents happen. Most common of them is when a database is restored without checking if a backup is available or not. As a thumb rule ...

READ MORE +
0
Fragmentation of Log files and VLFs

Fragmentation of Log files and VLFs

In a SQL server, having multiple log files does not have any performance benefits as the log files are written sequentially. The log files can have external (disk level) ...

READ MORE +
0
DBAThings.com & SQL DBA Community integration

DBAThings.com & SQL DBA Community integration

Guys, I am happy to share that Admin of SQL Server DBA (India) – A special group of DBAs, has shown his great trust and allowed me to serve this community as co-admin. As you know ...

READ MORE +
0
What is SlipstreamMediaInfoCheck?

What is SlipstreamMediaInfoCheck?

Checks whether the language of the original media is the same language as the specified service pack.

READ MORE +
0