-
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…
-
March towards SQL Server : Day 5 – SQL DBA Interview Questions Answers – Data File and Transaction Log File Architecture
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…
-
March towards SQL Server : Day 4 – SQL DBA Interview Questions Answers – Database Architecture and Database Properties
This article comprises of Questions answers series on Database Architecture and various Database Properties. Intentionally I skipped Database Recovery Models, Backups, Restore, Data File and Transaction Log Architecture Questions from this series because I will cover them in a complete separate series on Database Backup, restores and File Architectures. 1) How many types of files…
-
March towards SQL Server : Day 3 – SQL DBA Interview Questions Answers – SQL Server Architecture
I am writing this blog based upon the Experience and knowledge which I gained after reading lot of Articles, Blogs, and Microsoft Documentation on SQL Server Architecture. Though it takes lot of time to collect this information and summarize it in a question series but I feel very proud and happy that I am giving…
-
March towards SQL Server : Day 1 – SQL DBA Interview Questions Answers – Installation
I have been thinking since long time to pen down a comprehensive series on most commonly asked DBA Interview questions. I have planned to segregate the entire questions series, topic wise to make it easier to explore. So here comes the First blog of this series based on SQL Server installation topic. I hope it…
-
What is SlipstreamMediaInfoCheck?
Checks whether the language of the original media is the same language as the specified service pack.
-
What is RS_IsDotNet3_5Installed?
This rule determines if the Microsoft .NET Framework 3.5 Service Pack 1 is required on the system, based on the features you selected and whether Microsoft .NET Framework 3.5 Service Pack 1 is already installed.
-
What is DEV10RTMDetected?
This rule determines whether the computer has any prior installations of Visual Studio 2010 that might require Service Pack 1 update.
-
What is ServerCoreNetFxCheck?
Checks if The Microsoft .NET Framework 4 Server Core is already installed on this computer or is available for installation.
-
What is ServerCoreBlockUnsupportedFeaturesCheck?
Checks if all selected features are supported on Windows Server Core.
-
What is PowerShellCheck?
Checks whether Windows PowerShell 2.0 is already installed on system. Windows PowerShell is needed by some SQL Server features.