Windows SQL Server 2016

Works on: PC License type: Lifetime Devices: 1 Find rich programming capabilities, security innovations, and fast performance for mid-tier applications and data marts. Easily upgrade to the Enterprise edition without having to change any code. SQL Server Standard edition delivers basic data management and business intelligence database for departments and small organizations to run their applications and supports common development tools for on-premise and cloud — enabling effective database management with minimal IT resources. The benefits of new capabilities built-in to Standard Edition include: Most secure Database: Dramatically bolster security with always encrypted technology leveraging row-level security and dynamic data masking. #1/price to performance: ]Get faster performance and better insights with in-memory OLTP and operational and in-database analytics, all at the cost of standard edition Cost effective hybrid database: Leverage the cloud with stretch database capabilities, cloud back-up encryption support, larger SQL Server VMs and memory Predictive capabilities: Start doing predictive modelling with basic R Services integration and connectivity to R Open Business Intelligence: Create and share better insights by creating enhanced multidimensional models and pinning reports to power BI Minimum Required .NET Framework: SQL Server 2016 RC1 and later require .NET Framework 4.6 for the Database Engine, Master Data Services, or Replication. SQL Server 2016 setup automatically installs .NET Framework. You can also manually install .NET Framework from Microsoft .NET Framework 4.6 (Web Installer) for Windows. Windows 8.1, and Windows Server 2012 R2 require KB2919355 before installing .NET Framework 4.6. Network Software: Supported operating systems for SQL Server have built-in network software. Named and default instances of a stand-alone installation support the following network protocols: Shared memory, Named Pipes, TCP/IP and VIA. Note: Shared memory and VIA are not supported on failover clusters. Also note that the VIA protocol is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Hard Disk: SQL Server requires a minimum of 6 GB of available hard-disk space. Disk space requirements will vary with the SQL Server components you install. Drive: A DVD drive, as appropriate, is required for installation from disc. Monitor: SQL Server requires Super-VGA (800x600) or higher resolution monitor. Internet: Internet functionality requires Internet access (fees may apply). Note: Running SQL Server on a virtual machine will be slower than running natively because of the overhead of virtualization. The following memory and processor requirements apply to all editions of SQL Server: Memory : Minimum: Express Editions: 512 MB All other editions: 1 GB Recommended: Express Editions: 1 GB All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance. Processor Speed: Minimum: x64 Processor: 1.4 GHz Recommended: 2.0 GHz or faster Processor Type: x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Note Installation of SQL Server is supported on x64 processors only. It is no longer supported on x86 processors. * The minimum memory required for installing the Data Quality Server component in Data Quality Services (DQS) is 2 GB of RAM, which is different from the SQL Server minimum memory requirement.

Works on: PC License type: Lifetime Devices: 1 Build intelligent, mission-critical applications using a scalable, hybrid database platform that has everything built in—from in-memory performance and advanced security to in-database analytics. The premium offering, SQL Server Enterprise edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance, unlimited virtualization, and end-to-end business intelligence — enabling high service levels for mission-critical workloads and end user access to data insights. High availability and disaster recovery Real-time hybrid transactional/analytical processing Security and compliance #1 in price and performance—with massive scale Highest performing data warehouses Corporate business intelligence End-to-end mobile BI on any device Simplify big data In-database advanced analytics Cut storage costs with SQL Server Stretch Database Consistent data platform from on-premises to cloud Easy-to-use tools Minimum Required .NET Framework: SQL Server 2016 RC1 and later require .NET Framework 4.6 for the Database Engine, Master Data Services, or Replication. SQL Server 2016 setup automatically installs .NET Framework. You can also manually install .NET Framework from Microsoft .NET Framework 4.6 (Web Installer) for Windows. Windows 8.1, and Windows Server 2012 R2 require KB2919355 before installing .NET Framework 4.6. Network Software: Supported operating systems for SQL Server have built-in network software. Named and default instances of a stand-alone installation support the following network protocols: Shared memory, Named Pipes, TCP/IP and VIA. Note: Shared memory and VIA are not supported on failover clusters. Also note that the VIA protocol is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Hard Disk: SQL Server requires a minimum of 6 GB of available hard-disk space. Disk space requirements will vary with the SQL Server components you install. Drive: A DVD drive, as appropriate, is required for installation from disc. Monitor: SQL Server requires Super-VGA (800x600) or higher resolution monitor. Internet: Internet functionality requires Internet access (fees may apply). Note: Running SQL Server on a virtual machine will be slower than running natively because of the overhead of virtualization. The following memory and processor requirements apply to all editions of SQL Server: Memory : Minimum: Express Editions: 512 MB All other editions: 1 GB Recommended: Express Editions: 1 GB All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance. Processor Speed: Minimum: x64 Processor: 1.4 GHz Recommended: 2.0 GHz or faster Processor Type: x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Note Installation of SQL Server is supported on x64 processors only. It is no longer supported on x86 processors. * The minimum memory required for installing the Data Quality Server component in Data Quality Services (DQS) is 2 GB of RAM, which is different from the SQL Server minimum memory requirement.