Microsoft Synchs Azure With SQL Server - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management
News
10/28/2010
06:56 PM
Connect Directly
Twitter
RSS
E-Mail
50%
50%

Microsoft Synchs Azure With SQL Server

SQL Azure in the cloud now synchronizes tables or entire databases with SQL Server on premises, removing a developer headache.

Microsoft has moved to counter shortcomings in its Azure cloud environment and add “building block” services as it strives to keep Windows developers engaged in its version of cloud development. Given its already large workbench of developer tools, it’s starting to make it simpler to develop applications that function as hybrid business processes -- part on premises, part in the cloud. A key part of that move is to get SQL Azure in the cloud to function like SQL Server on premises.

To do that, it made SQL Azure reporting synonymous with SQL Server reporting. SQL Server reporting tools can now be used to build reports that draw on information in SQL Azure in the cloud or use SQL Azure to build reports that will be embedded in an application. SQL Azure Reporting is now available in customer technology preview, said Burley Kawasaki, senior director of product management for SQL Azure, AppFabric and Dallas.

Likewise, SQL Azure Datasynch is now in its second customer technology preview. Datasynch enables tables in SQL Azure to be synchronized with tables in SQL Server, and vice versa. Whole databases can be synchronized as well. In the past, there were sufficient differences between the two systems to prevent most developers from attempting to synchronize tables.

Microsoft made the announcements Thursday at its annual Professional Developers Conference, which was itself more of a cloud event. Regular attendees showed up at Microsoft’s Redmond, Wash., campus, instead of Los Angeles, where the event is usually held. Many other developers were able to follow the proceedings online as a virtual event.

Both changes mean developers with relational database skills no longer need to learn the exceptions and special conditions that rule SQL Azure vs. SQL Server.

“Before you couldn’t use temporary tables in the cloud. There were a half dozen things to watch out for,” said Shaun McAravey, CTO of NVoicePay, an electronic invoice paying service in Portland, Ore., for small and medium business. NVoicePay is an Azure customer. Microsoft in effect “has put SQL Server in the cloud,” he said in an interview.

Another building block service is the technology preview of Azure Caching service, which lets applications store frequently used data and business logic in RAM for faster operations.

Azure didn’t use to give end users control over a virtual machine sent to the cloud, the way Amazon’s EC2 does. Now it’s offering VM Role, or a way to d to allow an end user to set policies to govern the operation of a virtual machine in Azure. “It’s as if you were managing that VM on your own premises,” said McAravey.

McAravey wants to concentrate on delivering payment services to small and medium business, not building out a data center. He still needs to keep his customer’s personal and financial account information on premises. PCI standards don’t allow for it to be sent off to the cloud.

But Azure now has Enhanced Access Control, which allows McAravey to let his customer use their own Active Directory systems instead of requiring them to post user names and log-ins to his identity system. Likewise, that frees him from update chores when a customer employee leaves and the boss wants a name erased from the system immediately. Customers can now do it themselves.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Commentary
Why It's Nice to Know What Can Go Wrong with AI
James M. Connolly, Editorial Director, InformationWeek and Network Computing,  11/11/2019
Slideshows
Top-Paying U.S. Cities for Data Scientists and Data Analysts
Cynthia Harvey, Freelance Journalist, InformationWeek,  11/5/2019
Slideshows
10 Strategic Technology Trends for 2020
Jessica Davis, Senior Editor, Enterprise Apps,  11/1/2019
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Getting Started With Emerging Technologies
Looking to help your enterprise IT team ease the stress of putting new/emerging technologies such as AI, machine learning and IoT to work for their organizations? There are a few ways to get off on the right foot. In this report we share some expert advice on how to approach some of these seemingly daunting tech challenges.
Slideshows
Flash Poll