Tech ! Reviews

What is MS SQL Server?

Well!

before get started to know about SQL Server, I would like to brief you on the meaning of SQL. So, guys, it stands for Structured Query Language. The original version is called SEQUEL and abbreviation of it's it Structured English Query Language. SEQUEL was designed by an IBM research center in 1974 and 1975 that's why copyright is under IBM of SQL/SEQUEL.

It is primarily developed to complete with MySQL and Oracle databases. Now SQL is a domain-specific language that is used in programming and managing data in RDBMS. Now I will explain about MS SQL Server. MS stands for Microsoft. So MSSQL Server is a relational database management system (RDBMS) that was developed and marketed by Microsoft.

(adsbygoogle = window.adsbygoogle || []).push();

Similar to other RDBMS software, MSSQL Server supports ANSI SQL, which is the standard Query language and built on top of a standard programming language for interacting with the Relational databases.

However, MSSQL Server comes with its self implementation of Structured Query Language called T-SQL or Transact-SQL.

MSSQL Server worked exclusively on the Windows platform before the version released MSSQL Server 2017. In the version of MSSQL Server 2017, Microsoft included Linux platform also along with the Windows, from here it has competed with Oracle and its more demanding software and 카지노사이트쿠폰 created more employability in the market.

T-SQL which is generally known as Transact-SQL is the propriety of Microsoft. It provides capabilities of declaring variables, 우리카지노계열쿠폰 exception handling, user-defined functions, and stored procedures, etc. Microsoft SQL Server availed a UI (User Interface) is called SQL Server Management Studio (SSMS) which is the main interface tool of MS SQL Server and supports the system of 32-bit as well as 64-bit too.

History of SQL Server

Between the partnership of Microsoft and Sybase worked together and released SQLServer version 1.0 in 1989 but the partnership between both has ended in the year 1990. Microsoft carried forward its ownership rights to the name SQLServer and since 1990 all versions of SQLServer have been released including 2000, 2005, 2008, 2012, 2014, 2016 and 2017, etc.

Since 1990 SQLServer known as MSSQL Server.

Editions of SQL Server

There are mainly 5 editions available in Microsoft SQLServer as mentioned below –

Web Edition: Web edition is an option for web hosters and VAPs because it is suitable for low cost of ownership for web hosters.

Web hosters can centrally manage their business infrastructure with its SQL Server Management Studio and management packs. It provides the scalable, affordable, and manageable capability for small to large scale web properties. It provides support for Windows PowerShell to automate various management tasks.

Standard Edition: Standard edition offers a basic database, reporting, and analytics capabilities. It is designed for mid-tier applications and data marts. Microsoft offers standard edition under the server/CAL and core-based license model.

Express Edition: Express edition is free to download, distribute and use. It is especially for smaller-scale applications. Express edition as a brand has been used since the release of SQLServer 2005.

Enterprise Edition: Enterprise edition is used for large scale, high end, and critical business.

It contains all the basic features of the standard edition and more tools for analyzing business, financial data, mission-critical applications, and data warehousing features. It provides high-level security, advanced analytics, and machine learning, etc. Microsoft offers this edition only under the core-based license model.

Developer Edition: Developer edition is similar to an enterprise edition for 카지노사이트추천 all the non-production environments. Its mainly used to build test and demo purposes. Express edition is for small scale applications and free to use.

Licensing

As a small keyword is used like core-based licensing and server/CAL licensing in Standard edition definition, which I would like to describe here for better understanding –

The Core Based Licensing product offers to provide license for two cores.

SQL Server requires a core-based licensing for a minimum of four core licenses to work, to use these products, the user will need to have enough copy to cover the core in the processors as he/she plan to use with SQL.

The Server/CALL Licensing product offers to provide a single server license for physical, virtual, or cloud-based server.

SQL with server/CALL licensing requires each user or any device that accesses the licensed server to have a client access license (CAL). It is most appropriate for the administrators who know the exact number of users and devices that will connect to the server.

