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.

learn more… | top users | synonyms

2
votes
2answers
31 views

Add MS SQL Server to virtual machine in Azure

I'm trying to get TDE in Azure. I read that it's possible only on a virtual machine. I built the virtual box, but didn't add SQL Server when it was created. Can I just install SQL or will I have to ...
0
votes
0answers
21 views

Domain Alias for Azure Databases

I have 3 databases on Azure's cloud, all with domains names such as xxxxxxxx.database.windows.net. Would it be a bad idea to create domain name aliases for all 3, things such as: database.domain.com ...
3
votes
1answer
578 views

How to change name for administrator login on azure sql server

I have myserver.database.windows.net with administrator login John. I'd like to change it to Peter. It is possible, if so, how ? Alter which works with local sql server, doesn't work here ALTER ...
1
vote
1answer
219 views

SQL Server Stored procedures run very slowly after a while

We have an ASP.Net application with a report page that runs several stored procedures. We have a problem with a production system where the report runs so slowly that it times out when the user ...
0
votes
2answers
286 views

Bi-directional synchronization between local SQL Server 2005 and a SQL Azure using SQL Data Sync

I need to synchronize an Sql Server 2005 database in an SQL Azure database. In other posts I've read that I can do this using Sql Data Sync but I don't know if SQL Data Sync can make the ...
1
vote
1answer
108 views

Creating SQL Azure login for single database

I want to create separate logins for each database we create on a SQL Azure database server which only have read / edit permissions for a single database and do not have drop permissions, and to ...
0
votes
0answers
15 views

Azure Database Sync with warning on row update

To create a real time backup DB in Azure, I have used the Azure sync group. What I have noticed is that if I edited one of the rows in any table (let's say, the customer's name) , I receive the ...
20
votes
1answer
11k views

How can I alter an existing Primary Key on SQL Azure?

I want to modify an existing primary key on a SQL Azure table. It currently has one column, and I want to add another. Now, on SQL Server 2008 this was a piece of cake, just did it in SSMS, poof. ...
0
votes
0answers
36 views

What happens to the database structure when i add a nonclustered index

Our team is working for a while now with Azure SQL. After a lot of trying , we managed to add a sync group between the main DB and the backup one. Of course, this means that for every change in the ...
0
votes
1answer
120 views

Azure SQL Database “Login failed for user” in application, but works fine in SSMS

I wanted to try out the contained database users feature on Azure SQL Database V12, but I'm having a problem authenticating that seems odd to me. I created a database called Classifier. I added my ...
2
votes
1answer
124 views

How do I set up Azure Sql Server to have multiple instances?

We are setting up a new SAAS application on Azure and while we have used Azure before, not at this level of multiple apps, etc. We plan to have both a web app and a cloud app in both a US and EU ...
3
votes
1answer
2k views

Azure SQL Administrator Can't Access Master Database

I created an SQL server and database. I can log in to the database manage page with my administrator account, and manage the database I created, but when I try to look at the master database, it says: ...
8
votes
6answers
3k views

How can I profile SQL Azure?

I am writing a web site that uses SQL Azure heavily. However, it is painfully slow. Is there an easy way to profile the live SQL Azure instance?
2
votes
1answer
51 views

What is limiting the batch requests per sec

We have a newly created azure sql server 2014 instance. The specs for the server are as follows Pretty bare bones I know. Since this is just a testing server, we have opted to set up the data files ...
1
vote
0answers
41 views

Measure SQL Azure Transaction Rate

We are on SQL Azure v12 Standard/S2 Service Tier and are not satisfied with the performance so I am trying to measure where the bottleneck is. I realize that we could be hitting the limits of the S2 ...
0
votes
1answer
123 views

Is there a way to get an event when there's a change in a table?

Using Azure Sql Server, and in C# if that's relevant, is there a way to get an event when data in specific table changes? In one table we need an event if any column changes in a row. In a 2nd table ...
2
votes
3answers
820 views

Is it OK to create hundreds of databases in SQL Azure versus one big one and run the risk of deadlocking

I need to create highly scalable solution - where field devices in thousands of sites are delivering data in real time to a back end system, and SQL Azure seems to fit the bill nicely in terms of ...
0
votes
2answers
76 views

