Friday, April 25, 2014

Web and Business editions of Azure SQL Databases will be replaced soon

As of today there are two editions of SQL Azure databases you can create in the Windows Azure portal: 1GB for WEB edition and 10 to 150GB in the BUSINESS edition. This is going to change so that you can choose the edition that suits your business.

The Web and Business editions will be replaced within a year with three levels tailored and better suited to business needs. You do not need to wait for a year as it is already in Preview.
The objectives were made clear in this email notice (quote):

New service tiers

In response to customer feedback, Azure SQL Database is introducing new service tiers to help you more easily innovate with cloud-designed database workloads. The new tiers help deliver predictable performance across six performance levels for lightweight to heavyweight transactional application demands. Additionally, the new tiers offer a spectrum of business continuity features, a stronger uptime service-level agreement (SLA), larger database sizes for less money, and an improved billing experience.

  •    Basic: Designed for applications with a light transactional workload. Performance objectives for Basic provide a predictable, hourly transaction rate.

  •    Standard: Standard is the go-to option for getting started with cloud-designed business applications. It offers mid-level performance and business continuity features. Performance objectives for Standard deliver predictable, per-minute transaction rates.

  •    Premium: Designed for mission-critical databases, Premium offers the highest performance levels and access to advanced business continuity features. Performance objectives for Premium deliver predictable, per-second transaction rates.

I tried to create a Basic tier database minutes ago (4/24/2014) but the interface still shows Web and Business:

I think there is a Preview portal to which I have to go....

PowerShell Pro Tools is a Visual Studio Community 2017 extension that you can try free

I see there is at least one extension, PowerShell Pro Tools that you can download. You can find it in the Visual Studio Community 2017...