Every version of SQL Server 2016 now gets its full feature set

The change of course is a result of low usage

Microsoft packed SQL Server 2016 with new advanced features that are supposed to help it compete with a host of other database software. But some of the advanced capabilities in the relational database software were restricted to the most expensive Enterprise edition. That's about to change.

The first service pack for SQL Server 2016 will give developers a consistent set of features across the Express, Standard and Enterprise editions. That means it's possible to build an app that relies on a feature like in-memory OLTP and test it with the free Express edition, then use the same code with a SQL Server 2016 Enterprise edition database.

Starting Wednesday, developers will only need to pay for the more expensive versions of SQL Server 2016 if they need additional performance, because different versions restrict what sort of hardware people can use. In order to get the most power out of SQL Server, people will still need to pay for the Enterprise edition.

Still, this goes to show the competitive pressure in the relational database market. Microsoft has to fend off both public cloud competitors, open source alternatives and other on-premises vendors. It's good news for customers who want to have a consistent programming experience, without paying for an Enterprise license.

Microsoft General Manager Rohan Kumar said during a press roundtable that the move was driven by reduced usage of the advanced features.

The decision has been welcomed by customers.

"With SQL Server 2016 SP1, we can run the same code entirely on both platforms and customers who need Enterprise scale buy Enterprise, and customers who don’t need that can buy Standard and run just fine," Nick Craver, the architecture lead at online programmer-community Stack Overflow, said in a press release. "From a programming point of view, it’s easier for us and easier for them.”

The release is part of Microsoft's massive Connect news avalanche. The company also unveiled its first technical preview of SQL Server on Linux, which will allow developers to try out Microsoft's relational database service on the popular open source operating system.

Join the PC World newsletter!

Error: Please check your email address.

Our Back to Business guide highlights the best products for you to boost your productivity at home, on the road, at the office, or in the classroom.

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Blair Hanley Frank

IDG News Service
Show Comments

Essentials

Microsoft L5V-00027 Sculpt Ergonomic Keyboard Desktop

Learn more >

Lexar® JumpDrive® S57 USB 3.0 flash drive

Learn more >

Mobile

Lexar® JumpDrive® S45 USB 3.0 flash drive 

Learn more >

Exec

Lexar® Professional 1800x microSDHC™/microSDXC™ UHS-II cards 

Learn more >

HD Pan/Tilt Wi-Fi Camera with Night Vision NC450

Learn more >

Audio-Technica ATH-ANC70 Noise Cancelling Headphones

Learn more >

Lexar® JumpDrive® C20c USB Type-C flash drive 

Learn more >

Budget

Back To Business Guide

Click for more ›

Most Popular Reviews

Latest News Articles

Resources

PCW Evaluation Team

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Ed Dawson

HP OfficeJet Pro 8730

As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.

Michael Hargreaves

Windows 10 for Business / Dell XPS 13

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Aysha Strobbe

Windows 10 / HP Spectre x360

Ultimately, I think the Windows 10 environment is excellent for me as it caters for so many different uses. The inclusion of the Xbox app is also great for when you need some downtime too!

Mark Escubio

Windows 10 / Lenovo Yoga 910

For me, the Xbox Play Anywhere is a great new feature as it allows you to play your current Xbox games with higher resolutions and better graphics without forking out extra cash for another copy. Although available titles are still scarce, but I’m sure it will grow in time.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?