November 17, 2009

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.

Close

On Twitter now

Software as a service

Powered by Twitter
additional resources
White Paper - How to Improve Delivery of Advanced Web Applications

White Paper

Virtual Workforce: The Key to Expanding The Business While Cutting Costs

Get the independent advice and expertise you need to support a virtual workforce.

Go inside:
The three-step approach to making a virtual workforce a reality.
The four flavors of client virtualization technologies.
The three key initiatives that solve IT challenges.
Download now »
White Paper: Successfully Secure Your Wireless LAN With Wi-Fi firewalls.

White Paper

Addressing Linux Threats Leveraging Fewer Resources

The increase in Linux popularity has increased the frequency and sophistication of malware attacks. Read this 2 page white paper now to learn how you can protect your Linux environment with real-time protection that is certified by all major Linux vendors.

Download now »
White Paper - The 2009 Handbook of Application Delivery

White Paper

The 2009 Handbook of Application Delivery

Ensuring acceptable application delivery will become even more difficult over the next few years. As a result, IT organizations need to ensure that the approach that they take to resolving the current application delivery challenges can scale to support the emerging challenges. This handbook elaborates on the key tasks associated with planning, optimization, management and control and provides decision criteria to help IT organizations choose appropriate solutions.

Download now »
White Paper - Is Your Backup System Outdated?

White Paper

Mid-range Storage Considerations

A common misconception is that mid-range storage requirements are dramatically different than that of a larger enterprise. Mid-range storage users may require less capacity, but they have similar functionality and management requirements. This ESG paper examines mid-range storage needs and reviews a new solution that adjusts size while retaining value, performance and functionality.

Download now »

Sign up to receive InfoWorld Resource Alerts

Subscribe to the Cloud Computing Report Newsletter

Receive the latest cloud computing news and find out how to deliver it more effectively.

©1994-2010 Infoworld, Inc.