Dinesh's Blog :::: Being Compiled ::::

Let's talk about a very common scenario that you do with all solutions. If you need to implement a business logic using a database obj...

Here is a modern interview question on SQL Server. In addition to general questions on administration and maintenance, Azure based questio...

Let's talk about something common for all database management systems without talking something specific to SQL Server. This is the in...

Here is the Brain Basher of this week. During interviews, questions on deciding the hosting place for a planned database is very commo...

He is the Brain Basher or the interview question of the week. This is something every database engineer should know and it is not limited ...

Thought to share a specific conversation of one of the interviews did last month on a DBA role. The interview was done over the Skype call...

Here is a simple question I asked from an candidate I interviewed last week. This was not the exact topic discussed but while discussing s...

Sometime we need to take a copy of the database without data and have it as a new database. This either requires to generate the entire scr...

Everyone asks how to check whether the value is NULL and replace it with a different value if it is NULL because it is something that we c...

Let's talk about memory-optimized tables as a part of Brain Basher in this week. This question was raised during one of my workshops an...

Determining the backup strategy for a SQL Server database is not an easy task as there are many things to be considered. As per my experie...

You are the Database Administrator and you maintain a database with following characteristics; Database contains sensitive data. Datab...

Here is the question of the week. I am sure that you have seen guest  user account in your databases. This week question is based on it; ...

We archive data when we see that database has many records, they never get updated and they are rarely read. With traditional archiving wa...

The Identity property is not something new and it has been widely used with most of table when a surrogate key is required. It can be simp...

SQL Server 2016 is released and many have started using it. Here is a simple question on SQL Server 2016; True or False: SQL Server 20...

Here is the weekly question on the SQL Server for improving your knowledge for facing interviews. This time, let's talk about an area o...

Let's talk about Integration Services in this week for Brain Basher. SQL Server supports two deployment models named Package Deploymen...

SQL Server mainly maintains two structures for tables: Heap  and Clustered . If there is no clustered index created with the table, table ...

This is something I asked during an interview. While we were talking about system databases, I questioned interviewee that how get informa...