how free is microsoft sql server developer edition really

Five reasons to take a chance

1. It is free – although the commercially licensed version of SQL Server is often less expensive that other leading database products anyway, you cannot get it cheaper than for zero cost. While it may only be used for non-operational purposes, the developer edition is still a good way of trying out new functions, testing, training, and so on.
2. It is fully loaded – it has all the same functions as the licensed SQL Server 2016 Enterprise edition, not a cut down version. This is important if you are using it to build applications that will eventually become real products or services.
3. It is unlimited – you can deploy any number of copies on an unlimited number of devices, including virtual machines hosted on multitenant infrastructure.
4. It is easily downgradeable – you can use the license to access SQL Server 2014 Developer Edition, without having to acquire a separate license for it.
5. It is free – did I mention that already?

Five reasons to skip this option

1. Usage is restricted – design, development, testing and demonstration of programs using the SQL database engine are all permitted, as long as the user has permanent access to the license owner’s internal network. Therefore, while you could demonstrate an app to a client, you could not let that client play around with it themselves afterwards. Using the license in any other way, such as to support a commercial software installation, would constitute a breach of the license terms.
2. Microsoft gets access to your data – it is mandatory with any non-commercial installation of SQL Server that all your usage data covering performance, errors, feature use, IP addresses, device identifiers and more, is sent to Microsoft. There are no exceptions. This will likely rule it out for any company that deals with particularly sensitive data.
3. There is a risk of side effects using SQL Server 2016 Developer Edition instead of the real edition for operational use in the future. Although features are the same, the binaries may differ – who knows? This is unavoidable, so thorough final testing is essential to ensure you can sidestep any potential conflicts.
4. No other licenses are included – just because you are licensed to use SQL Server, does not mean you are licensed to run the operating system or any other software running underneath or alongside it. So unless you only need it for a short period, in which case you could potentially use a free trial version of an OS like Windows Server or Windows 10, you need to make sure you have commercial licenses for all the relevant software.
5. Compliance may be complex – SQL Server 2016 Developer Edition can also be licensed through the Microsoft Developer Network (MSDN). This has several advantages, including licensing for the underlying operating system and additional test and development tools such as Visual Studio. However, MSDN requires that all users, including sales people or support staff who access that SQL Servers, possibly need additional licenses. This can make it expensive. Not only that, all the installation files for the VSDE and MSDN routes are identical, so you need to prove which one you have installed. Otherwise, you will not get the benefit of the doubt.

Conclusion

In a nutshell, the reality is that the VSDE route to SQL Server 2016 Developer Edition may only be suitable for a very specific set of circumstances within an organization. If developing applications and services is essential for your business, then eventually the approach of licensing SQL Server through MSDN may be the better choice.