91

Microsoft SQL Server Standard Core Edition - license

Mfg. Part: AAA-03751-CCF | CDW Part: 3446322 | UNSPSC: 43232304
$2,891.99Advertised Price
Lease Option ($85.31 /month) Lease Availability
Close

Have leasing questions? Let us know how can we help.

Note: Leasing is available to businesses only. Leasing is not available to individuals.
800.800.4239
Mon-Fri 7am-7:30pm CT
Availability:In Stock
Ships same day if ordered before 4 PM CT
  • License
  • 2 cores
  • MPSA
  • Win
View More
Product Overview
Main Features
  • License
  • 2 cores
  • MPSA
  • Win
Get basic data management and business intelligence capabilities for non-critical workloads with minimal IT resources.

Technical Specifications
Specifications are provided by the manufacturer. Refer to the manufacturer for an explanation of the print speed and other ratings.
System Requirements
Platform: Windows

Software
License Category: License
License Qty: 2 cores
License Type: License
Licensing Program: Microsoft Products and Services Agreement (MPSA)

Header
Brand: Microsoft
Compatibility: PC
Manufacturer: Microsoft NGVL Level C
Model: Server Standard Core Edition
Packaged Quantity: 1
Product Line: Microsoft SQL

Software Family
Microsoft Edition: Standard
Microsoft Family: MS SQL Server

General
Category: Business applications
Installation Type: Locally installed
Subcategory: Business - databases / database tools

License
Agreement Term: All Terms
Category: License
Level: Level C
License Type: Licensing
Licensing Program: Microsoft MPSA
Product Pool: Server
VLK Category: No Volume License Key

Licensing
License Pricing: Volume

