All about Databases
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 other posts on Backup/Restore here. Database Backup and Restore – 1, Database Backup and Restore – 2 & Database Backup and Restore […]
Lets have some more questions on Backup and Restore. You may visit my other backup and restore related blogs here Database Backup and Restore – 1 and Database Backup and Restore – 2 1) What is the Backup strategy in your environment? It’s very open ended Question: As per my understanding, normally Organizations follow below […]
Continuing my Blog series on the SQL Server DBA Interview Questions on Database Backup Restores, I am posting another set of 31 questions which will help you to understand the SQL Server Database backups topic in more depth. 1) What are the Best Practices recommendations related to SQL Server Database backups? Backup is an important component […]
This blog contains series of most commonly asked SQL Server DBA Interview Questions regarding one of the important DBA tasks- Database Backups and Restore. Since this is very wide topic, I will try to cover all the sub topics in 2-3 blogs. 1) What are database backups? A Database backup is a copy of SQL Server data […]
System databases are very important part of the Database Management system. It plays a vital role in Database Administration as SQL Server functionality is based on the system database. This blog is about the SQL Server DBA interview Questions on the System databases, Important activities with the system databases and Recovery models. 1) What are system […]
Every DBA uses multiple tools to perform the day to day Database Administration tasks to make his\her life easy. In this blog I am writing 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 Management […]
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 every component of SQL Server agent except Database Maintenance plans because this is itself a big topic to discuss. I will try to combine Database […]
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 parameters and SQL Server start process. SQL Server DBA Interview Questions and Answers 1) List out various services which are important for SQL Server and its components functionality? […]
Introduction to PowerShell Windows PowerShell is a Windows commandline shell scriptining mechanism particularly designed for System Admins. Windows PowerShell providex an inteactive command prompt and a scripting tool that can be utilized or integrated with other progmaming languages or can be used individualistically. Unlike most of the shell scripting languages, which acknowledge and return text, […]
Many a times Application team report SQL Server Blocking issues. In this article I will explain about Blocking and Its cause. Due to this blocking issue Application team asks the DBA team to capture the code which is causing the blocking. SQL Server profiler is one of the tool through which we can capture the […]
