SQL Server IoT

SQL Server IoT is a relational database management system built for secure, fixed-function solutions. You get the reliability of SQL Server, optimized to manage large volumes of data, execute complex queries efficiently, and integrate with your applications and cloud services.

Apache Spark

Process big data queries faster and improve the speed of machine learning with the unified analytics engine, Apache Spark, built directly into SQL Server IoT.

Azure-enabled Features

Drive deeper insights, predictions, and governance from your data at scale with Azure services like Synapse Link, Microsoft Purview, and more.

Advanced Security

Protect sensitive data with built-in safeguards like Always Encrypted, row-level security, and dynamic data masking so your applications stay secure and compliant.

SQL Server IoT is a mission-critical, industry-leading database for fixed-purpose devices. Gain insights from all your data, structured and unstructured.

Server + CAL

Each server license allows customers to run any number of SQL Server instances in a single OSE, either physical or virtual.

Best for things like:

When you have a small team of users but many devices
If your organization primarily uses devices (e.g., kiosks, terminals, IoT devices) to access the SQL Server
Data warehousing

More about Server + CAL {link to SQL Licensing Models blog}

Core-Based

Best for things like:

When the number of users/devices cannot be counted easily
Deploying intranet or extranet workloads
Implementing centralized deployments spanning large direct and/or indirect users/devices