-
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 liking my posts in different forums. I am ending this series but I will be back with lot more new ideas. Stay…
-
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 to temporarily set specific server characteristics or to switch On/Off a particular behavior. Trace flags are frequently used to diagnose performance issues or to debug stored procedures.…
-
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 , Part 2 and Part 3. 1. What are the lockable resources in SQL Server? The following table shows the resources that the Database…
-
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 Part 2 1. What is Isolation level in SQL Server? Isolation level defines the degree to which one transaction must be isolated from resource or data…
-
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 something that can’t be covered end to end – you know that. Let me try starting from basic concepts to some scenarios type question. What is the use…
-
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? A database snapshot is a view of what the source database looked like at the time at which the snapshot was created. This means that all the objects will…
-
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 other posts on Backup/Restore here. Day 10, Day 11 & Day 13 1) What are Partial Backups in SQL Server? Partial backups…
-
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 environment? It’s very open ended Question: As per my understanding, normally Organizations follow below standards Prod/QA Environment: For Small size databases (<200…
-
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 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 of a…
-
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 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 that can…
-
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 we install Microsoft SQL Server, five system databases are automatically created for each SQL Server instance. These system databases allow the database engine and administrative applications to properly manage the…
-
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 Management Studio. SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.…
-
March towards SQL Server : Day 7 – SQL DBA Interview Questions Answers – All about SQL Server Agent and Its Components
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 about. I will try to combine…
-
March towards SQL Server : Day 6 – SQL DBA Interview Questions Answers – All about SQL Server Services
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. 1) List out various services which are important for SQL Server and its components functionality? SQL Server Service SQL Server Agent service…