Microsoft Puts SQL Server Express in Cloud for Light Workloads
Don't need an enterprise-grade database on the cloud? Microsoft offers Azure customers a low-cost, lightweight SQL server option for testing and purposes and apps.Azure SQL is Microsoft's bid to get enterprises to float their databases on the company's cloud, but it may be overkill for some organizations or developers looking to test their apps. Microsoft's answer to the problem is to release SQL Server Express to the Azure Gallery marketplace. Customers can now access SQL Server Express with Tools 2014, 2012 and 2008R2 virtual machines for Azure, the company announced. Originally released as a slimmed-down database foundation for on-premises applications or embedded into basic desktop apps, the software has been caught up in Microsoft's "cloud-first" business strategy. "SQL Server Express is a version of SQL Server you can use for dev/test and Web and mobile apps with lightweight relational database needs," stated the company in a Feb. 12 blog post. Fulfilling those roles, SQL Server Express VMs work well with .NET, JDBC, PHP and other programming languages, noted Microsoft, and can be used to power popular Web-based content management platforms, including WordPress and Drupal. The offering is strictly meant to make it easier to spin up a modest cloud database for projects with modest needs. "SQL Server Express has a limit of 1GB of memory and 10GB per database," revealed Microsoft. "The images include the core SQL Server Engine as well as SQL Server Management Studio."
Apart from the cost associated with running a virtual machine on Azure, a SQL Server Express licensing is free. By comparison, a Standard Azure SQL database (S0 plan, 250GB) costs approximately $15 per month while some high-performance Premium plans command thousands of dollars. For added savings, users can pause the virtual machine while it goes unused, suggested Microsoft.