HomeProgramSQL Server

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

4.5 ★ | 2 Vote
What is MS SQL ServerSQL Serverdatabase administratorlearn SQL Servermssql

You should read it

May be interested

  • What is the future of server virtualization?What is the future of server virtualization?
    server virtualization can help combat poor server performance, make better use of computing capabilities, limit energy consumption and improve data center flexibility.
  • Learn about the architecture of MS SQL ServerLearn about the architecture of MS SQL Server
    in the previous articles, you already know briefly about sql server, how to install sql server on the computer. in this section we will learn about the architecture of sql server.
  • Instructions for installing MS SQL ServerInstructions for installing MS SQL Server
    this is a step by step guide to installing ms sql server.
  • How to install DNS Server on Windows Server 2019How to install DNS Server on Windows Server 2019
    from microsoft, the domain name system (dns) is one of the industry standard protocol sets that includes tcp / ip, along with dns client and dns server that provide name resolution services that map names to the ip addresses of computers. .
  • Install Windows Server 2003 and create a backup serverInstall Windows Server 2003 and create a backup server
    network management documentation server 2003 as details of how to install, create a companion server in case the main server is malfunctioning, create a domain, join the client to the domain, the conection {remote desktop from the client data to server}, set adsl router parameters to server, turn off 1 working machine immediately.
  • Instructions to change DNS Server on Windows, Mac, iOS and AndroidInstructions to change DNS Server on Windows, Mac, iOS and Android
    by default, your computer will automatically obtain dns information from your isp (isp). sometimes, dns servers are unstable and you are blocked from accessing certain websites. or the default dns server is blocked by some websites for a number of reasons. in this case you should change the dns server with the free public dns server.
  • How to configure DNS Server on Ubuntu Server 11.04How to configure DNS Server on Ubuntu Server 11.04
    dns server is a server with domain name resolution function. in this article, we will detail the steps to install and configure dns server on linux with ubuntu server version 11.04.
  • Instructions for setting up individual FTP Server with FileZillaInstructions for setting up individual FTP Server with FileZilla
    unlike http - designed to forward hyper - text data over tcp connections, standard ftp ensures that the server responds to requests as soon as it receives a signal from the host. not only provides fast and accurate file transfer, but also security, gives users more options in the process of downloading and uploading data ...
  • HAVING clause in SQL ServerHAVING clause in SQL Server
    the having clause is used in conjunction with the group by clause in sql server (transact-sql) to limit the group of returned rows, only when the condition is met is true.
  • What is a RADIUS Server? How does RADIUS Server work?What is a RADIUS Server? How does RADIUS Server work?
    radius server is a background process that runs on unix or windows servers. it allows you to maintain user profiles in the central database.