Microsoft SQL Server Editions and History

Hi,

In this article I will tell you the Microsoft SQL Server database management system history and editions.

Microsoft has seen Kingdom of Oracle in the database management system market and Decided to produce new Database. Microsoft has purchased Sybase  in 1989 and thus SQL Server 1.0 has been released for the first time in 1989. Microsoft SQL Server 1.0, which is essentially the same as Sybase SQL Server 3.0, started to compete with Oracle with SQL Server 2008 version. Microsoft has changed all database engine with SQL Server 2005.

 

SQL Server is a relational database management system if we say it in the most basic sense. With SQL Server, you can handle very large amounts of data and store them securely. You can analyze stored data. In addition, requests from Client with SQL Server are met within a short time.

With SQL Server, OLTP (Online Transaction Processing) databases and OLAP (Online Analytical Processing) databases can be administered. While OLTP-type databases are a type of database that records all operations on a Production system, OLAP databases are larger than the OLTP databases, and are typically used to perform Analysis and reporting.

There are different editions of SQL Server developed for different purposes and situations. These are as follows.

  1. SQL Server Enterprise Editon : It is a version that includes all components and features for the Enterprise companies ( Banks, Insurance, hospital, Universities )
  2. SQL Server Standart Editon : It is a product developed for medium and small businesses.
  3. SQL Server Workgroup Edition — Expired
  4. SQL Server Personal Editon — Expired
  5. SQL Server Developer Editon
  6. SQL Server Express  Edition
  7. SQL Server WEB Edition
  8. SQL Server Desktop Engine — Expired

 

SQL Server was a software that runs on Windows operating system and also on Windows servers.

But SQL Server runs on both Windows Operating system, Windows Server and Linux Server with SQL Server 2017 version.

SQL Server is also available for Linux anymore.

Some of the services that the SQL server uses are as follows.

  • MS SQL Server
  • SQL Server Agent
  • Microsoft Distributed Transaction Coordinator (MS  DTC)

MS SQL Server : It is the core of relational database management system. Execute the SQL and T-SQL statements from the Client and manages them accordingly. It also administer queries and users data at the same time.

 

 

SQL Server Agent : It is a service that serves as the Agent of our database. This service works instead of us,when we create a job that we want to do operations, Agent does instead of us. it is a service that can perform backups, receiving snapshots, sending e-mails, rebuild index etc automatically.

 

Microsoft Distributed Transaction Coordinator (MS  DTC) : It is a service that administer transactions on the database. It is used to administer transactions in different database and architecture.

 

 

Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

2 thoughts on “Microsoft SQL Server Editions and History

  • May 12, 2019 at 8:00 am
    Permalink

    It’s remarkable to pay a quick visit this site and reading the views of all friends on the topic of this article, while I am also eager of getting familiarity.|

    Reply
  • May 12, 2019 at 11:00 am
    Permalink

    Hey There. I found your blog using msn. This is an extremely well written article. I will be sure to bookmark it and come back to read more of your useful information. Thanks for the post. I will certainly return.|

    Reply