What is MSSQL Database?


8 shares
definition of MSSQL
Sponsored Links

Before MSSQL, it is better to mention what database is.

 

Database

 

Database.jpg

Simply, it is a collection of regular data. In the broad terms, we call the database, which allows the storage of data that are related to each other in some way for many purposes. For more information about the database, you can read the Article "What is DATABASE".

MSSQL 


mssql.jpg

MSSQL is a database type created by Microsoft. MSSQL can usually be confused with MYSQL. Although MYSQL is open-source software, MSSQL is a paid system. If programmers use a database on the web or desktop programming, first they need to decide which type of database system to use. It depends on the needs. Some of them choose Access as required by the program, while others select one of the database systems, such as MSSQL or MYSQL, which also depends on the needs of the program. So MSSQL is actually a database type.

On which systems MSSQL can work 

If you choose to use MSSQL in your project, basically you need a program to create, manage and design this database. The name of this program is SQL Server 2008 R2. or you can see your business in SQL Server 2008 Express Edition, where you can do more limited operations. Through these programs, you can create a database of MSSQL type and design the database by making the necessary settings. Briefly, you design the database.

How different from Access 

access.jpg

You may ask yourself " Microsoft Access is also a database management program" Yes it is also a database management program, but not like  MSSQL.  MSSQL runs on a server. So a database that you create is actually created on the server. In contrast, Access is a portable database that is created by the user on a desktop computer. In MSSQL, you create the database on the server and design it on the server again. Controlling from the center is essential.

Everyone is connected to a common database, and the data is transmitted from this source to the user. Access is a bit deficient in this meaning. In addition, MSSQL, which has a more stable structure, gives Microsoft Access a boost in terms of the data it stores. MSSQL web design works much faster with ASP and ASP.NET pages. Because they are both developed by the same company and they work as I mentioned before.

Sponsored Links

Beğendin mi? Arkadaşlarınla Paylaş O Zaman!

8 shares

Sizin Tepkiniz Nedir?

Funny Funny
23
Funny
I like that I like that
24
I like that
Dislike Dislike
16
Dislike
OMG OMG
13
OMG
alpinpon

0 Comments

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir