Search

SQL Server - Server Editions Highlights

I have found a document posted by Margaret Rouse very interesting about SQL Server. https://www.techtarget.com/contributor/Margaret-Rouse thanks for your contribution with my constant learning, my brain is a "machine learning" thanks of your articles.


Inside SQL Server's architecture — How SQL Server works           

Like other RDBMS technologies, SQL Server is primarily built around a row-based table structure that connects related data elements in different tables to one another, avoiding the need to redundantly store data in multiple places within a database. The relational model also provides referential integrity and other integrity constraints to maintain data accuracy. Those checks are part of a broader adherence to the principles of atomicity, consistency, isolation and durability, collectively known as the ACID properties, and are designed to guarantee that database transactions are processed reliably.


SQL Server Editions


Microsoft offers SQL Server in four primary editions that provide different levels of the bundled services. Two are available free of charge: a full-featured Developer edition for use in database development and testing, and an Express edition that can be used to run small databases with up to 10 GB of disk storage capacity. For larger applications, Microsoft sells an Enterprise edition that includes all of SQL Server's features, as well as a Standard one with a partial feature set and limits on the number of processor cores and memory sizes that users can configure in their database servers.


Versions of SQL Server

Between 1995 and 2016, Microsoft released ten versions of SQL Server. Early versions were aimed primarily at departmental and workgroup applications, but Microsoft expanded SQL Server's capabilities in subsequent ones, turning it into an enterprise-class relational DBMS that could compete with Oracle Database, DB2 and other rival platforms for high-end database use. Over the years, Microsoft has also incorporated various data management and data analytics tools into SQL Server, as well as functionality to support new technologies that emerged, including the web, cloud computing and mobile devices.


SQL Server 2012:

Prior versions included SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2, which was considered a major release despite the follow-up sound of its name. Next to come were SQL Server 2012 and SQL Server 2014. SQL Server 2012 offered new features, such as columnstore indexes, which can be used to store data in a column-based format for data warehousing and analytics applications, and AlwaysOn Availability Groups, high availability and disaster recovery technology. (Microsoft changed the spelling of the latter's name to Always On when it released SQL Server 2016.)


SQL Server 2014:

SQL Server 2014 added In-Memory OLTP, which lets users run online transaction processing (OLTP) applications against data stored in memory-optimized tables instead of standard disk-based ones. Another new feature in SQL Server 2014 was the buffer pool extension, which integrates SQL Server's buffer pool memory cache with a solid-state drive -- another feature designed to boost I/O throughput by offloading data from conventional hard disks.


Microsoft SQL Server 2016:

Microsoft SQL Server 2016, which became generally available in June 2016, was developed as part of a "mobile-first, cloud-first" technology strategy adopted by Microsoft two years earlier. Among other things, SQL Server 2016 added new features for performance tuning, real-time operational analytics, and data visualization and reporting on mobile devices, plus hybrid cloud support that lets DBAs run databases on a combination of on-premises systems and public cloud services to reduce IT costs. For example, a SQL Server Stretch Database technology moves infrequently accessed data from on-premises storage devices to the Microsoft Azure cloud, while keeping the data available for querying, if needed.


SQL Server 2016 also increased support for big data analytics and other advanced analytics applications through SQL Server R Services, which enables the DBMS to run analytics applications written in the open-source R programming language, and PolyBase, a technology that lets SQL Server users access data stored in Hadoop clusters or Azure blob storage for analysis. Also, SQL Server 2016 was the first version of the DBMS to run exclusively on 64-bit servers based on x64 microprocessors. And it added the ability to run SQL Server in Docker containers, a virtualization technology that isolates applications from each other on a shared operating system.


SQL Server 2017:

Microsoft SQL Server ran exclusively on Windows for more than 20 years. But, in 2016, Microsoft said it planned to also make the DBMS available on Linux, starting with a new version released as a community technology preview that November and initially dubbed SQL Server vNext; later, the update was formally named SQL Server 2017, and it became generally available in October of that year.

The support for running SQL Server on Linux moved the database platform onto an open-source operating system commonly found in enterprises, giving Microsoft potential inroads with customers that don't use Windows or have mixed server environments. SQL Server 2017 also expanded the Docker support added for Windows systems in the previous release to include Linux-based containers.


Another notable feature in SQL Server 2017 is support for the Python programming language, an open-source language that is widely used in analytics applications. With its addition, SQL Server R Services was renamed Machine Learning Services (In-Database) and expanded to run both R and Python applications. Initially, the machine learning toolkit and a variety of other features are only available in the Windows version of the database software, with a more limited feature set supported on Linux.


SQL Server 2019:

SQL Server 2019 is slated to release in late 2019; however, a preview is available for download. SQL Server 2019 CTP 3.0 is currently the latest public version available for preview— only as an Evaluation Edition. SQL Server 2019 was shown in September 2018, introducing new features and tweaks focusing on performance, security and increasing work volume data. SQL Server 2019 allows users to join SQL Server, HDFS, and Spark containers together using a new Big Data Cluster feature. SQL Server 2019 also introduces column store index builds, rebuilds and static data masking. Accelerated Data Recovery is also new, which performs and undoes a redo phase in the oldest page log sequence number. As an example, this is done in the case scenario where the user closes an application which was running for an extended period of time, so the user does not have to wait long for the application to close.

Always On Availability Groups, available in SQL Server 2012, has been changed to simplify the administration of availability groups. This adds support to MSDB and Master system databases. Other changes to features include the expansion to operations users can perform with Always Encrypted data; additional Polybase connectors for SQL Server, Oracle, MongoDB and Teradata; additional persistent memory options for storage; and improvements on Query Processing.


1 view0 comments