High Performance Sql Server On Linux- RHEL-Ubuntu – Red Hat – Deploy on Any Cloud- GCP, AWS or Azure

1-click AWS Deployment    1-click Azure Deployment

Overview

Features

Major Features of SQL Server :

  • New storage features—Column-store indexes, File-table storage.
  • New Transact-SQL (T-SQL) constructs—Sequence objects, THROW statement, new conversion, logical, string, and date and time functions, and adhoc query paging.
  • New scalability and performance features—Indirect checkpoints, FORCESCAN table hint, number of table partitions increased to 15,000.
  • New security features—Database Audit, user-defined server roles, contained databases.
  • New availability features—A number of high-availability enhancements known as AlwaysOn, which include AlwaysOn Availability Groups and AlwaysOn Failover Cluster Instances.
  • Statistical Semantic Search—Statistical Semantic Search builds upon the existing full-text search feature in SQL Server by querying the contextual meaning of terms within a document repository.
  • Data Quality Services—This new feature allows you to build a knowledge base of data rules and use those to perform a variety of critical data quality tasks, including correction, enrichment, standardization, and de-duplication of your data.

 

AWS

Installation Instructions for Ubuntu

 

1.Default installation path: will be on your root folder “C:\Program Files\SQLServer”
2.Default ports:

  • Linux Machines:  SSH Port – 22
  • Http: 80
  • Https: 443

Configure custom inbound and outbound rules using this link

 

Installation Instructions for Ubuntu

1.Default installation path: will be on your root folder “C:\Program Files\SQLServer”
2.Default ports:

  • Linux Machines:  SSH Port – 22
  • Http: 80
  • Https: 443

Configure custom inbound and outbound rules using this link

Azure

Installation Instructions for Ubuntu

 

1.Default installation path: will be on your root folder “C:\Program Files\SQLServer”
2.Default ports:

  • Windows Machines:  RDP Port – 3389
  • Http: 80
  • Https: 443

Configure custom inbound and outbound rules using this link

 

 

 

 

 

 

 

Videos

 

High Performance Sql Server On Linux- RHEL-Ubuntu – Red Hat – Deploy on Any Cloud- GCP, AWS or Azure