Top "Azure-sql-database" questions

Azure SQL Database is a relational PaaS database hosted in Microsoft Azure.

Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto …

sql sql-server database sql-server-2008 azure-sql-database
The SELECT permission was denied on the object 'Users', database 'XXX', schema 'dbo'

I moved a database from SQL Server 2012 to Azure. I don't want to use the user master, so I created …

sql-server azure-sql-database
Optimal way to concatenate/aggregate strings

I'm finding a way to aggregate strings from different rows into a single row. I'm looking to do this in …

sql sql-server azure aggregate-functions azure-sql-database
Azure SQL Database "DTU percentage" metric

With the new Azure SQL Database tier structure, it seems important to monitor your database "DTU" usage to know whether …

azure azure-sql-database azure-storage azure-monitoring
How to re-create database for Entity Framework?

I have got into a bad state with my ASP.Net MVC 5 project, using Code-First Entity Framework. I don't care …

asp.net-mvc entity-framework azure azure-sql-database
How to view the roles and permissions granted to any database user in Azure SQL server instance?

Could you guide me on how to view the current roles/permissions granted to any database user in Azure SQL …

sql-server azure azure-sql-database
How to emulate a BEFORE INSERT trigger in T-SQL / SQL Server for super/subtype (Inheritance) entities?

This is on Azure. I have a supertype entity and several subtype entities, the latter of which needs to obtain …

sql-server tsql triggers azure-sql-database
How do I create a new user in a SQL Azure database?

I am trying to use the following template: -- ================================================= -- Create User as DBO template for SQL Azure Database -- ================================================= …

sql-server azure azure-sql-database
How do I copy SQL Azure database to my local development server?

Does anyone know how I can copy a SQL Azure database to my development machine? I'd like to stop paying …

sql-server azure azure-sql-database database-migration
SQL Server creating table with clustered index without a primary key

Is it possible to create a clustered index from a create table statement in SQL Server 2008 that is not a …

sql-server sql-server-2008 sql-server-2008-r2 azure-sql-database clustered-index