Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [azure-sql-database]

Azure SQL Database is a relational database-as-a-service from Microsoft. This tag is for questions about Azure SQL Database, NOT SQL Server hosted in an Azure VM (use azure-vm).

Azure SQL Database currently offers Basic, Standard, and Premium service tiers. The Web and Business tiers will be retired September 2015.

Product Home Page

974 questions
14
votes
1 answer

Is this a bug or I did something wrong when I created the table?

I have a table in a Azure SQL Instance (12.0.2000.8) and I found this weird behaviour when I query it. The column is defined as Integer, but it does not respond to the "WHERE" filters, also casting to varchar return weird results. It only happens…
Desenfoque
  • 243
  • 1
  • 6
8
votes
2 answers

How to clear the data buffer cache for an Azure SQL database

I want to do some performance testing on an Azure SQL database. For SQL Server, I've read that DBCC DROPCLEANBUFFERS can be used to clear the data buffer cache, and DBCC FREEPROCCACHE can be used to clear the execution plan cache. But neither are…
mtmacdonald
  • 421
  • 2
  • 4
  • 6
7
votes
1 answer

"Manage" option vanished on portal for Azure SQL database

I had a database which I deleted and it used to have a "Manage" option which would open the online sql management portal. I created a new database, now I don't have the "Manage" option anymore. I cannot connect when I try to go to the same URL with…
Emre K.
  • 271
  • 2
  • 6
6
votes
2 answers

How to resume Azure serverless SQL Server from pause

I created a serverless sql on azure and didn't use it for few weeks. Now when I go back to it, I found it's in Pause status. But searching the azure dashboard, I can't find any way to resume it. When I google this topic, all result are talking about…
Circle Hsiao
  • 445
  • 5
  • 18
5
votes
3 answers

How to create a JOB for Azure SQL?

I'm trying to create some jobs for our Azure servers (for sql databases). I'm reading about it on the internet and tried to find some questiosn here with no success. Theres a link saying I need to download something in the market place. I can't even…
Racer SQL
  • 7,386
  • 14
  • 69
  • 128
5
votes
4 answers

Copy Azure SQL Database Between Azure Subscriptions

Getting straight to the point, is this even possible? I have successfully copied an Azure SQL database within the same subscription. In doing so, I kept it simple by copying the database to the same server (within the subscription). I used the…
Jason Richmeier
  • 201
  • 1
  • 3
  • 5
5
votes
2 answers

LOG_RATE_GOVERNOR Wait Stat

I'm noticing this wait stat on my Azure SQL database, and I've never seen it before. I've tried Googling this wait stat but haven't been able to come up with any good information on what this is, although I saw a couple mentions of it possibly being…
Randy Minder
  • 2,002
  • 4
  • 21
  • 39
4
votes
1 answer

Linked server to SQL Azure very slow

I can use the Management studio to connect directly to my Azure SQL database and execute this query: select * from DB.dbo.DSeries where instrument='name1' and it works really fast. But if I create a linked server (called "WF") in my local server…
Nestor
  • 163
  • 2
  • 5
4
votes
1 answer

Pricing of databases in Azure

I am a little bit confused about pricing for Data in Azure. I found on one MS Blog that 50GB has a price of $125. Missing part for me is, if I have needs only for a database in the cloud: Do I pay only the amount of $125? Or I have to pay…
adopilot
  • 2,423
  • 8
  • 31
  • 46
4
votes
1 answer

Copy SQL Azure Hyperscale

I wanted to try SQL Azure Hyperscale, after I selected it seems I no longer have the option to move out of it. If I try, I get this message "databases cannot be moved out of hyperscale tier". The Copy option is not available and restore does not…
kadourah
  • 43
  • 2
4
votes
1 answer

SQL Azure: More Intermittent Timeouts

(also posted on MSDN forums http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/79058c06-d3c5-4073-8571-c29d1f43f7ae) Hi guys, We have a set of 5 online auction systems running on Windows Azure & SQL Azure. Each system consists of a…
ilan
  • 41
  • 1
  • 2
3
votes
1 answer

SQL Azure Performance of new servers

I have a fairly small database ~200MB which when running in the web edition of SQL azure is lightning fast. I've switched it to the basic edition and all of a sudden a group of queries which took less than 1 second to execute is now taking ~25…
Andrew Newland
  • 133
  • 2
3
votes
1 answer

Azure Database Size Same Before and After Deleting Most of the Rows

I have a database hosted on Azure which is showing as nearly full, it is at 1017MB/1024MB. The table contained around 27000 rows, I have deleted 20000 of those rows to try and free up space, however the amount of available space is the same as…
Ben Sharpe
  • 131
  • 1
  • 5
3
votes
1 answer

How To Grant View Definition of Object in SQL Azure

The tsql syntax throws an error about "view" in SQL Azure, but functions on SQL Server: GRANT VIEW ON OBJECT dbo::foo TO [bar] Can access be granted in SQL Azure to view the definition of an object outside of db_owner?
UserzRWithUz
  • 33
  • 1
  • 3
1
2 3 4 5 6