sql server management studio

Before we know what Microsoft SQL Server is, let's explain the concept of Database. Because we will use this concept many times in SQL Server.sql server management studio

What is Database?

The database is a regular collection of data. In the broadest sense, a structure called the Database which allows multiple-purpose storage of related data without repetition.
After briefly describing our database concept, let's see what the SQL Server is now, and what it does.sql server management studio

Microsoft SQL Server is the most used database server software. It is an enterprise-wide Database Management System that enables the creation and management of databases. The most widely used management system in the world is SQL Server. Using SQL Server, you can manipulate your data as you wish and return numerous and complicated results using Stored procedures.
s you. Thus you can get the desired data by reporting.sql server management studio
We have provided superficial information about SQL Server. Now let's take a look at the versions of SQL Server;

Microsoft SQL Server Enterprise Edition: The largest version of SQL Server. It provides 32 processor cache and 64GB RAM support. Provides advanced features such as backup server.

Microsoft SQL Server Standard Edition: An enhanced SQL edition for small and medium-sized organizations. It provides 32 Tb disk, 4 processor and 2Gb RAM support. sql server management studio

Microsoft SQL Server Personal Edition: This version of SQL Server can be installed on operating systems such as Windows 98, Windows XP, and Windows Vista, except for server-built operating systems. Supports up to 5 user accesses.

Microsoft SQL Server Developer Edition: A version that has a licensing model that allows developers to use it only. It has the same features as Enterprise Edition. sql server management studio

Microsoft SQL Server Desktop Engine (MSDE): The Desktop Engine is the simplest version of SQL Server. It does not host the services and features contained in other versions. It supports up to 25 users access. sql server management studio

Microsoft SQL Server Windows Compact Edition: The smallest and simplest database management system that can be built on devices using Windows CE. Used for applications running on PDAs and Mobile Phones. sql server management studio


What is Sql?

SQL (Structured Query Language) is the most popular query language used to retrieve data from relational database management systems, to organize data in the database, or to enter data into the system. SQL is primarily designed to support object-relational database management systems. However, beyond this goal, it has many features, as defined by ANSI and ISO standards.


Yorumlar