Microsoft adds access controls for SQL Azure online database

Companies will be able to define, enforce policies controlling who can see what data

Microsoft is creating technology to give businesses more fine-grained control over access to data stored in the company's upcoming SQL Azure database cloud service, a senior engineer said today. Code-named Vidalia, the technology will provide "trustworthy data collaboration for highly sensitive business data across disparate trust domains," said Microsoft technical fellow Dave Campbell in a talk at Microsoft's Professional Developers Conference 2009 (PDC09) in Los Angeles.

Translation: Companies will be able to define and enforce policies controlling who can see what data at a very detailed level.

[ Discover what's new in business applications with InfoWorld's Technology: Applications newsletter.  | Follow Infoworld's ongoing coverage of PDC 2009. ]

That will be through what Campbell called a "capability generation center" that will protect data inside the database (at rest) and when it's moving through the network (in motion).

Other features are coming to SQL Azure, which will go into production when Windows Azure does on January 1.

In the first half of next year, it will bring a "database clone" feature for administrators, said Tony Petrossian, principal program manager for SQL Azure.

By the second half, Microsoft plans to release continuous backup of SQL Azure databases. Users will be able to restore their databases to any point in time, he said.

Microsoft is also working on making it easier for users to grow and shrink their databases, so that they are not constricted in size or overpay for storage they don't need, Petrossian said.

Other related features include the ability to dynamically split or merge databases, and build tools to manage large groups of schemas across databases, he said, as well as query multiple databases at a time.

These improvements are aimed at both enterprise department users, as well as software-as-a-service (SaaS)-based resellers of SQL Azure, he said.

This story, "Microsoft adds access controls for SQL Azure online database" was originally published by Computerworld.


Copyright © 2009 IDG Communications, Inc.

How to choose a low-code development platform