Microsoft improves Azure SQL Server cloud service, simultaneously makes it worse

SQL Server compatibility better, reporting as a service chopped

Microsoft has announced improvements to its Azure SQL Database service, which offers a managed SQL Server database with patching and operating system maintenance handled automatically by the cloud service.

At the Professional Association for SQL Server (PASS) summit currently under way in Seattle, Microsoft Data Platform VP T.K. "Ranga" Rengarajan said that the service will be enhanced for greater compatibility with the full SQL Server product. Currently, Azure SQL Database supports only a subset of the features in the standalone version.

Coming soon in preview are a larger maximum database size (the current limit is 500GB), parallel queries (using multiple threads for query optimization), Common Language Runtime support (enabling .NET code to run within queries) and XML indexing for XML column types.

There will also be support for in-memory columnstore queries in the premium version of Azure SQL database. Columnstore indexes are a type of in-memory database, enabling much faster queries at the expense of easy updating. They are therefore suitable for large read-only datasets, such as those used by business analytics.

The announcement is good news for SQL Server developers puzzled by the differences between Azure SQL and plain old ordinary SQL Server, which can make migrating a database between the two a painful experience.

Here is an odd thing though. A few days ago, on 31 October, Microsoft discontinued its SQL Reporting service. This service used to offer SQL Server reporting as a managed service along the lines of Azure SQL. Now that it is withdrawn, the only way to use SQL Server Reporting Services (SSRS) on Azure is to install SQL Server on a virtual machine (VM) and manage it yourself.

The official notes on why managing SSRS yourself is preferable are telling:

SQL Server Reporting Services (SSRS) running on Azure Virtual Machines provides the full native mode feature set including: scheduled reporting, data driven subscriptions, email subscriptions, code segments and custom extensions, domain joining capability, and windows authentication integration. Additional benefits include superior data resiliency and the ability to suspend virtual machines when not in use, so you pay only for the hours that you use.

Overall it is a confusing story. Should you use Microsoft’s database as a service, or simply use Azure infrastructure to run SQL Server on VMs?

What to choose: SQL Server or SQL Database?

What to choose: SQL Server or SQL Database?

If performance is critical, the VM option is likely to be better, especially with recently introduced “D” series options that include up to 800GB of local SSD disk. SQL Server 2014 has a feature called Buffer Pool Extensions that uses SSD to optimize performance.

The cost of running SQL Server on a VM is higher though, and not only in terms of extra time spent on maintenance. The SQL Server licensing costs can be more than that for the VM itself, so for example a D14 VM with 16 CPU cores, 112GB of RAM and 800GB SD is currently £1,236.53 per month plus a mere £60.46 for the low-end SQL Web edition, but an additional £2,840.89 per month if you need SQL Server Enterprise.

Even if you only want Reporting Services, you have to pay for the whole of SQL Server, as the licence cannot be broken down.

If Microsoft were to evolve Azure SQL Database to full parity with SQL Server, Reporting Services included, the company would miss out on these hefty licensing fees. Figures like these illustrate how much of the old Microsoft approach to enterprise computing remains, even in its cloud incarnation. ®

Other stories you might like

  • Florida's content-moderation law kept on ice, likely unconstitutional, court says
    So cool you're into free speech because that includes taking down misinformation

    While the US Supreme Court considers an emergency petition to reinstate a preliminary injunction against Texas' social media law HB 20, the US Eleventh Circuit Court of Appeals on Monday partially upheld a similar injunction against Florida's social media law, SB 7072.

    Both Florida and Texas last year passed laws that impose content moderation restrictions, editorial disclosure obligations, and user-data access requirements on large online social networks. The Republican governors of both states justified the laws by claiming that social media sites have been trying to censor conservative voices, an allegation that has not been supported by evidence.

    Multiple studies addressing this issue say right-wing folk aren't being censored. They have found that social media sites try to take down or block misinformation, which researchers say is more common from right-leaning sources.

    Continue reading
  • US-APAC trade deal leaves out Taiwan, military defense not ruled out
    All fun and games until the chip factories are in the crosshairs

    US President Joe Biden has heralded an Indo-Pacific trade deal signed by several nations that do not include Taiwan. At the same time, Biden warned China that America would help defend Taiwan from attack; it is home to a critical slice of the global chip industry, after all. 

    The agreement, known as the Indo-Pacific Economic Framework (IPEF), is still in its infancy, with today's announcement enabling the United States and the other 12 participating countries to begin negotiating "rules of the road that ensure [US businesses] can compete in the Indo-Pacific," the White House said. 

    Along with America, other IPEF signatories are Australia, Brunei, India, Indonesia, Japan, South Korea, Malaysia, New Zealand, the Philippines, Singapore, Thailand and Vietnam. Combined, the White House said, the 13 countries participating in the IPEF make up 40 percent of the global economy. 

    Continue reading
  • 381,000-plus Kubernetes API servers 'exposed to internet'
    Firewall isn't a made-up word from the Hackers movie, people

    A large number of servers running the Kubernetes API have been left exposed to the internet, which is not great: they're potentially vulnerable to abuse.

    Nonprofit security organization The Shadowserver Foundation recently scanned 454,729 systems hosting the popular open-source platform for managing and orchestrating containers, finding that more than 381,645 – or about 84 percent – are accessible via the internet to varying degrees thus providing a cracked door into a corporate network.

    "While this does not mean that these instances are fully open or vulnerable to an attack, it is likely that this level of access was not intended and these instances are an unnecessarily exposed attack surface," Shadowserver's team stressed in a write-up. "They also allow for information leakage on version and build."

    Continue reading
  • A peek into Gigabyte's GPU Arm for AI, HPC shops
    High-performance platform choices are going beyond the ubiquitous x86 standard

    Arm-based servers continue to gain momentum with Gigabyte Technology introducing a system based on Ampere's Altra processors paired with Nvidia A100 GPUs, aimed at demanding workloads such as AI training and high-performance compute (HPC) applications.

    The G492-PD0 runs either an Ampere Altra or Altra Max processor, the latter delivering 128 64-bit cores that are compatible with the Armv8.2 architecture.

    It supports 16 DDR4 DIMM slots, which would be enough space for up to 4TB of memory if all slots were filled with 256GB memory modules. The chassis also has space for no fewer than eight Nvidia A100 GPUs, which would make for a costly but very powerful system for those workloads that benefit from GPU acceleration.

    Continue reading
  • GitLab version 15 goes big on visibility and observability
    GitOps fans can take a spin on the free tier for pull-based deployment

    One-stop DevOps shop GitLab has announced version 15 of its platform, hot on the heels of pull-based GitOps turning up on the platform's free tier.

    Version 15.0 marks the arrival of GitLab's next major iteration and attention this time around has turned to visibility and observability – hardly surprising considering the acquisition of OpsTrace as 2021 drew to a close, as well as workflow automation, security and compliance.

    GitLab puts out monthly releases –  hitting 15.1 on June 22 –  and we spoke to the company's senior director of Product, Kenny Johnston, at the recent Kubecon EU event, about what will be added to version 15 as time goes by. During a chat with the company's senior director of Product, Kenny Johnston, at the recent Kubecon EU event, The Register was told that this was more where dollars were being invested into the product.

    Continue reading
  • To multicloud, or not: Former PayPal head of engineering weighs in
    Not everyone needs it, but those who do need to consider 3 things, says Asim Razzaq

    The push is on to get every enterprise thinking they're missing out on the next big thing if they don't adopt a multicloud strategy.

    That shove in the multicloud direction appears to be working. More than 75 percent of businesses are now using multiple cloud providers, according to Gartner. That includes some big companies, like Boeing, which recently chose to spread its bets across AWS, Google Cloud and Azure as it continues to eliminate old legacy systems. 

    There are plenty of reasons to choose to go with multiple cloud providers, but Asim Razzaq, CEO and founder at cloud cost management company Yotascale, told The Register that choosing whether or not to invest in a multicloud architecture all comes down to three things: How many different compute needs a business has, budget, and the need for redundancy. 

    Continue reading

Biting the hand that feeds IT © 1998–2022