All about Databases
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 […]
Dynamic data masking is one of best security attribute introduced in SQL Server 2016 Community Technology Preview 3. This is a security mechanism which covers the sensitive piece of information in the output of a user query over a set of defined column. This feature is very easy to implement with Existing code as this […]
10 Habits of Healthy People: Despite the fact that health is often connected with an individual’s physical state, it incorporates a lot more. A true wellbeing is a mixture of mental, emotional, and spiritual health. Definitely, the last thing you would want to do is add more to-do’s on your daily list. But guess what? […]
This Blog illustrates about the most frequent questions which are asked about the Data file and Transaction Log file architecture. Intentionally I did not add any troubleshooting questionnaire in this blog because I will post a separate Questions\Answers blog for the same. 1) Explain the SQL Server Database Data File structure? SQL server divides the […]
