Microsoft SQL Server Standard Core Edition - license & software assurance -
License & software assurance
Get basic data management and business intelligence capabilities for non-critical workloads with minimal IT resources.
Microsoft SQL Server Standard Core Edition - license & software assurance - is rated 4.0 out of 5 by 21.
Rated 5 out of 5 by Gh0ce from A relational database system that is critical for storing reporting dataPrimary Use CaseThe primary use of SQL Server ( /products/sql-server ) is to store and retrieve data. If you go into the extra features that come with your license, you can also do reporting, analytics and ETL ( /categories/other-data-integration-and-access-tools ).Valuable FeaturesEverything is valuable. It is a relational database system which is critical for storing reporting data or any data that is highly relate-able. Plus your data is one of the most important assets in your company. Might as well have a good system to protect it.Improvements to My OrganizationIn a manufacturing system, storing test data in an Excel file has limitations in how much data can be stored at one time and how many people can manipulate the data at one time. Storing it in SQL Server ( /products/sql-server ) allows you to store as much data as you have disk space for. It can be viewed and modified by multiple people at one time.Room for ImprovementSetting up some of the more complex systems could be simpler. Things like service broker can be tricky to set up for the inexperienced.Use of SolutionMore than five years.Stability IssuesStability seems very good. I have not seen any issues with this.Scalability IssuesI have not run into scalability issues. It feels very scalable.Customer Service and Technical SupportI have not needed to contact technical support for this productPrevious SolutionsI did not use a previous solution. I have heard of other companies using Microsoft Access or Excel for similar problems. However, after hearing the headaches they have, I would not recommend those for large scale projects.Initial SetupThe initial setup was straightforward, but configuration post-install can be complex. Complexity comes from attempting to optimize it and implementing some of the new features that come in new versions.Implementation TeamWe implemented it entirely in-house.Pricing, Setup Cost and LicensingPricing and licensing is based on a per core and/or per-processor license. Try to keep these low, but keep it above four. (Four is the minimum number of cores.) If you are working mostly with OLTP, make sure your single thread CPU speeds are high.Other Solutions ConsideredWe did not evaluate other options. The other options lacked support, lacked performance, or were too expensive.Other AdviceIf you don't have a DBA on site, hiring a consultant is recommended to help get things setup and configured. This will reduce headaches down the line.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-12-12
Rated 4 out of 5 by Gaston Nusimovich from Enabled us to use an Agile approach to the design and implementation of DW solutions.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 Indices* In-Memory OLTP tablesImprovements to My Organization:We design and implement DW solutions with SS 2016 Dev Ed tools. This solution has given us high levels of productivity, which has allowed us to use an Agile approach to the design and implementation of DW solutions for our customers, and this Agile approach has in turn given us a competitive advantage in our market.We have also started exploring the use of Microsoft R Client, MS R Services and MS R Server with SQL Server 2016 Dev Ed, which are part of the hosted Data Science package.We are also looking forward the inclusion of Python support in SQL Server 2017 for said hosted Data Science package.We are very interested in complementing DW solutions with Data Science and Machine Learning solutions, which could be a major plus for our existing DW customers, even though all hosted data science tools are only available in Enterprise Ed (for our customers), which again presents the same limiting factor (budget) already mentioned.Having said that, we see that the potential that the hosted Data Science tools offer to some of our customers is large enough to be explored and considered on a case by case basis, with proper ROI analysis.Room for Improvement:We do not have much to complain about SS 2016 Dev Ed in itself, we do have some complaints regarding licensing for SQL Server 2016 Enterprise Ed. In an emerging market like Argentina, it is very steep for our customers to pay U$S 28,000 or more on licensing for an instance of SS 2016 Enterprise Ed, and this poses a limiting factor to our growth.Use of Solution:We have been using SS 2016 Dev Ed for a few months so far, but have been using the previous version (SS 2014 Dev Ed) for more than two years.Deployment Issues:The deployment tools for DW solutions in both 2014 and 2016 editions of SQL Server are part of the SQL Server Data Tools (SSDT) package. As SSDT is based on Visual Studio, this toolset has been very stable since its inception, both in terms of performance as well as in terms of functionality, so, deployment in 2016 is done in the same way as in 2014, which translates into no issues during deployment.Stability Issues:There were no stability issues.Scalability Issues:There were no scalability issues, even though the Dev Ed does not offer the same level of performance and scalability that the equivalent Enterprise Ed offers.Pertaining to the hosted Data Science package that we have been exploring, we have found an important increase in scalability when comparing the performance of a given solution running as hosted, and the same solution running on the same server with only client R tools.This scalability advantage presents itself as an important reason to consider these tools as a viable solution to some of our DW customers.Customer Service:As usual, MS offers a very good customer service. The amount of resources (self-study materials, online courses, tutorials) is huge, most of it is free.Paid customer service is also very good.Technical Support:Paid tech support is very good and efficient.Previous Solutions:I have always used DW tools from Microsoft since SQL Server 2000.Initial Setup:If prior to the setup you do the proper training, there are no issues with setup, but 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, but the scope of said Wizards is limited.Implementation Team:We did not have deployment/implementation issues.ROI:Since SS 2014 Dev Ed, MS is offering these tools free of charge, ROI mainly is focused around training investment. As I have said, we do the training in-house. ROI is around one year (12 months).Pricing, Setup Cost and Licensing:No issues with pricing and licensing for SS 2016 Dev Ed, as it is free of charge, as mentioned above, the thorny issue with pricing and licensing is with customers. We do our best to design DW solutions that can cover reqs from our customers within the capabilities of SS 2016 Standard Ed.Other Solutions Considered:The cost-benefit ratio offered by Microsoft's DW solutions is, by a long shot, much more convenient for our customers (small and medium companies) than solutions from other vendors, hands down.Other Advice:Consider the ROI (most training investment). If training is not 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 DW projects.Disclaimer: My company has a business relationship with this vendor other than being a customer:I teach MOC courses on the design and implementation of DW solutions with the aforementioned tools.
Date published: 2017-08-22
Rated 3 out of 5 by Leonardo de Andrade 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 reviewer280197 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 Khilitchandra Prajapati 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 Andrew Jackson 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 Albeez 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 Gaston Nusimovich 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.