Components and Services of SQL

(A) Database Engine

Database Engine: Database Engine is the core component of the SQL.

The database engine component handles data storage, rapid transaction processing, and securing data into SQL. The database engine is an engine that processes storage engine and queries that handle database objects like indexes, stored procedures, views, files, pages, and triggers are also created and executed by the database engine.

as an RDBMS database engine falls into two categories 1. Relational Engine 2. Storage Engine

Relational Engine: Relational Engine is known as a query processor which contains the components that determine the best way to execute a query. The relational engine requests from the storage engine for data based on the input query by the use to publish the result.

Storage Engine: The storage engine takes charge of storage and retrieval data from the storage system like disks and scan.

SQLOS: SQLServer Operating System SQLOS comes under the relational engine and storage engine.

SQLOS provides many operating system services such as memory and I/O (Input/Output) management, other services include exception handling and synchronization services.

(B) SQL Services

Services: Microsoft provides data management and business intelligence (BI) tools and services together with SQL Server.

Server: SQL service in Microsoft SQL helps to start, pause, stop, and continues an instance. The executable name of SQL is sqlservr.exe.

Agent: SQL Agent performs the role of task scheduler which can be triggered by any event or as per user's demand.

SQL Agent's executable name is sqlagent.exe.

Browser: SQL browser listens to the incoming requests and connects to the desired Server instance. SQL browser's executable name is sqlbrowser.exe.

Full-Text Search: SQL full-text search lets users running full-text queries against character data in the SQL table, its executable name is fdlauncher.exe.

VSS Writer: It allows the user to take a backup and restore of data files when the SQL is not running. Its executable name is sqlwrite.exe.

Analysis Services (SSAS): It provides data analysis, data mining, and machine learning capabilities.

Now SQL is integrated with R and Python language for advanced analysis. Its executable name is msmdsrv.exe.

Reporting Services (SSRS): SSRS provides reporting templates along with the reporting features and decision-making capability to display the desired data into a specific reporting format.

It includes integration with Hadoop. Its executable name is ReportingServicesService.exe.

Integration Services (SSIS): Its provide extract transform and load capabilities of the different type of data from one source to another. Its executable name is MsDtsSrvr.exe.

(C) SQL Instance

Instance: Microsoft SQL allows users to run multiple services in one place with each service having separate logins, ports, and databases. Instances fall into two categories as mentioned below –

  • Primary Instances
  • Named Instances

Primary Instance: There are two ways through which the user may access the primary instance –

  • User can use the server name
  • User can use its IP Address

Named Instance: Named instance can be accessed by appending a backslash() and then instance name.

for example, I want to connect an instance “abc” on my local server, then I should use instance name as “192:20:20:292abc” since SQL Server 2005 and above. We can run up to 50 instances simultaneously on an existing server.

Note: In the same server user can have multiple instances up to 50 named instances and only one of them must be the default instance because we can run all the instances concurrently using default instance and each one instance can run independently of the other instances.

Advantages of Server Instances

Advantage of Server Instances are mentioned below –

We can have different versions of Server on a single machine or server, each installation works independently from other installations.

Instances can help us to reduce the costs of operating servers, especially in purchasing the Server license, we can get different services from the different instance that's why no need to purchase one license for all services.

We can use different instances for development, production, 카지노사이트 and test purposes which is the main benefit of having many instances on a single machine.

If we have all services running on a single Server Instance then there are high chances of having issues especially issues that keep on recurring but in case such services are running on different instances then we can avoid having such issues.

We can focus on securing the instance running the most sensitive service if different services are running on different Server instances.

Raghawendra Shukla Photo Raghawendra Shukla (Database & Application Expert) Raghawendra has been a part of the industry more than 10 years and qualification is MCA.

During his career, he has worked in various Technology platforms like Excel, Access, SQL Server, VB 6.0 as well as MySQL, PostgreSQL, WP and SurveyCTO. To read more article from SQLPOST, please <a website here.

One Comment

Leave a Reply