396

Microsoft SQL Server - license - 1 user CAL

Mfg. Part: AAA-03340-CCE | CDW Part: 3446137 | UNSPSC: 43232304
$183.53Advertised Price
Close

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

Note: Leasing is available to organizations only. Leasing is not available to individuals.
800.808.4239
Mon-Fri 7am-7:30pm CT
Availability:In Stock
Ships today if ordered within 8 hrs 49 mins
  • License
  • 1 user CAL
  • MPSA
  • Win
View More
Product Overview
Main Features
  • License
  • 1 user CAL
  • MPSA
  • Win
SQL Server exceeds dependability requirements and provides innovative capabilities that increase employee effectiveness, integrate heterogeneous IT ecosystems, and maximize capital and operating budgets. SQL Server provides the enterprise data management platform your organization needs to adapt quickly in a fast-changing environment. With the lowest implementation and maintenance costs in the industry, SQL Server delivers rapid return on your data management investment. SQL Server supports the rapid development of enterprise-class business applications that can give your company a critical competitive advantage.

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: 1 user CAL
License Type: License
Licensing Program: Microsoft Products and Services Agreement (MPSA)

Header
Brand: Microsoft
Compatibility: PC
Manufacturer: Microsoft NGVL Level B
Model: Server
Packaged Quantity: 1
Product Line: Microsoft SQL

Software Family
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 B
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 - license is rated 4.1 out of 5 by 14.
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
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
  • y_2017, m_4, d_24, h_15
  • bvseo_bulk, prod_bvrr, vn_bulk_1.0.0-hotfix-1
  • cp_1, bvpage1
  • co_hasreviews, tv_0, tr_14
  • loc_en_US, sid_3446137, prod, sort_[SortEntry(order=SUBMISSION_TIME, direction=DESCENDING), SortEntry(order=FEATURED, direction=DESCENDING)]
  • clientName_cdwg
 
Adding to Cart...
4/26/2017 7:11: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.

Error!

Something went wrong.

Please try again later.