SQL Server 2014 Enterprise Edition: Server Setup: Feature Selection

Note: Still needs Microsoft .NET Framework 3.5.

  • Instance Features

    The configuration and operation of each instance feature of a SQL Server instance is isolated from other SQL Server instances. SQL Server instances can operate side-by-side on the same computer.

    • Database Engine Services

      Includes the Database Engine, the core service for storing, processing and securing data. The Database Engine provides controlled access and rapid transaction processing and also provides rich support for sustaining high availability. The Database Engine also provides support for the utility control point in the SQL Server Utility. Only Database Engine Services and Analysis Services can be clustered.

      • SQL Server Replication

        Includes a set of technologies for copying and distributing data and database objects from one database to another and synchronizing between the databases for consistency. You can use replication to distribute data to different locations, and to remote and mobile users over local and wide area networks, dial-up connections, wireless connections and the Internet.

      • Full-Text and Semantic Extractions for Search

        Includes the Search engine that supports Full-Text Extraction for fast text search as well as Semantic Extraction for key phrases (likely tags) and similarity search on content stored in SQL Server.

      • Data Quality Services

        Includes Data quality database objects.

    • Analysis Services

      Includes Analysis Services and tools used to support online analytical processing (OLAP) and data mining. Only Database Engine Services and Analysis Services can be clustered.

    • Reporting Services - Native

      Includes Reporting Services, a server-based application for creating, managing, and delivering reports to email, multiple file formats, and interactive Web-based formats. The Native mode server provides all processing and management functionality through Reporting Services components. Reporting Services cannot be clustered.

  • Shared Features

    Each shared feature is installed once within a defined scope and operates within that scope. The defined scope can span all SQL Server versions on a computer (e.g., SQL Server Browser), can be isolated to one major version of SQL Server (e.g., SQL Server Management Tools), or can be isolated to one or more minor versions.

    • Reporting Services - SharePoint

      Includes Reporting Services, a server-based application for creating, managing, and delivering reports to email, multiple file formats, and interactive Web-based formats. SharePoint integrated mode integrates the report server with SharePoint products. The report viewing and report management experience are integrated with SharePoint sites and libraries. Reporting Services cannot be clustered.

    • Reporting Services Add-in for SharePoint Products

      Includes management and user interface components to integrate a SharePoint product with an SSRS report server in SharePoint integrated mode. The add-in only needs to be installed on server running a SharePoint product.

    • Data Quality Client

      Includes Data quality client objects.

    • Client Tools Connectivity

      Includes components for communication between clients and servers.

    • Integration Services

      Includes the designer, runtime, and utilities that enable Integration Services to move, integrate, and transform data between data stores.

    • Client Tools Backwards Compatibility

      Client Tools Backwards Compatibility

    • Client Tools SDK

      Includes the software development kit containing resources for programmers.

    • Documentation Components

      Installs only the components that you use to view and manage the documentation for SQL Server 2014. By default, the Help Viewer component uses the online library. After installing SQL Server, you can use the Help Library Manager component to download documentation to your local computer.

    • Management Tools - Basic

      Includes Management Studio support for the Database Engine and SQL Server Express, SQL Server command-line utility (SQLCMD), SQL Server PowerShell provider, and Distributed Replay Administration Tool.

      • Management Tools - Complete

        Adds the following components to the basic management tools installation: Management Studio support for Reporting Services, Analysis Services, and Integration Services technologies, SQL Server Profiler, Database Tuning Advisor, and SQL Server Utility management.

    • Distributed Replay Controller

      Includes the Distributed Replay Controller which orchestrates the actions of the distributed replay clients.

    • Distributed Replay Client

      Includes the Distributed Replay Client. Multiple Distributed Replay Clients work together to simulate a workload against an instance of SQL Server.

    • SQL Client Connectivity SDK

      Includes SQL Server Native Client (ODBC / OLE DB) SDK for database application development.

    • Master Data Services

      Includes Master Data Services, the platform for integrating data from disparate systems across an organization into a single source of master data for accuracy and auditing purposes. Installs the Master Data Services Configuration Manager, assemblies, PowerShell snap-in, and folders and files for Web applications and services.

  • Redistributable Features

    SQL Server redistributable and shared features are installed when needed: Error and Usage Reporting, SQL Server Native Client, MSXML version 6.0, Sync Services for ADO.NET, and SQL Server Browser.

Default Paths:

  • Instance root directory: C:\Program Files\Microsoft SQL Server\
  • Shared feature directory: C:\Program Files\Microsoft SQL Server\
  • Shared feature directory (x86): C:\Program Files (x86)\Microsoft SQL Server\

Keywords:
Setup, Installation, Features, Feature Selection, SQL Server, SQL Server 2014, Microsoft

Comments

Post a Comment

Popular posts from this blog

SQL Server Setup: Windows Firewall warning (Ports)

Image
What was it again SQL server setup throws out, when you have your Windows Firewall on?! Rule "Windows Firewall" generated a warning. The Windows Firewall is enabled. Make sure the appropriate ports are open to enable remote access. See the rules documentation at http://go.microsoft.com/fwlink/?LinkId=94001 for information about ports to open for each feature. Keywords: Setup, Firewall, Ports, SQL Server, Microsoft
Read more

Artifical Intelligence / Machine Learning: Generative Adversarial Networks (GANs) / Generative Modeling

Image
While there is a lot of buzz on data analysis and understanding data there for applied use of artifical intelligence and machine learning it is less known in the public on what Artifical Intelligence can do regarding generating original content and altering existing content. So called Generative Adversarial Networks can generate or change pictures and can even alter videos. E.g. The website www.ThisPersonDoesNotExist.com gives and interesting and somewhat worrisome examples of that technolgy. The speed at which this technology evolves is as astounding as the results it can give already. The technology can not only be used to generate static content like the pictures of faces, but can also modify videos. There is an example where the same scene filmed by day is recreated to appear at night: Another example illustrates how a video of a horse is transferred to a video of a zebra. As Ian Goodfellow points out the GAN did not only change the brown horse to be white with bla...
Read more

Dates in JSON

What format is the right one in JSON? "Or best? Is there any sort of standard on this?" "DateTimes in JSON are hard. The problem comes from the JSON spec itself: there is no literal syntax for dates in JSON. The spec has objects, arrays, strings, integers, and floats, but it defines no standard for what a date looks like." A common date/time-format used is ISO 8601. It is also used widely in libraries such as JavaScript's toJSON-method and Json.NET . In principle this turns the DateTime string into: <YYYY-MM-DD>T<HH:MM>[:SS.SSS][[+|-]HH:MM[:SS]|Z] Example: { "lastPlayedDateTime": "2021-12-28T23:30:00+01:00" } What's the Z? Z depicts the shorthand notation for UTC times, e.g. "2009-02-15T00:00Z" . Sources: Serializing Dates in JSON StackOverflow What is the "right" JSON date format? Wikipedia on ISO 8601 toJSON-method JSON spec
Read more