SQL Terminologies | DBA THINGS - Part 8
Category: SQL Terminologies
0
March towards SQL Server : Day 5 – SQL DBA Interview Questions Answers – Data File and Transaction Log File Architecture
0

This Blog illustrates about the most frequent questions which are asked about the Data file and Transaction Log file architecture. Intentionally I did not ...

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

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

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

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

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

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

0
March towards SQL Server : Day 1 – SQL DBA Interview Questions Answers – Installation
4

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

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

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

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

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

0
Common Human Errors as DBA (Part 3)
0

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

0
Is tempdb configured correctly?
0

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

0
Common Human Errors as DBA (part 2)
0

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

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

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

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

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

0
Common Human Errors as DBA (part 1)
0

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

0
Database Accidents : Unwanted Restore
0

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

0
Fragmentation of Log files and VLFs
0

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