Category: SQL Terminologies
System Databases : Restrictions Matrix

System Databases : Restrictions Matrix

Dear Readers, Today, I tried to consolidate a list of restrictions that are applied to system databases. Restrictions are nothing but the operations that you "can not" perform ...

READ MORE +
0
Question : Who is a DBA?

Question : Who is a DBA?

This post is targeted for those who are keen or new to DBA profession. Based on my experience I tried to write about DBAs and Possible career paths related to it. Who is a ...

READ MORE +
0
March towards SQL Server : Day 31 – SQL DBA Interview Questions Answers – SQL Server 2012 and 2014 New Features

March towards SQL Server : Day 31 – SQL DBA Interview Questions Answers – SQL Server 2012 and 2014 New Features

Hello Readers, Today I am posting the last post for my series 'March Towards SQL Server'. At this point, I would like to say thank you for boosting me up by commenting or ...

READ MORE +
1
March towards SQL Server : Day 30 – SQL DBA Interview Questions Answers – About Traces & System Stored procedures

March towards SQL Server : Day 30 – SQL DBA Interview Questions Answers – About Traces & System Stored procedures

Lets talk about Traces and System procedures that are very useful for a DBA Routine. Interview Questions on Trace Flags What are trace flags? Trace flags are used ...

READ MORE +
0
March towards SQL Server : Day 26 – SQL DBA Interview Questions Answers – SQL Server Performance Tuning – 4

March towards SQL Server : Day 26 – SQL DBA Interview Questions Answers – SQL Server Performance Tuning – 4

Here I am posting final post on SQL Server Performance Tuning concepts. I hope you must have read our previous posts on Performance Tuning. If not, have a quick look Part1 , ...

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

March towards SQL Server : Day 25 – SQL DBA Interview Questions Answers – SQL Server Performance Tuning – 3

Here goes another post on Performance Tuning concepts. You may want to take a quick look at previous post on this topic. Performance Tuning Part 1 Performance Tuning ...

READ MORE +
0
March towards SQL Server : Day 23 – SQL DBA Interview Questions Answers – SQL Server performance Tuning

March towards SQL Server : Day 23 – SQL DBA Interview Questions Answers – SQL Server performance Tuning

Dear Reader, Today, I thought of writing interview questions on SQL Server Performance Tuning. I tried my best to touch upon many areas however Performance Tuning is ...

READ MORE +
0
March towards SQL Server : Day 17 – SQL DBA Interview Questions Answers – SQL Server Cluster

March towards SQL Server : Day 17 – SQL DBA Interview Questions Answers – SQL Server Cluster

Today I am writing a Blog Series on one of my Favorite topic – SQL Server Cluster.  This will include all the possible Questionnaire which are asked in the Interviews related ...

READ MORE +
1
March towards SQL Server : Day 16 – SQL DBA Interview Questions Answers – Database Mirroring – 2

March towards SQL Server : Day 16 – SQL DBA Interview Questions Answers – Database Mirroring – 2

  Continuing with my previous post of Interview Questions series on Database Mirroring, this is the second blog on Database Mirroring. 1) What is Database Snapshot? ...

READ MORE +
0
March towards SQL Server : Day 13 – SQL DBA Interview Questions Answers – Database Backups and Restore-4

March towards SQL Server : Day 13 – SQL DBA Interview Questions Answers – Database Backups and Restore-4

Here I am posting fourth and last series of Backup/Restore interview questions. I am trying to cover most of the known errors and some concepts too. You may take a look at the ...

READ MORE +
0
March towards SQL Server : Day 12 – SQL DBA Interview Questions Answers – Database Backups and Restore-3

March towards SQL Server : Day 12 – SQL DBA Interview Questions Answers – Database Backups and Restore-3

Lets have some more questions on Backup and Restore. You may visit my other backup and restore related blogs here Day 10 and Day 11 1) What is the Backup strategy in your ...

READ MORE +
0
March towards SQL Server : Day 11 – SQL DBA Interview Questions Answers – Database Backups and Restore-2

March towards SQL Server : Day 11 – SQL DBA Interview Questions Answers – Database Backups and Restore-2

  Continuing my Blog series on the Interview Questions on Database Backup Restores, I am posting another set of 31 questions which will help you to understand the SQL ...

READ MORE +
0
March towards SQL Server : Day 10 – SQL DBA Interview Questions Answers – Database Backups and Restore-1

March towards SQL Server : Day 10 – SQL DBA Interview Questions Answers – Database Backups and Restore-1

  This blog contains series of most commonly asked Interview Questions regarding one of the important DBA tasks- Database Backups and Restore. Since this is very wide ...

READ MORE +
1
March towards SQL Server : Day 9 – SQL DBA Interview Questions Answers – All about SQL Server System Databases and Recovery Model

March towards SQL Server : Day 9 – SQL DBA Interview Questions Answers – All about SQL Server System Databases and Recovery Model

This blog is about the interview Questions on the System databases, Important activities with the system databases and Recovery models. 1) What are system databases? When ...

READ MORE +
1
March towards SQL Server : Day 8 – SQL DBA Interview Questions Answers – All about SQL Server Tools and Executables

March towards SQL Server : Day 8 – SQL DBA Interview Questions Answers – All about SQL Server Tools and Executables

This blog is all about the SQL Server related tools and executables which are used by all level of DBAs for various tasks. 1) What is SSMS? SSMS stands for SQL Server ...

READ MORE +
0