is there a way to configure Azure SQL databases for high-insert scenarios?

I'm working on a legacy application that uses SQL Server as a backing store. There's a portion of the app that does a ridiculous amount of inserts to a single table. Re-architecting this portion of ...
2
votes
2answers
3k views

SSMS 2014 “Deploy Database” feature has old SQL Azure settings

I'm attempting to test-deploy an existing SQL Server 2005 database into SQL Azure using the "Deploy Database to Windows Azure SQL Database" task in SQL Server Management Studio 2014. When the ...
0
votes
1answer
28 views

Entity Framework: Automatic migration failed on huge DB

I am using EF 6.1.1, and DB has three million records and migration has to change the precision of a coulumn of type decimal. And the migration timeout window set to max value, CommandTimeout = ...
2
votes
1answer
48 views

“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, not I don't have the "Manage" option anymore. I ...
0
votes
1answer
80 views

TSQL Copy an existing database

I am learning how to administrate MS Sql server 2012, come cross a question and its suggested solution for copying an existing database for different name. Administer a windows azure sql database ...
2
votes
1answer
584 views

Best patterns for encrypting database columns/tables in SQL Azure

Azure SQL doesn't support many of the encryption features found in SQL Server (Table and Column encryption). What is the best practice for doing application level encryption into a database that ...
2
votes
1answer
3k views

Connecting to sql azure from ssms throw exception 'sys.configurations'

Connecting to Sql Server Azure from MSSQL Server MGMT Studio, following exception occures : Cannot connect to xxxxxxxxx.database.windows.net An exception occured while executing a Transact-SQL ...
1
vote
1answer
82 views

my azure sql database is not connecting with SSMS 2014

The firewall contain my IP in valid list but I am still getting error in connection. I tried the command C:\Users\MianAsbat>SQLCMD -U username -P password -S and got the following response. I ...
0
votes
1answer
95 views

I keep getting an error 10060 trying to connect object explorer in Visual Studio 2013 to an Azure Database

Using Win 7, Visual Studio 2013, (or Sql management tool 2014) This is for a class and its all software on the trial period. In Visual Studio server explorer - I can connect to the Azure Server I ...
2
votes
1answer
142 views

Improve SQL Performance with LIKE '%ABC%' QUERY

I know that using a LIKE '%ABC%' query will not use indexes and there is little that can be changed to the query to improve this, however what can do to make execution quicker? At this stage we ...
0
votes
1answer
64 views

how can I see the arguments passed to a stored proc on Azure?

The query that I'm using: SELECT deqs.execution_count, deqs.last_execution_time, dest.objectid, SUBSTRING(dest.[text], (deqs.statement_start_offset/2)+1, ...
0
votes
2answers
320 views

Access 2003 (SQL Server 2000) migration to SQL Azure

As my old Windows 2003 RAID controller started throwing errors, I am seriously thinking about switching current Access 2003 (adp/ADO) clients to use a Windows SQL Azure solution, in place of current ...
0
votes
0answers
61 views

Composite primary key in Multi-tenant sql server database

I'm building a multi-tenant app (Single database, single schema) using Asp Web Api, Entity Framework and Sql Server/Azure database. This app will be used by 1000-5000 customers. All the table will ...
0
votes
0answers
52 views

Which of sys.dm_exec_query_stats columns should I pay most attention?

I'm trying to tune my database and currently staring into sys.dm_exec_query_stats (with actual queries): SELECT SqlText.text, * from sys.dm_exec_query_stats CROSS APPLY ...
6
votes
1answer
1k views

SQL-08S01 error in FreeTDS/Azure when executing stored proc for a few minutes from Linux (but not from Windows)

I get this error on Linux (Ubuntu and CentOS) when executing a stored proc from Perl/DBI/ODBC/FreeTDS to SQL Azure: [unixODBC][FreeTDS][SQL Server]Read from the server failed (SQL-08S01) I don't ...
0
votes
0answers
105 views

How can I perform reads and writes in the same transaction?

