- 21 Eki 2015
- 477
- 1
SQL Server Comprehensive Expression... What is SQL Server?
SQL Server: a client/server is a relational database management system that uses Transact-SQL to communicate between client and SQL Server.
Client/Server Architecture
SQL Server uses the client/server architecture to separate the work environment into jobs running on client and server computer.
Client runs on one or more client computers but it also works with SQL Server on server computers.
SQL Server manages databases and splits the appropriate server resources as requests increase.
Client/Server architecture allows us to organize applications for various environments. The client programming interface allows you to run applications on different client computers and transmit them to the server via then network.
Relational Database Management System
The relational database system is responsible for:
Provide a relationship between the data in the database.
Ensure that data is stored according to rules that dont break relationship between data.
Retrieving all data in case of failed system events.
Transact SQL
SQL is a set of commands that allow you to explicitly specify information that is requested to be corrected and changed. With Transact-SQL, you can access, update and manage data and queries as well as the relational database system. Supports the latest ANSI SQL standart. ANSI is called SQL-92.
SQL Server Platform
Several or more operating system platforms can be used to create and run applications. This platforms can be used as client such as MS-DOS, Windows 3.x, Windows NT, Windows 9.x, Third Party (Like Unix and Apple Macintosh), Internet Browser; this platforms can be used as server such as Windows NT, Windows 9.x.
Compatibility of SQL Server with Windows NT
SQL Server is fully compatible with Windows NT and it has many advantages.
Security: SQL Server is compatible with the security system in Win NT. This compatibility allows a single username and password to access both SQL Server and Win NT. SQL provides its own security for those who arent Microsoft Client (Banyan, VINES, Apple Talk, Novell). SQL Server also uses Win NTs encryption for network security.
Multi-Processor Support: SQL Server automatically has the advantages of extra processors added to the server computer. SQL Server supports the symmetric multiprocessing (SMP) capabilities of WinNT.
Microsoft Event Viewer: SQL Server sends messages to WinNT applications, security and system event logs, providing a convenient mechanism for viewing and monitoring problems.
Windows NT Services: SQL Server runs as a service on WinNT and allows SQL Server to start and stop.
Windows NT Performance Control: It sends performance metrics to the WinNT performance control that allow SQL Server to manage system performance.
Alias: This is the database username shared by different login IDs. Database alias allows you to handle more than one person as the same user, giving them all the same permissions. In addition, any username in the database works as an alias.
Aliases are used when different users are considered as dbo roles.
Domain: In WinNT security, a domain is a set of computers that share a common security database, grouped for administrative purposes and investigations.
Group: In SQL Server, a database group is a set of database users. Users have database permissions approved for the group. Using groups simplifies managing large numbers of users; because groups allow you to grants and decline permissions to more than one user at a time.
In WinNT, a group is a set of WinNT users. Users have all permission and WinNT rights approved for the group. Group allow the ability of a large number of users to be managed.
SQL Server Compatibility With Microsoft BackOffice
Back Office is a server application group used to create business solutions. SQL Server is well aligned with Microsoft backoffice products. Back Office applications running with SQL Server are defined as:
Microsoft Internet Information Server: Allows internet clients to access the data in SQL Server.
Microsoft Exchange Server: It can send e-mail messages using SQL Server or MAPI (messaging Application Programming Interface).
Microsoft SNA Server: PC-based networks connect to IBM environment by running the SNA protocols. Using SNA Server, we can make SQL Server compatible with IBM mainframe or AS400 applications and data.
Microsoft Systems Management Server: Uses SQL Server to store its own databases and manages computer software and hardware.
SQL Server Services: All SQL Server services run as devices on Win NT or as applications on Win 95 and other operating systems. SQL Server Services include MSSQL Server, SQL Server Agent and Microsoft Distributed Transaction Coordinator (MS DTC).
MSSQL Server Service: Relational database management system. It processes the Transact-SQL statements and manages files from the database on the server.
These services allocate computer resources according to random multi-users.
Prevents logical problems. (Like asking time against users who want to update the same data at the same time)
Ensures data compliance and consistency.
SQL Server Tool Service: A service that runs in conjunction with SQL Server to create and manage local or multi-server jobs, alerts and operators.
Microsoft Distributed Transaction Coordinator Service: This is a transaction manager. Allows clients that contain different data sources in a transaction. It also a component of Microsoft Transaction Server.
SQL Server Client Software: SQL Server includes a variety of client software to create and design the database, query the data, manage the server and seek help on specific issues.
SQL Server: a client/server is a relational database management system that uses Transact-SQL to communicate between client and SQL Server.
Client/Server Architecture
SQL Server uses the client/server architecture to separate the work environment into jobs running on client and server computer.
Client runs on one or more client computers but it also works with SQL Server on server computers.
SQL Server manages databases and splits the appropriate server resources as requests increase.
Client/Server architecture allows us to organize applications for various environments. The client programming interface allows you to run applications on different client computers and transmit them to the server via then network.
Relational Database Management System
The relational database system is responsible for:
Provide a relationship between the data in the database.
Ensure that data is stored according to rules that dont break relationship between data.
Retrieving all data in case of failed system events.
Transact SQL
SQL is a set of commands that allow you to explicitly specify information that is requested to be corrected and changed. With Transact-SQL, you can access, update and manage data and queries as well as the relational database system. Supports the latest ANSI SQL standart. ANSI is called SQL-92.
SQL Server Platform
Several or more operating system platforms can be used to create and run applications. This platforms can be used as client such as MS-DOS, Windows 3.x, Windows NT, Windows 9.x, Third Party (Like Unix and Apple Macintosh), Internet Browser; this platforms can be used as server such as Windows NT, Windows 9.x.
Compatibility of SQL Server with Windows NT
SQL Server is fully compatible with Windows NT and it has many advantages.
Security: SQL Server is compatible with the security system in Win NT. This compatibility allows a single username and password to access both SQL Server and Win NT. SQL provides its own security for those who arent Microsoft Client (Banyan, VINES, Apple Talk, Novell). SQL Server also uses Win NTs encryption for network security.
Multi-Processor Support: SQL Server automatically has the advantages of extra processors added to the server computer. SQL Server supports the symmetric multiprocessing (SMP) capabilities of WinNT.
Microsoft Event Viewer: SQL Server sends messages to WinNT applications, security and system event logs, providing a convenient mechanism for viewing and monitoring problems.
Windows NT Services: SQL Server runs as a service on WinNT and allows SQL Server to start and stop.
Windows NT Performance Control: It sends performance metrics to the WinNT performance control that allow SQL Server to manage system performance.
Alias: This is the database username shared by different login IDs. Database alias allows you to handle more than one person as the same user, giving them all the same permissions. In addition, any username in the database works as an alias.
Aliases are used when different users are considered as dbo roles.
Domain: In WinNT security, a domain is a set of computers that share a common security database, grouped for administrative purposes and investigations.
Group: In SQL Server, a database group is a set of database users. Users have database permissions approved for the group. Using groups simplifies managing large numbers of users; because groups allow you to grants and decline permissions to more than one user at a time.
In WinNT, a group is a set of WinNT users. Users have all permission and WinNT rights approved for the group. Group allow the ability of a large number of users to be managed.
SQL Server Compatibility With Microsoft BackOffice
Back Office is a server application group used to create business solutions. SQL Server is well aligned with Microsoft backoffice products. Back Office applications running with SQL Server are defined as:
Microsoft Internet Information Server: Allows internet clients to access the data in SQL Server.
Microsoft Exchange Server: It can send e-mail messages using SQL Server or MAPI (messaging Application Programming Interface).
Microsoft SNA Server: PC-based networks connect to IBM environment by running the SNA protocols. Using SNA Server, we can make SQL Server compatible with IBM mainframe or AS400 applications and data.
Microsoft Systems Management Server: Uses SQL Server to store its own databases and manages computer software and hardware.
SQL Server Services: All SQL Server services run as devices on Win NT or as applications on Win 95 and other operating systems. SQL Server Services include MSSQL Server, SQL Server Agent and Microsoft Distributed Transaction Coordinator (MS DTC).
MSSQL Server Service: Relational database management system. It processes the Transact-SQL statements and manages files from the database on the server.
These services allocate computer resources according to random multi-users.
Prevents logical problems. (Like asking time against users who want to update the same data at the same time)
Ensures data compliance and consistency.
SQL Server Tool Service: A service that runs in conjunction with SQL Server to create and manage local or multi-server jobs, alerts and operators.
Microsoft Distributed Transaction Coordinator Service: This is a transaction manager. Allows clients that contain different data sources in a transaction. It also a component of Microsoft Transaction Server.
SQL Server Client Software: SQL Server includes a variety of client software to create and design the database, query the data, manage the server and seek help on specific issues.
Source: https://www.turkhackteam.org/server-guvenlik/135186-sql-server-genis-anlatim.html
Translator: Provido
Translator: Provido
Moderatör tarafında düzenlendi:
