Category: Server Objects
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
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 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
March towards SQL Server : Day 7 – SQL DBA Interview Questions Answers – All about SQL Server Agent and Its Components

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 ...

READ MORE +
0
March towards SQL Server : Day 6 – SQL DBA Interview Questions Answers – All about SQL Server Services

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 ...

READ MORE +
0
March towards SQL Server : Day 5 – SQL DBA Interview Questions Answers – Data File and Transaction Log File Architecture

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 ...

READ MORE +
0
March towards SQL Server : Day 4 – SQL DBA Interview Questions Answers – Database Architecture and Database Properties

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, ...

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

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. ...

READ MORE +
0
Database Engine Instances (SQL Server): A Quick Refresher

Database Engine Instances (SQL Server): A Quick Refresher

SQL Server instance of the Database Engine is nothing but a copy of the sqlservr.exe executable that runs as an operating system service. This means for each running SQL Server ...

READ MORE +
0
What is SlipstreamMediaInfoCheck?

What is SlipstreamMediaInfoCheck?

Checks whether the language of the original media is the same language as the specified service pack.

READ MORE +
0
What is RS_IsDotNet3_5Installed?

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 ...

READ MORE +
0
What is DEV10RTMDetected?

What is DEV10RTMDetected?

This rule determines whether the computer has any prior installations of Visual Studio 2010 that might require Service Pack 1 update.

READ MORE +
0
What is ServerCoreNetFxCheck?

What is ServerCoreNetFxCheck?

Checks if The Microsoft .NET Framework 4 Server Core is already installed on this computer or is available for installation.

READ MORE +
0
What is PowerShellCheck?

What is PowerShellCheck?

Checks whether Windows PowerShell 2.0 is already installed on system. Windows PowerShell is needed by some SQL Server features.

READ MORE +
0