SQL Database
-
Need the ability to set a time zone per Azure sql database
We need to be able to set the timezone for an Azure sql or DW database. This should be a database option.
Now we are faced with changing all of our code which references getdate() and similar date functions.
We shouldn't have this extra difficulty in moving to a cloud database.495 votesPlanned for SQL DB- no time frame to share yet. Available in SQL Managed Instance
-
Change Data Capture
Allow Change Data Capture in SQL Azure
It has been available in SQL server since 2008, the jump to SQL Azure seems logical.
441 votesThis support is planned for SQL DB Managed Instances:
Thanks
-
Automatic Fail-over to secondary region similar to Global DocumentDB
Recently, Microsoft introduced a feature "Global DocumentDB database" along with "multi-homing APIs" which provides transparent & automatic fail-over to secondary database with no human intervention.
It will be helpful to have a similar feature for Azure SQL Database where users can enable Geo-Replication and will not have to worry about manual fail-over to secondary in case when Primary / master is unavailable
80 votes -
Cancel Updating database pricing tier on Azure Portal
Sometimes it would be good to cancel a scale event instead of letting it finish, then re-scaling back.
Examples include:
- Human error when creating scale event (Wrong DB, Wrong Size, etc).
- Scale event taking too long
- Changed mind37 votesThank you for your feedback. We are working to implement this functionality and will respond back one the public preview is available.
-
Azure database export fails when split_string is involved
Database compatabilty level 130.
Repro steps:
alter function dbo.tt
(@id varchar(max))
returns table
return
select
* from
dbo.string_split(@id,',') t
inner join
dbo.numbers n
on n.id=t.valueExport dacpac fails stating unresolved reference split_string,while the function itself works
25 votesThanks, we are working on a fix here.
Guy
-
21 votes
Thanks for the feedback, we are working on better compatibility between SQL Server and SQL Database in the table fragmentation area.
-
REST service for the enumeration of SQL Azure databases on a SQL Azure server.
Currently it is not possible to enumerate the databases inside a SQL Azure server, please add a REST service to query databases inside each server.
6 votesWe plan to expand support here shortly. Please stay tuned.
-
Add allowed IP - adresses functionallity
I am missing the management off allowed IP adresses. Please add this in the new portal!
1 voteWe hear you and we’ll make sure this isn’t left out for long.
Thanks,
Thao -
Missing Firewall option in new portal
I read in some documentation that I can set firewall options in the new portal. However, I can't find it anywhere in the new portal.
I had to switch to the old portal to allow my IP addrress access.1 voteI do see that the documentation here needs fixing (will submit this request to the content team):
https://azure.microsoft.com/en-us/documentation/articles/sql-database-configure-firewall-settings/
In the meantime, you can do the following:
If you’re not currently connected, connect to the Azure portal.
On the default blade, click SQL servers.
On the SQL servers blade, click the server on which to create the firewall rule.
You’ll see a blade with a Settings section and “Firewall” as an option.Thanks for submitting this feedback.
Best Regards,
Joe Sack
Principal PM, SQL Server and Azure SQL DB -
Need to be able to see % complete of a COPY
We had a COPY take an unusually long time during a go-live ( of course ). It was frustrating that we had no way to tell how the copy was proceeding. The view sys.dmoperationstatus is only good for seeing that there is a copy in progress, but it does not provide any other useful information.
Therefore, we need this view to be more useful AND/OR be able to see 'in progress COPY info' in the portal. The activity log is useless for this - it only shows the start.
1 voteThank you for your feedback. We are working to implement this functionality and will respond back one the public preview is available.
- Don't see your idea?