SQL Azure Feature Voting on UserVoice

Publish non-scheduled provisioning outages in Dashboard feeds [updated]

2010-09-08T14:31:11+00:00

RSS 2.0 feeds occur for SQL Azure scheduled maintenance operations that affect provisioning but not for unscheduled problems that disable provisioning. See http://oakleafblog.blogspot.com/2010/09/sql-azure-portal-database-provisioning.html for more details.

Roger Jennings said:

My "SQL Azure Portal Database Provisioning Outage on 9/7/2010" post describes the consternation of SQL Azure users who were unable to provision databases on the morning of 9/7/2010 and couldn't determine the reason or when a fix might be forthcoming.

Publish non-scheduled provisioning outages in Dashboard feeds

2010-09-08T14:29:04+00:00

Roger Jennings suggested:
RSS 2.0 feeds occur for SQL Azure scheduled maintenance operations that affect provisioning but not for unscheduled problems that disable provisioning. See http://oakleafblog.blogspot.com/2010/09/sql-azure-portal-database-provisioning.html for more details.

To have Query wizard with the ability to find duplicates and unmatched queries as we have in Access

2010-09-03T12:54:13+00:00

Preetham suggested:
Ability to build simple, Unmatched, Duplicates query. If an interface is provided it will be good for non IT guys

Provide an easy or automatic methanism for horrizontal partitioning [updated]

2010-09-02T19:32:34+00:00

Just as Azure storage has accomplished, implement automatic partitioning. All the developer should have to provide is an optional PartitionKey

Rodney Willis said:

For hosting/developing multi-tenant applications, this is critical. The only real workaround is to create a new database for each customer.

Specify Firewall Exceptions by Host Name Resolution

2010-09-01T15:21:10+00:00

Eric suggested:
The current mechanism of specifying firewall exceptions is problematic for those without static IP addresses. Allowing permitted IP addresses to be specified by host name resolution would allow customers to use a dynamic DNS service and eliminate the need to manually update firewall rules when a new address is assigned.

Enable backups [updated]

2010-08-30T12:55:23+00:00

We need the ability to do backups. Just simple, standard backup files that we could create and download at the very least. It doesn't have to go directly blob storage or all these other suggestions. But we really, really need backups to use SQL Azure for production. Not data sync, not bcp, not SqlAzureMW -- just regular old sql server backups.

Roopesh Shenoy said:

Yeah, but it is a big change of mindset compared to how backups were handled earlier. Also we need backups to protect against user mistakes, data corruption due to application bugs, just a revert option that gives dbas a peace of mind :). Creating a new azure database everytime we want a backup is just not an option.

Full Management Studio Support [updated]

2010-08-30T10:52:50+00:00

Currently you can only run queries against SQL Azure databases. It would be good to get the rest of management studio working (object explorer etc.)

Roopesh Shenoy said:

Yeah im so happy this feature is added in R2.. :).. please close this, its done.

Full Management Studio Support [updated]

2010-08-30T03:57:53+00:00

Currently you can only run queries against SQL Azure databases. It would be good to get the rest of management studio working (object explorer etc.)

Dan Jones said:

This was added in SQL Server 2008 R2

Enable SQL Service Broker in SQL Azure [updated]

2010-08-28T08:10:02+00:00

Service Broker should be available in Windows Azure.

PL said:

Does Azure AppFabric Service Bus not meet the scenario requirements for those folks looking to use SErvice Broker?

Support full-text indexing [updated]

2010-08-27T12:18:50+00:00

Our application is heavily dependent on it. So this is a blocker right now.

Morten Fæster said:

The lack of this feature makes many companies reluctant to migrating to Azure.

Provide an easy or automatic methanism for horrizontal partitioning [updated]

2010-08-26T15:28:26+00:00

Just as Azure storage has accomplished, implement automatic partitioning. All the developer should have to provide is an optional PartitionKey

CuriousGeorge said:

This would be truly awesome. I wonder if this is too much to ask though?

developer version [updated]

2010-08-26T15:27:13+00:00

Provide a feature complete free version of SQL Azure for developers beyond Jan 2010

CuriousGeorge said:

