Windows SQL Server 2017 Enterprise 32 Core
1.458,09 € * 1.948,51 € * (25,17% gespart)
Inhalt: 1 Stück

inkl. MwSt. zzgl. Versandkosten

Versandkostenfreie Lieferung!

Sofort versandfertig, Lieferzeit ca. 1-3 Werktage

  • ST10041
Produktinformationen "Microsoft SQL Server 2017 Enterprise" Neues in SQL Server... mehr
Produktinformationen "Windows SQL Server 2017 Enterprise 32 Core"
Produktinformationen "Microsoft SQL Server 2017 Enterprise"

Neues in SQL Server 2017

SQL Server 2017 stellt einen wichtigen Schritt dar, um SQL Server zu einer Plattform zu machen, auf der Sie verschiedene Wahlmöglichkeiten haben: Wählen Sie zwischen verschiedenen Entwicklungssprachen und Datentypen, zwischen lokaler Ausführung oder Ausführung in der Cloud sowie zwischen verschiedenen Betriebssystemen, indem die Leistungsfähigkeit von SQL Server für Linux, Linux-basierte Docker-Container und Windows bereitgestellt wird. Im Folgenden werden die Neuerungen für bestimmte Funktionsbereiche zusammengefasst und Links mit zusätzlichen Details zur Verfügung gestellt.

SQL Server 2017-Datenbankmodul

SQL Server-2017 umfasst viele neue Datenbankmodulfunktionen, Verbesserungen und Leistungsverbesserungen. Das Datenbankmodul ist der Kerndienst zum Speichern, Verarbeiten und Sichern von Daten. Das Datenbankmodul ermöglicht einen gesteuerten Zugriff und eine schnelle Transaktionsverarbeitung, um auch den Anforderungen der anspruchsvollsten Datenverarbeitungsanwendungen in Ihrem Unternehmen gerecht zu werden.

Verwenden Sie das Datenbankmodul, um relationale Datenbanken für OLTP- (Online Transactional Processing, Onlinetransaktionsverarbeitung) oder OLAP-Daten (Online Analytical Processing, Analytische Onlineverarbeitung) zu erstellen. Dazu gehört das Erstellen von Tabellen zur Datenspeicherung und von Datenbankobjekten, wie z. B. Indizes, Sichten und gespeicherten Prozeduren, zum Anzeigen, Verwalten und Sichern von Daten. Verwenden Sie das SQL Server Management Studio, um die Datenbankobjekte zu verwalten, und SQL Server Profiler, um Serverereignisse aufzuzeichnen. 

Machine Learning in SQL Server 2017

Die SQL Server R Services wurden umbenannt in SQL Server-Machine Learning-Dienste, entsprechend der Unterstützung für Python, zusätzlich zur R-Programmiersprache. Sie können Machine Learning-Dienste (datenbankintern) zum Ausführen von R- oder Python-Skripts in SQL Servern verwenden, oder Sie installieren den Microsoft Machine Learning-Server (eigenständig) zum Bereitstellen und Nutzen von R- und Python-Modellen, die keinen SQL Server erfordern.

Entwickler von SQL Servern haben jetzt Zugriff auf die umfangreichen ML- und AI-Bibliotheken für Python, die in der Open-Source-Umgebung zusammen mit den neuesten Innovationen von Microsoft zur Verfügung stehen:

  • revoscalepy: Diese Python-Entsprechung zu RevoScaleR enthält parallele Algorithmen für lineare und logistische Regressionen, Entscheidungsstrukturen, verstärkte Strukturen und zufällige Gesamtstrukturen sowie einen umfangreichen Satz an APIs für die Übertragung und Verschiebung von Daten, Remoterechenkontexten und Datenquellen.
  • microsoftml: Dieses moderne Paket von ML-Algorithmen und -Transformationen mit Python-Bindungen enthält tiefgreifende neuronale Netzwerke, schnelle Entscheidungsstrukturen und Entscheidungsgesamtstrukturen sowie optimierte Algorithmen für lineare und logistische Regressionen. Darüber hinaus erhalten Sie vorgegebene, auf ResNet-Modellen basierende Modelle, die Sie zur Imageextraktion oder Standpunktanalyse verwenden können.
  • Python in Computerkontexten von SQL Servern: Datenanalysten und Entwickler können Python-Code remote aus ihrer Entwicklungsumgebung ausführen, um Daten- und Entwicklungsmodelle auszuprobieren, ohne dabei Daten zu verschieben.
  • Native Bewertung: Die PREDICT-Funktion in Transact-SQL kann in jeder Instanz von SQL Server 2017 zum Durchführen von Bewertungen verwendet werden, auch wenn R nicht installiert ist. Sie müssen nur das Modell mit einem der unterstützten RevoScaleR- und revoscalepy-Algorithmen trainieren und es in einem neuen, kompakten Binärformat speichern.
  • Paketverwaltung: T-SQL unterstützt jetzt die CREATE EXTERNAL LIBRARY-Anweisung, um Datenbankadministratoren bessere Verwaltungsfunktionen für R-Pakete zu bieten. Verwenden Sie Rollen, um den Zugriff auf private oder freigegebene Pakete zu steuern, speichern Sie R-Pakete in der Datenbank, und geben Sie diese für Benutzer frei.

