SQL Server System Databases

When we have installed SQL SERVER , it will have few system databases already installed as listed. These database is required to run the SQL Server.  master  tempdb  model  msdb resource  (Hidden Database ) distribution (Hidden Database ) Master Database:  It is primary database, without it, sql server cannot started. It contained information about the object […]

Read More

SQL Server View

SQL Server View: Views are basically virtual table whose column and rows are defined based on query results. Its more over selection of columns from one or more table. view can be used for the following purposes: To focus, simplify, and customize the perception each user has of the database. As a security mechanism by […]

Read More

Why ASP.NET MVC framework

MVC framework provides a lot of benefits for web development. The main objectives of the framework are: 1. Separation of Concerns:  MVC provides a clean, organized and efficient organization of code. It is very helpful for a web application to scale in terms of functionalities and also promotes good design pattern. 2. URL Routing Mechanism: […]

Read More