Back to Top

Microsoft SQL Server Standard Core Edition - license & software assurance -

Mfg. Part: 7NQ-00162 | CDW Part: 2669834 | UNSPSC: 43232304
$6,164.99Advertised Price
Lease Option ($173.17 /month) Lease Availability

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

Note: Leasing is available to businesses only. Leasing is not available to individuals.
Mon-Fri 7am-7:30pm CT
Availability:In Stock
Ships today if ordered within 14 hrs 8 mins
  • License & software assurance
  • 2 cores
  • Open Value
  • additional product
  • 3 Year Acquired Year 1
  • Win
  • Single Language
View More
Product Overview
Main Features
  • License & software assurance
  • 2 cores
  • Open Value
  • additional product
  • 3 Year Acquired Year 1
  • Win
  • Single Language
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

License Category: License
License Qty: 2 cores
License Type: License & software assurance
Licensing Program: Microsoft Open Value

Support Details Full Contract Period: Full-term

Brand: Microsoft
Compatibility: PC
Localization (Vendor Specific): Microsoft Single Language
Manufacturer: Microsoft Open Value 2.0
Model: Server Standard Core Edition
Packaged Quantity: 1
Product Line: Microsoft SQL

Service & Support Details
Service Type: New releases update

Software Family
Microsoft Edition: Standard
Microsoft Family: MS SQL Server
Microsoft Version: Non-Specific

Category: Business applications
Subcategory: Business - databases / database tools

License Pricing: Volume
Licensing Details: 3 Year Acquired Year 1 , Additional product

Service & Support
Type: New releases update