I voted this up one just to indicate I'd like to make sure Microsoft continues to allow MSDN subscribers access to a free SQL Azure database 24/7/365. I would really like to see you up the ante by increasing it to say 3 5GB databases instead of the 3 1GB of today.

Enable backups [updated]

2010-08-26T15:23:49+00:00

CuriousGeorge said:

This is an awesome first step. Thank you SQL Azure team! The next obvious step would be to allow a true backup to blob storage. Then, taking that a step further it would fantabulous if those backups could then be restored to SQL Azure OR a local SQL Server.

Enable backups [updated]

2010-08-26T01:25:48+00:00

David Robinson (admin) responded:

We have started delivering on this and the first step, Database Copy, was just enable in SU4. This feature satisfies a large portion of backup scearios and provides online access to those copies.

Enable backups [is now started]

2010-08-26T01:25:48+00:00

Linked Server [updated]

2010-08-25T16:54:57+00:00

In our S+S scenario we definitely need to be able to create linked servers against a cloud DB.

Lukas Swom said:

yes this would be absolutely usefull!

Enable SQL Service Broker in SQL Azure [updated]

2010-08-24T23:53:01+00:00

Service Broker should be available in Windows Azure.

stakmur said:

Yes! This is my highest priority too.

Enable backups [updated]

2010-08-24T17:46:19+00:00

Bruno Alves said:

Backup/Restore and Blob fields would be extremely appreciated too.

Offer very small instance that is cheap (<$1 pm) as $10 pm is too much [updated]

2010-08-23T07:02:23+00:00

The motnhly costs for SQL Azure databases of $9.99 is too much for small applications for small business. Large companies/organisation may need large scalable implementation, but your small business doesn't necessarily need the scalability aspect and so a small (limited by size perhaps) instance at a cost of <$1 would be very beneficial - also good for developers and prototying.

Joannes Vermorel said:

I strongly agree, it would be top notch for multi-tenant apps, where each tenant gets a small DB. I would suggest 100MB instance at $1 / month.

Enable backups [updated]

2010-08-23T07:00:05+00:00

Joannes Vermorel said:

Snapshotting/Restore toward/from the Blob Storage would be extremely appreciated.

make Houston live

2010-08-16T21:55:55+00:00

Ashish suggested:
Despirately in need of this as SSMS requires corporate firewall rule changes to allow to connect to external SQL server and is a big hurdle...

Enable backups [updated]

2010-08-16T00:14:18+00:00

William said:

Deploying a new application to Amazon's EC2 and was considering SQL Azure until I found out there were no easy backups. I really want the scalability and managed environment of a cloud solution but this was a deal breaker. Now we're going to run MySQL - despite the fact we have to workaround some features it lacks - and Microsoft will get none of our money. I can't believe MS expects this to be any sort of real production solution without backups.

Support database mail

2010-08-13T23:59:38+00:00

Profiler for SQL Azure [updated]

2010-08-11T19:04:54+00:00

Herve Roggero said:

Profiler works by using server-side tracing stored procedures. Support for server-side tracing would be important for corporations interested in auditing data changes. Regarding performance I would like to point to an open-source project I created that helps filling the gap: enzosqlbaseline.codeplex.com. It can show you the number of packets returned, CPU consumption, Duration of statements and so on. However, SQL Profiler is critical for advanced troubleshooting needs.

CREATE/DROP XML INDEX [updated]

2010-08-10T16:03:26+00:00

I would need to create indexes over XML columns

umpah said:

xml indexes are probably too big, so it's a no go in sql azure the way things are now.

provide BIDS for VS2010 B2 [updated]

2010-08-10T15:47:11+00:00

Need BI dev system for V2010 B2 for SQL Azure.

Gordon Neuls said:

I agree, I was forced to adopt TFS 2010 for my projects and cannot fully integrate the new features of TFS without VS 2010. Working in multiple IDE's seems to be a step backward from where we were in 2008.

provide BIDS for VS2010 B2 [updated]

2010-08-10T15:46:59+00:00

Need BI dev system for V2010 B2 for SQL Azure.

Gordon Neuls said:

support SAFE CLR please

2010-08-10T09:44:31+00:00