{"id":50480,"date":"2024-02-15T08:00:00","date_gmt":"2024-02-15T16:00:00","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=50480"},"modified":"2024-04-19T10:02:53","modified_gmt":"2024-04-19T17:02:53","slug":"how-sql-developers-can-maximize-savings","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2024\/02\/15\/how-sql-developers-can-maximize-savings\/","title":{"rendered":"How SQL developers can maximize savings"},"content":{"rendered":"\n
Whether you build applications for SQL Server on-premises or in Azure, there are several options for you to develop or test for free, or with substantial cost savings. Some of these options you may be familiar with, but this post will help explain details and answer some questions Microsoft often gets to provide you a clear story.<\/p>\n\n\n\n
SQL Server comes in several editions and Developer Edition has for many years been the choice of many developers to build applications and test SQL Server with no license costs and the full functionality<\/em> of SQL Server. As the documentation describes SQL Developer Edition<\/a>, it \u201cincludes all the functionality of Enterprise edition but is licensed for use as a development and test system, not as a production server.<\/em>\u201d Microsoft has had some questions about exactly what the term means \u201cas a development and test system.\u201d Let\u2019s turn to the SQL Server Licensing Guide<\/a> for the details.<\/p>\n\n\n\n The licensing guide states that SQL Server Developer Edition is \u201c\u2026licensed for development, test, and demonstration purposes only. SQL Server Developer Edition may not be used in a production environment\u201d. Notice the addition of the word \u201cdemonstration purposes<\/em>.\u201d This means, for example, that you can use SQL Server Developer Edition to do demos at your favorite conference as a presenter.<\/p>\n\n\n\n There are some other points in the licensing guide worth noting, including:<\/p>\n\n\n\n One of the questions Microsoft often gets is how to find previous versions of the SQL Server Developer Edition. Therefore, you can use the following shortcuts to help you find versions back to SQL Server 2016:<\/p>\n\n\n\n One of the most amazing stories about SQL Server for developers is containers. SQL Server containers are pre-installed versions of SQL Server on Linux that can be used for developers on macOS, Linux, or Windows for a consistent experience. Furthermore, if you just run a SQL Server container by default it is configured for SQL Server Developer Edition. Now your organization can use a distributed development approach using a consistent SQL Server deployment instead of relying on development servers. SQL Server containers provide a convenient method to test your application against multiple versions of SQL Server.<\/p>\n\n\n\n You can find out more about how to use SQL Server containers<\/a>. This includes details about how to find all container images for SQL Server 2017, 2019, and 2022 from the Microsoft Artifact Registry.<\/p>\n\n\n\n Visual Studio Subscriptions provides developers options to use licenses for SQL Server Standard and Enterprise editions to develop and test applications for non-production scenarios. One scenario that can help developers is the ability to develop and test applications against SQL Server Standard Edition.<\/p>\n\n\n\n One of the benefits of a Visual Studio Subscription is Azure credits<\/strong>. Azure credits allows developers to receive free credits towards use of Azure services such as SQL Server (any edition) in Azure Virtual Machine or Azure SQL Database for development and testing purposes. No credit card is required to use these credits and it provides an option to develop or test SQL in Azure. While the number of monthly credits may feel limited, developers may find this benefit of their Visual Studio subscription as a method to get started in the cloud.<\/p>\n\n\n\n If Azure credits are not enough for your development or testing needs, Visual Studio subscribers have a benefit available to them called Azure Dev\/Test pricing<\/strong><\/a>. Azure Dev\/Test pricing, offered exclusively<\/em> to Visual Studio subscribers<\/strong>, allows developers to save money to develop and test applications with Azure services.<\/p>\n\n\n\n Azure Dev\/Test pricing offers three plans:<\/p>\n\n\n\n Each plan has different requirements and offers different benefits per your needs. Azure credits are not designed to be used in combination with Azure Dev\/Test pricing<\/a>. <\/p>\n\n\n\n Azure Dev\/Test pricing not only provides significant cost savings for dev\/test scenarios for Azure Services such as Azure SQL Database or Azure SQL Managed Instance, but also allows customers to use software that is included in their Visual Studio subscription for free in an Azure Virtual Machine.<\/p>\n\n\n\n For example, if your Visual Studio subscription includes licensing for SQL Server, you can deploy SQL Server Standard or Enterprise Edition in an Azure Virtual Machine and not incur licensing charges from Azure. This could provide a method for you to test your application against SQL Server Standard Edition in a cost effective manner.<\/p>\n\n\n\n You can also optimize your cost savings with both Azure Dev\/Test pricing and Azure Hybrid Benefit licensing. You can use Azure Dev\/Test pricing for your dev\/test workloads and Azure Hybrid Benefit<\/a> licensing for production workloads. Azure Hybrid Benefit is a licensing offer that helps you migrate and save to Azure by using your existing SQL Server licenses.<\/p>\n\n\n\n It is important to note that Azure Dev\/Test labs<\/a> is not related to Azure Dev\/Test pricing. Azure Dev\/Test labs is a free Azure service used to help you optimize provision of development and test environments. You use whatever Azure subscription pricing model is available for Azure services within your Dev\/Test lab deployments.<\/p>\n\n\n\n Microsoft has recently announced a new free offer<\/a> for Azure SQL Database now in preview. This offer is a major milestone for developers or any user of Azure SQL. This free offer provides a monthly set of cores and storage for free for a single Azure SQL Database per subscription for the lifetime<\/em> of the Azure subscription.<\/p>\n\n\n\n The most significant aspect of this offer is that it is not limited<\/strong> for development and testing purposes. While the number of free core and storage usage may not make it viable for medium or large production workloads, it can be an excellent option for developers to have a \u201cdeveloper edition\u201d of Azure SQL Database or for small workloads.<\/p>\n\n\n\n The free Azure SQL Database offer is based on the General Purpose service tier using Serverless compute so it carries all of the capabilities and limits that go with this deployment choice.<\/p>\n\n\n\n Provisioning an Azure SQL Database for the free offer is easy.<\/p>\n\n\n\n In some cases, developers need the full managed instance capabilities of SQL Server in the cloud so they choose Azure SQL Managed Instance. Developers can now save costs to develop and test applications with Azure SQL Managed Instance with a new free offer.<\/p>\n\n\n\n This offer, now in preview, includes the ability to try Azure SQL Managed Instance free of charge for the first 12 months to get:<\/p>\n\n\n\n This is a major leap forward for developers who are looking to test a migration strategy with Azure SQL Managed Instance.<\/p>\n\n\n\n It is easy to get started with this free offer. Use the Azure portal to create the new free Azure SQL Managed Instance. To create your free instance, follow these steps:<\/p>\n\n\n\n When you are ready to migrate, our Managed Instance Link feature<\/a> provides a true online migration path to modernize your SQL Server investments.<\/p>\n\n\n\n As you can see SQL developers have several options to develop and test applications with SQL for free or substantial savings both on-premises and in the cloud. Microsoft wants all developers using SQL to have the most cost-effective options to build applications that work with SQL, edge to cloud, and the latest innovations.<\/p>\n\n\n\n Here are a few other tips for you to save costs with Azure SQL:<\/p>\n\n\n\n To learn more about some of the exciting new innovations for developers for SQL check out these resources:<\/p>\n\n\n\n Whether you build applications for SQL Server or in Azure, there are several cost saving options for developers.<\/p>\n","protected":false},"author":6194,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"post_tag":[],"product":[5227],"content-type":[2424],"topic":[2466],"coauthors":[2512],"class_list":["post-50480","post","type-post","status-publish","format-standard","hentry","product-sql","content-type-best-practices","topic-developer","review-flag-1593580427-503","review-flag-free-1593619513-128","review-flag-new-1593580247-437"],"yoast_head":"\n\n
\n
SQL Server containers<\/h2>\n\n\n\n
Visual Studio Subscriptions<\/h2>\n\n\n\n
Azure Dev\/Test pricing<\/h2>\n\n\n\n
\n
Try Azure SQL Database for free (preview)<\/h2>\n\n\n\n
\n
Try Azure SQL Managed Instance for free (preview)<\/h2>\n\n\n\n
\n
\n
Other options for developers to save costs<\/h2>\n\n\n\n
\n
Learn more about SQL Server developer experiences <\/h2>\n\n\n\n
\n