Product Reviews
Microsoft SQL Server Standard Core Edition - license & software assurance is rated 4.0 out of 5 by 19.
Rated 3 out of 5 by from You can share the results of an integration without having to share the file. The performance could be better. Valuable Features:The most valuable feature is the easy installation. The user just needs to know how to read.Improvements to My Organization:The SQL Server is helping us with the most feared corporate problem: Excel spreadsheets. The individual user can perform an integration and share the same results with others without the necessity to "share" the file. This reduces the data traffic on my company network.Room for Improvement:Table partition and memory management. The performance could be better.Use of Solution:I have used it for more than 10 years.Stability Issues:The SQL Server has a big issue when some systems use Java as a primary software interface. This database loses the ability to manage memory, consequently locking the processes and losing performance in the execution of some robust queries.Scalability Issues:Unfortunately, this database doesn't have a good concept of partition table. If you need to create monthly (Jan to Dec) partitions in one table, this action create 12 different files for the same table. In others database this process are more transparent and are capable to create partitions inside the same Database.Technical Support:The technical support team for SQL Server is very friendly if we compare with others commercial database products. Not only with Microsoft but, this database have more technical information published on the internet, books and self-taught users to help.Previous Solutions:I am still using other commercial solutions, but the price of this database is much less expensive than others. It is about four times less expensive.Initial Setup:The initial setup is one of the good things about MSSQL. It is very easy to do and to start the development that you need to use after the installation.Pricing, Setup Cost and Licensing:In my point of view, the MSSQL are the most inexpensive database commercial solution. If do you need to build a consistent ERP for example, with a medium to hard capability and don't have much budget to spend it, this is your solution.Other Solutions Considered:Of course I evaluated other options! I never choose the first option and I always try to look around to find competitive vendor options. I already know and have expertise with IBM/DB2 and Oracle solutions. For this new architecture, MSSQL was the best option at the moment for being a pilot project.Other Advice:I suggest that you are first familiar with the bundle functions and plan some of the functions before starting the project. Find more information about the routines and how easy or hard it might be to start the development when you are thinking about cascade and constraints.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-07-25
Rated 4 out of 5 by from The database engine is one of the most valuable components of the platform. Valuable Features:The database engine within SQL Server 2014 is one of the most valuable components of the platform to me.The engine provides a solid and efficient database backend for any relational database requirement, performance is strong and there are options such as table, index partitioning and columnstore indexes that enhance the scalability of the platform.In addition to the database engine, I would also highlight the built-in integration services platform (SSIS) for ETL purposes as well as the Reporting and Analysis Services functionality (SSRS and SSAS respectively).One of the key features that I would use regularly to support the delivery of a Data Warehouse solution would be the Master Data Services (MDS). This is an extendable Master Data Management platform that works very well out-of-the- box.Improvements to My Organization:As an IT Services organization, our companies have used this product in dozens of customer deliveries for solutions such as ERP applications, Data and Analytics solutions, and more. We also use the product internally as the backend for some of our most important operational systems.Room for Improvement:The user interface to the web frontend of MDS could be more intuitive and the Analysis Services platform has not evolved much in recent times, these are the two things that come to mind.Use of Solution:This specific version (2014), I have used for approximately three years. However, I use other versions of the software on a regular basis, such as 2012 and 2016.Stability Issues:There were no issues with stability.Scalability Issues:There were no issues with scalability.Technical Support:Microsoft has a solid support structure for the SQL Server platform and I’ve always been provided with a good service.Previous Solutions:We used a combination of RDBMS platforms and we still do in addition to this solution.Initial Setup:The installation and configuration was very straightforward. The full setup typically takes less than one day.Pricing, Setup Cost and Licensing:The Enterprise license includes features that enrich the product experience as well as performance and scalability options. Choose this over the standard license where possible.Other Solutions Considered:We reviewed many RDBMS platforms for suitability depending on the requirements of the customers. We would also use the likes of Oracle 12c and Amazon RDS.Other Advice:Install a trial version as soon as you can and give it a try.Disclaimer: My company has a business relationship with this vendor other than being a customer:My company (Version 1) is a Microsoft Gold Partner. We are also an Oracle Platinum Partner as well as Amazon, etc.
Date published: 2017-07-23
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: 2017-07-11
Rated 4 out of 5 by from The SSIS or SQL Server Integration Services is a vital component that is associated to the Server. SQL Server and SQL Server Integration Services – Informative ArticleSQL Server and SQL Server Integration Services: Discussed and ExplainedThe concept of Relational Database Management System when brought forward by Microsoft was known as SQL Server. Architecture of SQL is a division where all the components combine and work, both; independently and together. This is done in order to process the services offered, in a defined way. This allows SQL Server to work smoothly.The external SQL Server interface is developed by the Protocol Layer. All the operations conducted on the server are transmitted through a defined format known as the Tabular Data Stream (TDS). Basically, this is an Application Layer Protocol that helps to transfer data between the client and server (database).Some other points that in a combination help make SQL an essential database management system for users include the following:Data StorageIt is a collection of a variety of tables with all sorts of types including; primary types – decimal, integer, float, etc., varchar, and more.Concurrency and locking:The server permits users to make use of the SQL database concurrently by multiple types of clients. So it is required to take control of the simultaneous database access to the shared data. The two concurrency control modes provided are; pessimistic and optimistic.SQL uses lock mechanism, in the pessimistic mode of concurrency control and they can be further classified as; shared & Exclusive Locks.Data retrieval:Data in SQL Server is retrieved via querying it and this query procedure is executed by the SQL Server variant; T-SQL. The order of steps in the procedure of querying for essentials to recall the data requested for is decided by the Query Processor.Buffer ManagementThis part of SQL Server plays a critical role in reducing the Disc I/O while it buffers the pages into RAM. One can store up to 8 KB of pages in the buffered memory and this collection of all buffered pages is known as the Buffer Cache.SQL Server and Its VersionsThe entire database held by SQL Server is available as Primary (*.mdf) and Secondary (*.ndf) Database respectively. While an LDF file’s role is to hold the entire log details of the transactions carried out on any of the database.Amongst all the versions of SQL Server; 2005, 2008 R2, 2014, and others; 2000 was the first version to be adding multiple performance measures to the Server. And out of all the measures introduced by SQL Server version 2000, SQL Server Integration Services or SSIS was the most vital one.Detailing Of SQL Server and SQL Server Integration Services SecurityThe SSIS Security of SQL Server consist of a variety of layers offering a completely sound environ for the services. These layers constitute of the below mentioned components:* Package Properties;* Digital Signature;* Operating System Permissions;* Database roles.When used in a combination for applying security measures, these components act as a defensive shield to the packages of SQL Server.In order to interpret the concept of SQL Server and SQL Server Integration Services security, understanding the platform of SSIS is of primary importance. The forthcoming segment of this article discusses about the same as well as the attributes offered by it in SQL Server environ.Understanding the SSIS Concept of SecurityThe SSIS or SQL Server Integration Services is a vital component that is associated to the Server. Normally used for carrying out a wide number and variety of operations related to data migration this platform has been structured considering the two mentioned elements:* Data Integration which happens to be an approach for combining the data from different set of resources. Thus, representing it in a manner that is unified and coordinated.* Workflow programs a set of applications that modify procedures to some point and even require manual agreement / customization or modification of activities sometimes.The following functions are allowed to be performed at a higher level:* Data retrieval through any source and loading of components into any source with a defining workflow.* Carrying out a wide number procedures on the database including; calculation, conversion, etc.This was an overview of the SSIS platform therefore, proceeding to the concept of SSIS security measures is feasible now.The Concept of SSIS SecurityAlways using trusted mediums for launching the packages is one of the most important concepts of the SSIS Security measure. And prior to that, you must necessarily identity the source of package before opening it, which can be done by allotting certificates to packages.The Perks of It: Unauthorized access to the server’s sensitive data can be kept under control via allotting identity features to a package. Also, it guarantees control on the SQL Server package configuration.Even the logs, checkpoint files, and the configurations can be protected as well.The Package Information displayed via SSMS (SQL Server Management Studio) Integration Services is offered integrity and protection by the medium of this platform.A better understanding about the functional measures and features of the SSIS Security can be referred in the upcoming sections below.* Access On Package Data Components To Be Controlled: To limit or restrict access to package or its components, they are encrypted via “ProtectionLevel” property applied. Level of this type of security can be adjusted accordingly. Values get automatically encrypted for properties that are assigned to sensitive set of data by the IS (Integration Services). Only on providing the correct password, can an encrypted data be displayed.* Package Access To Be Controlled: SQL’s MSDB database or an XML file can be used for storing the IS Packages with file extension as .dtsx. In an MSDB database the “sysdtspackages” & “sysssispackages” for storing the package, tables are taken into usage. Thus, when database backup is created, associated packages automatically get backed up. In order to control access to these packages, three types of database roles are allotted to them:* Db_ssisadmin* Db_ssisltduser* Db_ssisoperatorTIP: In case the file system is used for package storing, make sure that file or folders containing the packages are secure completely.* Access to Packages Containing Files To Be Control: Information encapsulated within the log, checkpoint files, and configuration packages require being prevented and protected due to the sensitive nature they have. Some of the factors associated with the approach are:* Checkpoint file storage must only be done into the file system.* Storage of Logs and Config files can be done using; SQL DB Tables or the File System.* Extra provision of security is needed by the checkpoint files stored under file system.* IS Service Access To Be Controlled: “Windows Administrative” group members are assigned with package running access & stop roles. Meanwhile, users that are not member of the group are authorized to access or eliminate packages started only by them.Conclusion: Security is a matter of concern regardless of the platform being discussed about. And understanding the detailed aspects of the SSIS Security measure helps prevent the SQL Server packages from unofficial access.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-07-04
Rated 4 out of 5 by from The AlwaysOn feature ensures database availability, even when one of the servers is down. Valuable Features:Apart from the standard SQL database-related features, the 2012 version enables the AlwaysOn functionality which enables two or more SQL Servers that can be clustered, with heartbeat across geographic locations along with high availability failover and 99.9999% uptime.Improvements to My Organization:We have deployed three instances of the SQL Server, i.e., two at the primary datacenter and one at the disaster recovery facility. The AlwaysOn feature has ensured 100% database availability, even when one of the servers is down without any performance issues for the end user.Room for Improvement:Currently, this feature is available only for the Enterprise Edition and it will be very useful if the same is available with the Standard Edition.Use of Solution:I am using the SQL Server for more than 10 years and the 2012 version, I have been using since the last five years.Stability Issues:There were no stability issues. If the initial configuration is done correctly, there are no issues. If the other servers are connected at remote locations, then the connectivity performance plays a vital role and it should be 10-15 ms for best results.Scalability Issues:There were no scalability issues.Technical Support:We have received excellent support from Microsoft and the local partners.Previous Solutions:In the earlier versions, we used log shipping to the other servers for the failover and replication requirements. With this version, all the servers are Active/Active and there is no issue related to the availability or failover.Initial Setup:The basic installation is simple, whereas rest of the clustering requires an expert skill level for the configuration and deployment.Cost and Licensing Advice:When comparing the Standard Edition to the Enterprise, it is expensive but the performance and features meet with the ROI and TCO. Thus, overall, it minimizes the redundant servers, multiple backup copies, the risk of non-availability of the latest copy at the disaster recovery.Other Advice:The latest 2016 version has many more new features and functionalities, if you have the Enterprise Level Agreement and subscription model, you can upgrade to the latest version.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-06-12
Rated 4 out of 5 by from Provides data quality services tools and In-Memory OLTP tables. Valuable Features:* SQL Server integration services tools* Data quality services tools* Master data services tools* SQL Server reporting services tools* Data partitioning (horizontal partitioning) tools* ColumnStore indexes* In-memory OLTP tablesImprovements to My Organization:We design and implement data warehouse solutions with SQL Server 2016 Developer Edition tools. This solution has:* Given us high levels of productivity* Allowed us to use an agile approach to the design and implementation of data warehouse solutions for our customers* Given us a competitive advantage in our marketRoom for Improvement:We do not have much to complain about SQL Server 2016 Developer Edition in itself.We do have some complaints regarding licensing. In an emerging market like Argentina, it is very steep for our customers to pay USD 28,000 or more on licensing for an instance of SQL Server 2016 Enterprise Edition. This poses a limiting factor to our growth.Use of Solution:We have been using SQL Server 2016 Developer Edition for a few months so far. We have been using the previous version (SQL Server 2014 Developer Edition) for more than two years.Deployment Issues:We did not encounter any deployment issues.Stability Issues:We did not encounter any stability issues.Scalability Issues:We did not encounter any scalability issues. This is the case even though the Developers Edition does not offer the same level of performance and scalability that the equivalent Enterprise Edition offers.Customer Service:As usual, Microsoft offers very good customer service. The amount of resources (self-study materials, online courses, and tutorials) is huge and most of it is free. Paid customer service is also very good.Technical Support:Paid technical support is very good and efficient.Previous Solutions:I have used data warehouse tools from Microsoft since SQL Server 2000.Initial Setup:If you do the proper training prior to the setup, there will be no issues. However, the learning curve is wide and tall.You could get started fast and sure if you stick to the many wizards included with the tools. However, the scope of those said wizards is limited.Implementation Team:We implemented with an in-house team only, with proper, prior training that was also done in-house.ROI:Since SQL Server 2014 Developer Edition, Microsoft has been offering these tools free of charge. The ROI is mainly focused around training investment. We do the training in-house, so the ROI is around one year.Cost and Licensing Advice:We have no issues with pricing and licensing for SQL Server 2016 Developer Edition, as it is free of charge. The thorny issue is with pricing and licensing with customers.We do our best to design data warehouse solutions that can cover requirements from our customers within the capabilities of SQL Server 2016 Standard Edition.Other Solutions Considered:The cost-benefit ratio offered by Microsoft's data warehouse solutions is, by a long shot, much more convenient for our customers, small and medium sized companies, than solutions from other vendors.Other Advice:My advice is focused on companies that develop and offer data warehouse solutions for customers that use SQL Server. Consider the ROI, which is mostly training investment (for the Developer Edition). If training is not done in-house, only hire training from an official Microsoft training center in your region. Look for the best training center. Once you are done with the training, you can start taking customers for data warehouse projects.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-03-20
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
  • y_2017, m_8, d_22, h_24
  • bvseo_bulk, prod_bvrr, vn_bulk_1.0.0-hotfix-1
  • cp_1, bvpage1
  • co_hasreviews, tv_0, tr_19
  • loc_en_US, sid_2669834, prod, sort_[SortEntry(order=SUBMISSION_TIME, direction=DESCENDING), SortEntry(order=FEATURED, direction=DESCENDING)]
  • clientName_cdw
Adding to Cart...
8/23/2017 1:52:55 AM
^ 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.


Something went wrong.

Please try again later.