Product Reviews
Microsoft SQL Server Standard Core Edition - license is rated 4.1 out of 5 by 13.
Rated 5 out of 5 by from Provides many ways to help us organize data and process information. Valuable Features:The Microsoft ( https://www.itcentralstation.com/vendors/microsoft ) SQL Server is a great and powerful data storage capable to provide many functionalities starts on free version until the power with BI resource and mirroring.Improvements to My Organization:MS SQL ( https://www.itcentralstation.com/products/sql-server ) is a recognized data tool, it provides many ways to help us organize data and process information.Room for Improvement:MS SQL need to improve the big data functions and also own market share.Deployment Issues:few problemsStability Issues:noScalability Issues:i didn't use it like admin, i don't know.Customer Service:great productPrevious Solutions:Oracle, some times i used others solutions, but working by compatibility.Initial Setup:easy.ROI:never calculate.Cost and Licensing Advice:according you needDisclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-01-16
Rated 4 out of 5 by from We're able to create an end-to-end automated BI platform, but we'd prefer hosting multidimensional OLAP instances with Tabular rather than the either/or installation. Valuable Features:* Business intelligence platform* Analysis services (multidimensional and tabular)* Relational database features* Data extraction and transformation (integration services)Improvements to My Organization:It provides the ability to create an end-to-end automated BI platform through data management and provisioning, transformation and publication.Data platform development process improvement: Integrating the features of Visual Studio Team Foundation Server data projects for SQL Server development. Allows for smooth operation between development environments in conjunction with an agile process to release database changes.Room for Improvement:Hosting multidimensional OLAP instances in conjunction with Tabular, rather than the either/or installation.OLAP multidimensional ongoing maintenance - automated partitioning or interface for streamlining the mechanism within the cube and data layers.Integration Services: There is a great deal of room for improvement here in that thepackages are the least extensible part of the platform. Even with the feature ofplatform variables, since these are not easily managed and deployed. Our testers have had a great deal of difficulty swapping environments, particularly where the connection information changes (underlying database name, for example). Changing servers with identical database names is less problematic.Use of Solution:I've used it since its release in 2012 until now.Deployment Issues:No issues encountered.Stability Issues:There were some avoidable issues, primarily due to a lack of scaling in our own design.Scalability Issues:There were some avoidable issues, primarily due to a lack of scaling in our own design.Customer Service:Online information for SQL Server is extensive.Technical Support:I did not have the need to contact technical support for any reason.Previous Solutions:Open Source database and OLAP solution was found to lack stability, and required the installation of many moving parts in order to have a complete stack. These services don't always work together well, and the various online communities would frequently blame the other for issues.Initial Setup:It's straightforward to install a new instance, but more complex if new features are added to an existing instance. Deployment of SQL code is efficient through Visual Studio database project development methodologies.Implementation Team:I have used both in-house, and vendor teams for implementation, both with very high levels of expertise into different aspects of database development.ROI:It's very high as the data platform is business-critical.Cost and Licensing Advice:I don’t concentrate on this issue, but rather the necessary features and the version required.Other Solutions Considered:No other oprions were evaluated.Other Advice:Make sure that you have an experienced database administrator to implement the infrastructure of the solution.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2016-11-28
Rated 4 out of 5 by from The MSBI features SSAS, SSIS as well as SSRS together, has enabled us to build a data warehouse for our Enterprise. Valuable Features:I would rate MS SQL Server 4/5 for its ease of administration,rich features, Nice GUI support for all its complex features.Valuable features include:1.Management Studio (Nice GUI support for all its complex features.)2.Hot add CPU3.Configure Dynamic memory also configure MIN and MAX memory.( Very flexible)4.Replication ( Very Simple).5.Clustering (The best high availability feature available among allits compitators due to its robustness and scalability).6.SSIS ( Very rich).7.In memory OLTP in SQL Server 20128.Always On (High Availability) in SQL Server 2012Improvements to My Organization:The MSBI features SSAS, SSIS as well as SSRS together has enabled us to build a data warehouse for our Enterprise with Business Intelligence reports around the data. We have fully exploited its all complex features like Slowly Changing Dimensions in SSIS etc.Room for Improvement:I am not sure if these areas have been taken care in SQL 2012 but areas for improvement include:1.In SQL 2008 ,Data encryption is not a fully mature feature.Encryption works fine for individual rows.For handling a batch a for loop has to be written.This is not straight forward.2.Horizontal partitioning is not a fully mature feature.In horizontal partitioning Partition key has to be part of primary key.This becomes difficult to implement in already existing database.Use of Solution:14 years.Deployment Issues:No not at all.Stability Issues:No.Scalability Issues:No.Customer Service:Good.Technical Support:Good. We have had only a few issues.Previous Solutions:We were a Microsoft shop (.NET, Share point etc) primarily, hence using MS SQL Server 2008.Initial Setup:It was straightforward.Implementation Team:We implemented through in-house.Other Advice:1. Find out the right licensing mode you require (Comes with different options CAL/Server and # of CPUs and Virtualisation).2. Use the Enterprise lincencing or Standard edition or Web according to your need.3.Make use of SQL Server Clustering or LOg Shipping high availability solution, the best you can find.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2016-10-24
Rated 5 out of 5 by from Provides many ways to help us organize data and process information. Valuable Features:The Microsoft SQL Server is a great and powerful data storage capable to provide many functionalities starts on free version until the power with BI resource and mirroring.Improvements to My Organization:MS SQL is a recognized data tool, it provides many ways to help us organize data and process information.Room for Improvement:MS SQL need to improve the big data functions and also own market share.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2016-08-09
Rated 4 out of 5 by from The MSBI features SSAS, SSIS as well as SSRS together, has enabled us to build a data warehouse for our Enterprise. Valuable Features:I would rate MS SQL Server 4/5 for its ease of administration,rich features, Nice GUI support for all its complex features.Valuable features include:1.Management Studio (Nice GUI support for all its complex features.)2.Hot add CPU3.Configure Dynamic memory also configure MIN and MAX memory.( Very flexible)4.Replication ( Very Simple).5.Clustering (The best high availability feature available among allits compitators due to its robustness and scalability).6.SSIS ( Very rich).7.In memory OLTP in SQL Server 20128.Always On (High Availability) in SQL Server 2012Improvements to My Organization:The MSBI features SSAS, SSIS as well as SSRS together has enabled us to build a data warehouse for our Enterprise with Business Intelligence reports around the data. We have fully exploited its all complex features like Slowly Changing Dimensions in SSIS etc.Room for Improvement:I am not sure if these areas have been taken care in SQL 2012 but areas for improvement include:1.In SQL 2008 ,Data encryption is not a fully mature feature.Encryption works fine for individual rows.For handling a batch a for loop has to be written.This is not straight forward.2.Horizontal partitioning is not a fully mature feature.In horizontal partitioning Partition key has to be part of primary key.This becomes difficult to implement in already existing database.Use of Solution:14 years.Deployment Issues:No not at all.Stability Issues:No.Scalability Issues:No.Customer Service:Good.Technical Support:Good. We have had only a few issues.Previous Solutions:We were a Microsoft shop (.NET, Share point etc) primarily, hence using MS SQL Server 2008.Initial Setup:It was straightforward.Implementation Team:We implemented through in-house.Other Advice:1. Find out the right licensing mode you require (Comes with different options CAL/Server and # of CPUs and Virtualisation).2. Use the Enterprise lincencing or Standard edition or Web according to your need.3.Make use of SQL Server Clustering or LOg Shipping high availability solution, the best you can find.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2016-07-31
Rated 4 out of 5 by from We're able to create an end-to-end automated BI platform, but we'd prefer hosting multidimensional OLAP instances with Tabular rather than the either/or installation. Valuable Features:* Business intelligence platform* Analysis services (multidimensional and tabular)* Relational database features* Data extraction and transformation (integration services)Improvements to My Organization:It provides the ability to create an end-to-end automated BI platform through data management and provisioning, transformation and publication.Data platform development process improvement: Integrating the features of Visual Studio Team Foundation Server data projects for SQL Server development. Allows for smooth operation between development environments in conjunction with an agile process to release database changes.Room for Improvement:Hosting multidimensional OLAP instances in conjunction with Tabular, rather than the either/or installation.OLAP multidimensional ongoing maintenance - automated partitioning or interface for streamlining the mechanism within the cube and data layers.Integration Services: There is a great deal of room for improvement here in that thepackages are the least extensible part of the platform. Even with the feature ofplatform variables, since these are not easily managed and deployed. Our testers have had a great deal of difficulty swapping environments, particularly where the connection information changes (underlying database name, for example). Changing servers with identical database names is less problematic.Use of Solution:I've used it since its release in 2012 until now.Deployment Issues:No issues encountered.Stability Issues:There were some avoidable issues, primarily due to a lack of scaling in our own design.Scalability Issues:There were some avoidable issues, primarily due to a lack of scaling in our own design.Customer Service:Online information for SQL Server is extensive.Technical Support:I did not have the need to contact technical support for any reason.Previous Solutions:No, I've only used an earlier version of SQL Server.Initial Setup:It's straightforward to install a new instance, but more complex if new features are added to an existing instance. Deployment of SQL code is efficient through Visual Studio database project development methodologies.Implementation Team:I have used both in-house, and vendor teams for implementation, both with very high levels of expertise into different aspects of database development.ROI:It's very high as the data platform is business-critical.Cost and Licensing Advice:I don’t concentrate on this issue, but rather the necessary features and the version required.Other Solutions Considered:No other oprions were evaluated.Other Advice:Make sure that you have an experienced database administrator to implement the infrastructure of the solution.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2016-06-20
Rated 4 out of 5 by from The High Availability feature provides us with failover if a node becomes unavailable, but it lacks realtime data refresh in SSRS. Valuable Features:It's a solution that's always on.Improvements to My Organization:It has High Availability, therefore provides failover if a node becomes unavailable.Room for Improvement:* Few in SSIS* Realtime data refresh in SSRS* More datasources in Power BIDisclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2015-09-09
Rated 4 out of 5 by from With it, we've been able to tune individual queries by optimizing the database server, but the speed is inconsistent. Valuable Features:It allows for performance tuning to maximize performance. With the enhancements to the tuning wizard indexes are added to the needs of the system structure and use. I find this helps prevent locking of the system.Improvements to My Organization:It cuts down on the variable speed of queries, and individual queries can be tuned by optimizing the database server.Room for Improvement:The speed is inconsistent.Deployment Issues:N/AStability Issues:N/AScalability Issues:N/ACustomer Service:N/ATechnical Support:N/ADisclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2015-09-09
  • y_2017, m_3, d_21, h_15
  • bvseo_bulk, prod_bvrr, vn_bulk_1.0.0
  • cp_1, bvpage1
  • co_hasreviews, tv_0, tr_13
  • loc_en_US, sid_3446322, prod, sort_[SortEntry(order=SUBMISSION_TIME, direction=DESCENDING), SortEntry(order=FEATURED, direction=DESCENDING)]
  • clientName_cdw
 
Adding to Cart...
3/22/2017 11:32:51 PM
^ Back to Top

Maximum 300 characters
An account manager will email you within one business day to confirm your request.

Your Quote has been submitted

What Happens Next? A confirmation email is on its way. Within one business day, you will be contacted by an Account Manager to finalize your quote.

Error!

Something went wrong.

Please try again later.