What is MS SQL Server?

What is SQL Server?

1. Software developed by Microsoft based on RDBMS.
2. Also an ORDBMS (Object Relational Database Management System).
3. An independent platform.
4. The software uses both command line interface and GUI interface.
5. SQL language support (formerly SEQUEL - structured English query language) - which is IBM's product.

Purpose of using SQL Server

1. Create database.
2. Maintain the database.
3. Data Analysis by SSAS - SQL Server Analysis Services.
4. Create report by SSRS - SQL Server Reporting Services.
5. Perform ETL (Extract-Transform-Load) process with SSIS - SQL Server Integration Services.

SQL Server versions

Version of Code Name Release Date 6.0 1995 SQL95 6.5 1996 Hydra 7.0 1998 Sphinx 8.0 (2000) 2000 Shiloh 9.0 (2005) 2005 Yukon 10.0 (2008) 2008 Katmai 10.5 (2008 R2) 2010 Kilimanjaro 11.0 (2012) 2012 Denali 12 (2014 ) 2014 Hekaton (original name), SQL 14 (current name)

Components of SQL Server

SQL Server operates on a client-server model, so there are two components: Workstation and Server.

1. Workstation is installed on any device or on the device of the server operator. These are software interfaces to interact with the Server, such as SSMS, SSCM, Profiler, BIDS or SQLEM .
2. Server is installed on centralized server. These are services such as SQL Server, SQL Server Agent, SSIS, SSAS, SSRS, SQL Browser, SQL Full Text Search .

Instance of SQL Server

1. Is a SQL Server installation.
2. An exact copy of the software.
3. If you install 'n' times, it will create an 'n' installation.
4. There are two types of SQL Server installations: Default - Named - Named.
5. Only one default installation is supported on one Server.
6. Many new installations are supported on a Server.
7. The default installation will take the server name as an Instance name.
8. The name of the default installation is MSSQLSERVER.
9. SQL Server 2000 version supports 16 installations.
10. SQL Server 2005 and later version supports 50 installations.

Benefits of installations

1. Install various MS SQL versions on the same machine.
2. Cut down the costs.
3. Maintain separate production, development and testing environments.
4. Minimize temporary problems on the database.
5. Separate security privileges.
6. Maintain backup server.

Previous article: Introducing MS SQL Server

Next article: Versions of MS SQL Server