I'm trying to implement transactions in my application. I'm just trying to implement it like the example shown in the BeginTransaction() documentation. Public Shared Sub Process(wwid As String, ...
0
votes
0answers
193 views

Query to match exact column or partial data of the column: SQL Server / Azure

Bit confused on how to get it work better than what has been done now. I am new, apologies if I'm asking for too much. I have trip details which have from and to locations stored in database from ...
0
votes
0answers
16 views

Does SQL Azure Data Sync conflicts get logged?

I have successfully synced my SQL Azure DB with my on-premise DB. The log shows the following: Sync completed successfully in 1884.76 seconds. Upload: 405323 changes applied Download: 0 ...
-1
votes
1answer
86 views

SQL Server credentials - Maximum Password size

What's the maximum password size I can get on SQL Server 2012/2014? I was unable to find this information online. I mean SQL Server credentials itself, not passwords inside tables. Thanks a lot
1
vote
1answer
220 views

Unable to ping/connect to azure sql server from sql server management studio

I created a database in azure and assigned a new server to it. I entered my ip address in the firewall and tried to connect to the server in Sql Server Management Studio but no success. I tried to ...
0
votes
0answers
197 views

Benchmarking Azure SQL database VS. SQL Server database on VM in Azure

We are testing Azure options and would like to compare an Azure database of P1 level to a SQL Server database on VM in Azure. My question would be how big (how many CPUs and memory) should be the ...
0
votes
0answers
27 views

Azure Database - Missing dbmanager role - Database Migration

I am attempting to: To copy your database to a new database on a different logical server as detailed on this page: How to: Use Database Copy (Azure SQL Database) I have made sure I have the ...
0
votes
0answers
660 views

Azure SQL slow to delete 30K records

I have SQL Database (Business Standard, with 10GB plan). from last 10 days we are facing "Timeout" while deleting the records in bulk. We have been delete 50-60K record with easy till end of Jan 2015. ...
6
votes
3answers
6k views

EF Code First uses nvarchar(max) for all strings. Will this hurt query performance?

I have some databases created using Entity Framework Code First; the apps are working and in general I'm pretty happy with what Code First lets me do. I am a programmer first, and a DBA second, by ...
2
votes
0answers
34 views

Performance of bitwise operators on byte column vs individual bit columns

I'm designing a database schema at the moment, but have a performance query. Our table needs to have (at least) two flags, or boolean values. We can call these IsComplete and IsExportable. The ...
0
votes
2answers
817 views

BULK INSERT not supported

I have a text file, which I want to insert into a table in my database. My query looks like this: BULK INSERT myDepartment FROM 'C:\myDepartment-c-t.txt' WITH ( DATAFILETYPE = 'char', ...
1
vote
0answers
90 views

Replicating Multiple SQL Servers to Azure and Accessing From Web Apps

I am setting up quite a large system with multiple servers (MS SQL Server), and Office 365 Access DB, and a custom SharePoint web app for reporting purposes. The system should work as follows: Each ...
1
vote
1answer
979 views

SQL Azure: Drop Constraint and Index

This may be a stupid question, but I'm not a DBA and just wanna make sure of what I'm doing before I make a mistake. Here is my question: When dropping Constraints, are their indexes dropped as well? ...
1
vote
0answers
68 views

Make the SQL Database manage CRUD operations

Is it possible to have a client app send a transaction of INSERTs to a table. Then have the table triggered somehow to run through the inserts and either INSERT the row or UPDATE an existing row? If ...
1
vote
1answer
299 views

Index rebuild log growth

How much log index rebuild will generate.I remebered reading rebuild index should generate same amount of log file as table size.But my tests are showing otherwise.We need this estimate since we are ...
0
votes
2answers
195 views

Determine whether there is any blocking while deleting large number of records [closed]

I would like to know whether there is any way to determine why it is taking too much time say 3 minutes for deleting 50K records from a database hosted in Sql Azure. I have clustered index on primary ...
1
vote
2answers
328 views

Will a non-clustered index on a column with covering index on all the columns of table affect the Delete statement Records)?

I am trying to delete thousands of records say 35K from a table which consists like 10 million records. Delete * from Table where ScenarioID=859 I have also tried bulk deletion DECLARE ...
3
votes
2answers
427 views

use an Index correctly to optimize queries

I have an SQL database with millions of records and when I'm querying the data like select * from ActCosts where ScenarioID= 456 The tables has 1,323,718 rows and it gives me like 50,000+ rows ...