windows Hosting Blog

System Databases in MSSQL Server :-

A Database Administrator should be aware of system databases which is an integral part of the MSSQL Server.

System Databases are essential for the operations of a server instance.

Single User mode allows only one single user to connect a database.

Even if SQL server is in the Single User Mode, you can connect the SQL Query Analyzer with       the SA user.

Single user mode specifies that only one user can at a time access the database. Basically it is used for maintenance like activities.
If any [...]

Very Basic SQL Statements :

SQL is used to query the database which are almost same for SQL Server, MySQL, MS Access, and Oracle database.
Four types of basic queries :-
SELECT
INSERT
UPDATE
DELETE
ORDER BY

Different combination of parameters can be passed to a MS SQL query.
1]   SELECT  :-
Its one of the most common SQL statement using which data can be [...]

RPC stands for Remote Procedure Call.
Service name : RpcSs
Description : “Serves as the endpoint mapper and COM Service Control Manager. If this service is stopped or disabled, programs using COM or Remote Procedure Call (RPC) services will not function properly.”
RPC is responsible for a application executing on one machine to access a service/process on another [...]