Fortschrittliche In-Database-Analytics

Entwickeln Sie intelligente Anwendungen mit SQL Server Machine Learning Services mit R und Python. Wechseln Sie von reaktiven zu prädiktiven und präskriptiven Analytics, indem Sie Advanced Analytics direkt in der Datenbank ausführen. Mithilfe von Multithreading und Massively Parallel Processing gelangen Sie schneller zu Insights als mit Open Source-R und -Python alleine.

Hochverfügbarkeit und Notfallwiederherstellung

Always On in SQL Server 2017 gewährleistet Hochverfügbarkeit und Notfallwiederherstellung unter Linux und Windows. Dadurch profitieren Sie von weniger Ausfallzeiten, schnellem Failover, einfacher Einrichtung und Lastenausgleich auf lesbaren sekundären Replikaten. Integrieren Sie außerdem zur hybriden Hochverfügbarkeit ein asynchrones Replikat in Azure Virtual Machines.

Microsoft SQL Server 2017 – Enterprise Edition

This is the Retail Core License, allowing you to have a maximum of 32 CPU Cores in your Server or VM.
Core licenses comes with unlimited User CALs.
Language: US-English, license is good worldwide*. 

Brand New, Factory Sealed Box. US English Language.

Releasedate: 09. Oktober 2017

Experience breakthrough performance with SQL Server 2017 features

SQL Server 2017 is the biggest leap forward in Microsoft data platform history with features that increase performance, simplify management, and transform your data into actionable insights—all on a database that has the least vulnerabilities of any major platform.

Some of the new capabilities of SQL Server 2017:

  • Build intelligent, mission-critical applications
  • Break free from Oracle
  • Always Encrypted
  • Real-time operational analytics
  • In-database analytics
  • PolyBase
  • And much much more. Check on the Internet, it has hours of reading about SQL Server 2017.

 

