Geek Slack

  • September 18, 2024
  • 8:23 PM
Facebook Linkedin
Course Content
SQL Server
0/43
Introduction to SQL Server
00:00
License, features, options available in SQL Server
00:00
MS SQL Server as Client-Server Architecture
00:00
SQL Syntax
00:00
SQL SELECT
00:00
SQL SELECT DISTINCT
00:00
SQL WHERE
00:00
SQL ORDER BY
00:00
SQL AND
00:00
SQL OR
00:00
SQL NOT
00:00
SQL INSERT INTO
00:00
SQL NULL Values
00:00
SQL UPDATE
00:00
SQL DELETE
00:00
SQL TOP
00:00
SQL Aggregate Functions
00:00
SQL MIN and MAX
00:00
SQL COUNT
00:00
SQL SUM
00:00
SQL AVG
00:00
SQL LIKE
00:00
SQL Wildcards
00:00
SQL IN
00:00
SQL BETWEEN
00:00
SQL Aliases
00:00
SQL Joins
00:00
SQL INNER JOIN
00:00
SQL LEFT JOIN
00:00
SQL RIGHT JOIN
00:00
SQL FULL OUTER JOIN
00:00
SQL Self Join
00:00
SQL UNION
00:00
SQL GROUP BY
00:00
SQL HAVING
00:00
SQL EXISTS
00:00
SQL ANY, ALL
00:00
SQL SELECT INTO
00:00
SQL INSERT INTO SELECT
00:00
SQL CASE
00:00
SQL NULL
00:00
SQL Stored Procedures
00:00
SQL Comments
00:00
Getting Started with SQL Server
About Lesson

 

Deployment Options, Licensing, and Features in SQL Server

 

SQL Server  continues to offer similar deployment, edition, and licensing options as previous versions, with some key differences that will be covered here.

Deployment Options for SQL Server 

SQL Server  can be deployed on Windows and Linux operating systems, on computers, virtual machines, and cloud platforms. It also supports deployment using containers and Kubernetes platforms.

Supported operating systems include Windows 10, Windows 11, and various versions of Windows Server. For Linux, it supports Red Hat Enterprise Linux 8.0 – 8.5, SUSE Enterprise Linux Server v15, and Ubuntu 20.04 LTS.

Deployment methods include the Windows graphical setup wizard, command line options, Linux package managers, and container runtime engines like Docker. SQL Server is also available via Azure Virtual Machine marketplace images.

Editions for SQL Server 

SQL Server 2022 is available in several editions:

  • Evaluation: Full feature access for 180 days, non-production use.
  • Developer: Full feature access for testing and development, non-production use.
  • Express: Free for production with limitations on CPU, memory, and database size.
  • Web: Cost-effective for web hosting with scalability and manageability features.
  • Standard: Most core features with some resource limitations.
  • Enterprise: Full feature set with no resource limitations.

For detailed information, refer to the SQL Server editions documentation.

Licensing for SQL Server

Paid editions of SQL Server are licensed per instance using models like per core, or via Software Assurance agreements. A new “Pay-as-you-go” model is also available. More details can be found on the SQL Server licensing page.

Feature Differences in SQL Server

This section will cover new features and capabilities in SQL Server 2022 compared to previous releases:

  • Cloud connectivity
  • Built-in query intelligence
  • Core engine enhancements
  • Data virtualization
  • T-SQL language enhancements

Details on deprecated and removed features are also included.

Features Removed or Deprecated in SQL Server

Several features from previous versions have been removed or deprecated:

  • R, Python, and Java runtimes: No longer included in the setup; external packages required.
  • Polybase Hadoop Connectivity: Removed; use ODBC drivers or new REST API connectors instead.
  • Polybase Scale Out Groups: Removed; rely on scale-up processing.
  • Machine Learning Server: Retired; not included in the setup.
  • Distributed Replay: No longer available in the setup.
  • Stretch Database: Deprecated; avoid using in new development and plan to replace it.

New Deployment Experiences in SQL Server 

SQL Server includes the Azure extension for SQL Server configuration during setup, allowing configuration as an Azure Arc-enabled SQL Server without subscription charges unless specific Azure services are used.

Join the conversation
Previous
Next