Our application is heavily dependent on it. So this is a blocker right now.2,953 votes
Free text search is something that we are working on, although not in the near term horizon.
The ability to query (read-only) data from a difference database or linked server. This will allow to reference (join) some tables from the source database and build views that uses two or more SQL Azure databases.952 votes
We are looking to better understand what customers are trying to do here. Are folks looking for cross DB query, or cross DB movement of data, or fan-out query. I’d love to hear the scenarios that you’re looking at. Please email me at firstname.lastname@example.org if you’d like to help us define how we move forward in this space.
Enabling TDE would go a long way to help placate business sponsors concerned about their data being housed in Microsoft's datacenters. Even though the cloud is arguably more secure than doing it yourself, turning on TDE would provide a warm fuzzy feeling to those not comfortable with the concept.907 votes
We have several improvements around encryption, including data at rest and during use. Today I don’t have a timeframe that I can share.
Thanks, we hear you loud and clear. We are working to bring Analysis Services to SQL Azure. Right now I can’t give you a date.
We understand the need for CLR stored procedures especially from a SQL Server compatibility perspective. This is an area of active work, although I don’t have a time-frame that we can share today.
In a DB-as-a-service model such as Azure SQL database, DMVs are the mechanism today to monitor what’s going on under the covers. We are adding DMVs as we expose more of the multi-tenant system functions. http://msdn.microsoft.com/en-us/library/windowsazure/ff394114.aspx has more details on DMVs available today.
We are looking at additional possibilities in the future to expose a tracing mechanism in the future.
1. Create a new Database.
2. Check an "Enable OData data services"
3. Get a non-code OData service over the database311 votes
I’d love to hear more about the scenarios that your looking for here. We are actively working in the DB encryption space including encrypted columns, a cloud equivalent of TDE. Please send me email with your scenarios to email@example.com
I want to utilise LINQ and TransactionScope in my web roles and DTC support in SQL Azure would solve this problem275 votes
We understand that there are a class of apps that could benefit from transaction coordination with SQL Database. We hope to look at this more in the future, however we don’t have immediate plans to ship a DTC for SQL Database. Customers should use eventual consistency techniques in the absence of DTC.
Service Broker should be available in Windows Azure.274 votes
Today we don’t have a cloud equivalent of SQL service broker outside of either service bus or SQL Server in a VM. I’d love to understand the scenarios that you have in mind. Please send me email at firstname.lastname@example.org if you’d like to continue the conversation.
Storing blobs in the database is fairly pointless when you have a dedicated blob store. Implement the FILESTREAM protocol to store blobs in a user's azure storage227 votes
We understand the scenario here and would love to enable. While this isn’t something that’s on the road map, it is something that we are working on.
Following the guidance from
I attempted to rebuild a heavily fragmented index using Online=ON:
ALTER INDEX ALL ON [Backups] REBUILD WITH(ONLINE = ON)
And received the following error:
'ONLINE INDEX DDL WITH LARGE OBJECT' is not supported in this version of SQL Server.
My table contains a varbinary(max) field. This is a serious flaw. Please fix.197 votes
We are working on a number of scenarios that relate to index rebuilding, and index rebuilding with large objects. We’d like to here more about the scenarios. email@example.com
Add in Sql 2008 Change Tracking177 votes
We’d like to here more about the scenarios that you’re thinking about here, firstname.lastname@example.org
I understand that SELET INTO is not supported in SQL Azure standard tables because that will create a new table that doesnt have the clustered index needed to replicate the data correctly.
However, when creating tables in the tempdb you can create tables without a clustered index - and so the SELECT INTO command should be able to be used when the output table is stored in the TempDB.
99% of all my SELECT INTO are used for temporary tables (to increase speed in reporting and data processing)138 votes
We understand this issue, but have no immediate plans to address.
I have been using the SQL Azure Business databases but the site is so busy and some core stored procedures have calculations involved that it has been unable to cope. I experimented with S1, S2 & P1 and have since upgraded to P1. Unfortunately I have seen little to no benefit of this - despite the 8x higher cost! S2 was nowhere near good enough.
Please reconsider the resources allocated to these new database tiers as they look like a disaster waiting to happen!87 votes
Thanks for your feedback here. The new service tiers are in preview and we are carefully listening to customer feedback.
One of our goals for the new tiers is to have both great price and great performance against our competitors and against SQL Server in an Azure VM. Another goal is to have predictable performance where customers can rely on the service tier and performance level, and other customers don’t impact them.
It’s hard to compare directly the performance of Web/Business and the new service tiers, performance in Web/Business can be great, and up to P2 levels of performance. It can also be not great to put it mildly.
Our end goal is to have great price and performance against a key set of cloud OLTP provides. If you’d like to engage more, please send me email at email@example.com
Allowing data compression would make it easier to fit within a 1GB/10GB limit and help improve I/O performance on large datasets, not to mention it helps with T-SQL/SQL Server compatibility.81 votes
We understand the issue of database size and SQL Database.
This could be done with the future cloning technique or perhaps a more sophisticated one?80 votes
We understand the scenario, and are working with the Windows Azure website team. We hope to be able to address this in the future.
We would like to have an indicator that tells us how close our azure services are to being throttled. We don't need specific throttle metrics, but a general indicator (red/yellow/green) for each azure service (Sql Azure, Table storage, Blob Storage, etc.) that can be throttled.
With this information, we can scale down our usage of non-essential threads in favor of allowing mission-critical threads to continue processing rather than getting stopped cold when they are throttled (even with a retry policy, you're stopped/on hold until the throttle is removed).72 votes
We understand the scenario and are working on portal improvements. We don’t have a detailed time-frame to share today. Please stay turned.
It would be great to have the ability to manipulate identity seeds on SQL Azure, like we have in other version of SQL Server.64 votes
We understand the scenario and are working on a solution here. Unfortunately we don’t have more details to share today.
- Don't see your idea?