Automatic Tuning: While many database vendors have claimed to have self -tuning databases in the past, Microsoft has built intelligence into a set of self-tuning features in SQL Server 2017. Microsoft has learned a lot from supporting Azure SQL Database and identifying customer performance problems. Running a database service that services millions of databases allows for deeper insight into how customers use the product, and where their headaches are. They have taken that knowledge and combined it with the Query Store, a feature introduced in SQL Server 2016, which tracks query execution plans and runtime statistics. This allows the database engine to identify queries that have regressed in performance, and changed execution plans (the path the engine takes to get the query's data). If the engine determines that a change in plan has occurred, and the query has regressed in performance, the engine will revert to a previous plan.

"If it is 3 a.m. in the morning, Automatic Plan Correction helps mitigate performance issues due to plan regression scenarios without manual intervention," said Joe Sack, principle program manager at Microsoft. "Then when you come in that next morning you can look at see what happened and work on root cause analysis. " There a number of other optimizations in space in SQL Server 2017, focused on making problematic query operations go faster.

Graph Database: One of my favorite features is the introduction of a graph engine into SQL Server. Graph databases are commonly used to track relationships or hierarchies, a place where relational databases have struggled in terms of structure and performance. Graph databases are implemented via nodes (or vertices) and edges (or relationships). For example, you might say John is friends with Jane, and Jane is friends with Becky. While there have been a number of small graph database projects, many have not supported the SQL language, and integration with other systems. By bringing graph into SQL Server 2017, users can take advantage of native SQL, along with the new match operator to perform graph queries.

Resumable Online Index Rebuild: As someone who has been a database administrator for way too long, this feature has tremendous appeal to me. Indexes get fragmented as updates and deletes happen, and need to be reorganized and rebuilt periodically. Performing these operations are very IO intensive, and are commonly run during maintenance windows. However on larger systems some operations may run beyond the window and have to be aborted, or more frequently, simply aren't run. Resumable index rebuild allows you to schedule fixed window for your maintenance operations (for example, allocating three hours a night to index maintenance); or simply pause and resume them manually. This feature will change the ways DBAs perform database maintenance. 

Everything Else: Some of the other features included in this release are improved performance for backups, more enhancements to the In-Memory OLTP feature and integration of the popular Power Query tool with SQL Server Analysis Services. Microsoft also released a very interesting enhancement to its advanced analytics features by adding a predict operator to the T-SQL programming area. This can be a very fast way to perform analysis on a pre-existing R or Python model.

 

SQL Server 2017 Editions:

SQL Server 2017 is the biggest leap forward in the Microsoft data platform history with real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, new advanced security technology, and new hybrid cloud scenarios.

Enterprise Edition

SQL Server Enterprise delivers comprehensive datacenter capabilities for mission-critical database, business intelligence, and advanced analytics workloads.

Mission Critical Performance

  • Operating system max cores and memory
  • Enhanced in-memory OLTP performance
  • Operational analytics
  • Enhanced AlwaysOn with no domain join
  • Query Store
  • Temporal

Security

  • Always Encrypted
  • Row-level security
  • Dynamic data masking
  • Enhanced separation of duties
  • Enhanced SQL Server auditing
  • Transparent data encryption
  • Policy-based management

Data Warehousing

  • Enhanced in-memory ColumnStore
  • PolyBase in scale-out configuration (head and compute nodes)
  • License rights to (the APS) MPP appliance
  • Distributed query processing
  • Support for JSON

Business Intelligence

  • End-to-end mobile BI on all major platforms
  • Enhanced DirectQuery
  • In-memory analytics
  • Advanced data mining
  • Advanced tabular
  • Web portal experience (all reports in one place)
  • Modernized reports
  • Pin reports to Power BI
  • Enhanced multidimensional models

Advanced Analytics

  • In database advanced analytics
  • R integration with massive parallel processing for performance and scale
  • Works with in-memory technology
  • Run in database or standalone
  • Connectivity to R Open

 

Hybrid Cloud

  • Stretch Database
  • Enhanced backup to Azure
  • Enhanced HA and DR with Azure – ease of use, no domain join (Windows Server 2016)
  • SSIS integration with Azure Data Factory and Azure SQL Data Warehouse

 

Standard Edition

SQL Server Standard provides core data management and business intelligence capabilities for non-critical workloads with minimal IT resources.

Mission Critical Performance

  • Disk-based OLTP
  • 24 cores max and 128 GB max memory
  • 2-node single database failover (non-readable secondary)
  • Query Store
  • Temporal

Security

  • Row-level security
  • Dynamic data masking
  • Basic auditing
  • Separation of duties
  • Policy-based management

Data Warehousing

  • PolyBase (compute node only)
  • Support for JSON

Business Intelligence

  • Basic tabular (16GB memory per instance)
  • Web portal experience
  • Modernized reports
  • Pin reports to Power BI
  • Enhanced multidimensional models

Advanced Analytics

  • Single-threaded for RRE
  • Connectivity to R Open

Hybrid Cloud

  • Stretch Database
  • Backup to Azure

 

Express Edition

SQL Server Express is a free edition of SQL Server ideal for development and production for desktop, web and small server applications.

Mission Critical Performance

  • 1 GB memory, max 10 GB memory
  • Basic OLTP
  • Query Store
  • Temporal

Security

  • Policy-based management

Data Warehousing

  • Support for JSON

Business Intelligence

  • Basic reporting and analytics
  • Web portal experience
  • Modernized reports

Advanced Analytics

  • Not avaliable

Hybrid Cloud

  • Stretch Database
  • Backup to Azure

Developer Edition

SQL Server Developer is now a free edition providing the full feature set of SQL Server Enterprise. For development and test only, and not for production environments or use with production data.

 

Hardware and Software Requirements

The following requirements apply to all SQL Server 2017 installations:

  • .NET Framework:
    • SQL Server 2016 require .NET Framework 4.6 for the Database Engine, Master Data Services, or Replication. SQL Server 2017 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, Windows Server 2012 R2 and Windows Server 2012 R2:
      • Require KB2919355 before installing .NET Framework 4.6.
      • Supported operating systems for SQL Server 2017 have built-in network software.
        • 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 2017 requires a minimum of 6 GB of available hard-disk space.
              • Disk space requirements will vary with the SQL Server 2017 components you install.
              • Drive
                • A DVD drive, as appropriate, is required for installation from disc.
                • Monitor
                  • SQL Server 2017 requires Super-VGA (800x600) or higher resolution monitor.
                  • Internet
                    • Internet functionality requires Internet access (fees may apply).

 

The following memory and processor requirements apply to all editions of SQL Server 2017:

  • 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

 

Please Notice the following:

  • Installation of SQL Server 2017 is supported on x64 processors only. It is no longer supported on x86 processors.
  • ·         Picture 1 is promotional only, picture 2 and 3 are the actual item.
  • The software comes with retail Core License, making them good in a production setup.
  • If you have any question, please don’t hesitate to ask. We will do all we can to answer you within one business day.
  • When you order, we always ship the item within 3 business days. The delivery time depends on the shipping method you chose, when you ordered.

 

As you install SQL Server 2017, it is important to note that both SQL Server Management Studio and SQL Server Reporting Services are now separate installs from the database engine and other components. Management Studio has a different release cycle from SQL Server and is updated monthly.

 

Weiterführende Links zu "Windows SQL Server 2017 Enterprise 32 Core"
Bewertungen lesen, schreiben und diskutieren... mehr
Kundenbewertungen für "Windows SQL Server 2017 Enterprise 32 Core"
Bewertung schreiben
Bewertungen werden nach Überprüfung freigeschaltet.

Die mit einem * markierten Felder sind Pflichtfelder.