FAQ Database Discussion Community


Pointing EF to a database when the POCO files are in a seperate project

c#,asp.net-mvc,entity-framework,sql-azure
I have a single ASP.Net solution with 3 projects in it. The Data Access Layer (DAL) that contains the code first CS files for my database, the API project, and the UI Project. I have setup the web.config file of the API to point to my test DB in Azure,...

How to return IDs that are in each table

sql,sql-azure
How to I write a SQL script that return all the site IDs that are in all my tables: Tables in this image: And this is what I want returned: ...because only site 1 & 2 are in all four tables. Database: SQL Azure (but I don't think that matters)...

SQL Remove All Constraints Azure Friendly

sql,tsql,azure,sql-azure
I'm doing some DB Admin with an Azure database and I need to perform queries like removing all constraints in the database. sp_MSForEachTable is not available when working with Azure databases, so I'm working on a different way to do it. I found a snippet that drops all tables here:...

How to import SQL table data to Redis Cache?

asp.net-mvc,caching,azure,redis,sql-azure
I have following table MYTestTable ID Name Location 1 aaa IND 2 bbb US 3 ccc UK Now I want to save this data to Redis Cache (with same table structure ), How can I do this so? I tried google but I only found examples with Key-Value Pair :(...

Error Installing pymssql on Mac OS X Yosemite

python,sql-azure,osx-yosemite,pymssql
I receive the following error when installing pymssql on OS X Yosemite 10.10.3 - has anyone gotten around the following error? I am using FreeTDS (v0.91.112) version 7.1 and Python 2.7.6 - the tsql utility connects to a SQL Database with no issue. sudo pip install pymssql Error: Command "/usr/bin/python...

Azure PowerShell Error: while using Start-AzureSqlDatabaseCopy it throws exception with Error Code: NotFound

powershell,azure,sql-azure,azure-powershell
I was trying to make a copy of a database on azure using powershell. I have used "Start-AzureSqlDatabaseCopy" for powershell as descriibed on https://msdn.microsoft.com/en-us/library/ff951631.aspx. But it was failing, and not able to create database copy there. I even tried deleting an existing database using "Remove-AzureSqlDatabase" and saw the same issue....

Azure SQL Replication

sql,azure,sql-azure
I have an application that, for performance reasons, will have completely independent standalone instances in several Azure data centers. The stack of Azure IaaS and PaaS components at each data center will be exactly the same. Primarily, there will be a front end application and a database. So let's say...

Azure SQL With NodeJS

node.js,azure,sql-azure
I have a staging SQL database in Azure and I use the mssql node module to connect to it. The only problem I got is the idle connection policy in Azure. After 30 minutes of idleness the connection is closed automatically. Is there anyone who faced the same problem?...

Windows Azure Pack and SQL Azure Sharding

azure,sql-azure,azure-pack
I seem to be having some difficulty finding answers to my question. Does anyone know if Windows Azure Pack for private clouds allows you to utilize a local version of SQL Azure? I don't see any mention of SQL Azure in the documentation. Essentially, I want to insure that the...

Error deploying database to SQL Azure

sql-server,azure,forms-authentication,sql-azure
I'm using forms authentication to handle users and attempting to deploy my database to SQL Azure, but getting this error message: The only table of the four listed that I utilize is aspnet_Membership, and the only other table I use is aspnet_Users from implementing forms authentication. What is TextInRowSize and...

Getting quite a few SQL Azure connection issues today, and forced disconnections, how to get more information from MS and also how to monitor?

azure,sql-azure
We use the Northern Europe Azure Data Centre. We use SQL Azure Web Edition with Websites. Today we seem to be getting quite a few SQL Azure disconnections with error code 10054: Symptom: A transport-level error has occurred when receiving results from the server. An established connection was aborted by...

Clustered Index Error in Azure for a Table that Has a Clustered Index

sql,azure,sql-azure
I am running this command on SQL Azure. DELETE FROM dbo.Users I am getting this error. Msg 40054, Level 16, State 1, Line 1 Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again. I then try to...

Add azure db to mvc5 project

asp.net,azure,visual-studio-2013,asp.net-mvc-5,sql-azure
I have a MVC 5 project using visual studio 2013. How can I add/create a database in azure from visual studio so that EF6 code first can just use and create the models? I've been browsing server explorer but there is nothing there related to azure....

SQL Azure Database giving “The server could not retrieve metrics (Internal Server Error).” message

azure,sql-azure
One of my SQL Azure databases is giving me a The server could not retrieve metrics (Internal Server Error). message when I click on the Metrics tab, and when I click on the Dashboard tab I get the following error: Failed to retrieve database information.: "Could not retrieve database information...

Azure data sync not syncing sql database data properly as expected

azure,sql-azure,azure-data-sync
I was checking Azure data sync functionality for azure sql databases and observed that data was not properly synced. Scenario: I have created Sync group having one hub machine [Hub1] and 2 databases one within same data center [DB1] and another from other data center [DB2]. Case: I have made...

Azure Default Database cleanage

sql,azure,sql-azure
Some weeks ago I've made an android prototype and deployed the services and databases to my azure free account. Today, for my dismay I've found out that all my data was cleaned. I've searched a bit but didn't find any plausible reason for this event. So my question is, Is...

CREATE USER disconnects from Azure database

sql-server,tsql,azure,sql-azure
In a SQL Azure Database, I want to create a new schema, a new login and a new user: CREATE SCHEMA a AUTHORIZATION dbo ; CREATE LOGIN a WITH PASSWORD = 'secret'; CREATE USER a FOR LOGIN a WITH DEFAULT_SCHEMA = a; CREATE SCHEMA and CREATE LOGIN work. However, executing...

Unable to import/deploy database to SQL Azure: “The service objective (Business/Web) specified is invalid.”

sql-server,azure,sql-azure,ssms,ssms-2012
I'm trying to move my databases to a newer Azure subscription. I used to simply click "Deploy to Azure" on a local database from SSMS and have it deployed to a specified Azure server. Importing/Exporting a BACPAC file also works. However, I can't seem to do any of this on...

Semantic logging In-Proc and Out-Proc

azure,logging,sql-azure,windows-azure-storage,semantic-logging
I'm using Semantic logging with Windows Azure Websites, I wonder Using Semantic logging using Azure website and store log in Azure Table storage and Azure SQL db is Inproc or out Proc ? Can anyone elaborate more on this please?...

Azure SQL Elastic Performance Scale

sql,sql-azure,azure-scheduler,azure-elastic-scale
I have Standard S1 SQL database which is fine for most tasks. However I have an overnight task that needs much more computing power. I am wondering if anyone has experience of using scheduling to scale up the database in terms of Service Tier and Performance Level, executing one or...

Is there a more efficient way to write this SQL query?

sql,sql-server,tsql,sql-azure
I have a table with a couple million records in it which stores product views by SessionGUID (visitor), the table structure is: ID (PK) SessionGUID (uniqueidentifier) ProductID (int) DateTime (datetime) The purpose of the query is to return a list of Product ID's that were viewed by the same people...

Connecting iisexpress to an azure sql db which is security enabled

visual-studio,azure,sql-azure
I created an azure sql database and started developing my web app. From Visual Studio I could debug using iisexpress and it would happily connect. But now I have turned on the "Security Enabled" feature (to require encrypted connections), the connection from iisexpress times out. I edited the connection strings...

Retrieving user created roles and user info in Azure

tsql,azure,sql-azure,user-administration
I used to following to create a role in Azure SQL database, grant permissions to the role and assigned the role to the user: CREATE ROLE [DepartmentReadOnly] AUTHORIZATION [dbo] GO GRANT SELECT ON tblDepartment TO DepartmentReadOnly CREATE USER [user1] FROM LOGIN [user1]; EXEC sp_addrolemember DepartmentReadOnly, user1; Now what sql do...

Sort users by a specific order

sql,sql-azure
I want to sort users so i have this: SELECT TOP(@UnitUsers) * FROM users ORDER BY unit_followers DESC And i get: (user_id, username, unit_followers) 1 Test 123 2 Admin 89 3 Ola 79 4 Pat 67 5 Twe 54 6 Dry 42 But now, i add a new table, promote...

LinqPad connect two azure databases on same server

c#,sql-azure,linqpad
Per the FAQ (1), I can add additional databases to my existing connection in a number of ways. I have tried them all, and none work for SQL Azure. In fact, SQL Azure as a provider, doesn't even include the option to "Include additional databases." Can someone please tell me...

SQL Azure Connection and Transaction

transactions,sql-azure,saas
I am using SQL Azure for a Saas based asp.net application. I have avoided transactions as much as possible to prevent deadlocks for end-users. This is due to my lack of knowledge in DB Design, but I thought avoiding transaction is atleast one sure way of reducing table and row...

I have a 'No overload for svc_methodNameCompleted matches delegate System.EventHandler…' Error and I dont know how to fix it?

c#,wcf,windows-phone-8,sql-azure
Hi my method in my service reference is. public List<Lecture> ViewUsersLectures(string userID) { using (var context = new SE_App_DatabaseEntities()) { // select query (linq style) to select all lectures from lectures table in database var results = from r in context.Lectures where r.UserID == userID select r; // return results...

Using MVC App to run CRUD operations on Existing Azure Database

asp.net,asp.net-mvc,azure,sql-azure
Create an ASP.NET MVC app with auth and SQL DB and deploy to Azure App Service above is a link to a tutorial that I followed to create a database and manipulate seeded data with a MVC app. I am currently learning about ASP.NET & Azure in my internship. How...

SQL on Azure - using a computed column as a primary key index

sql,azure,sql-azure
I am not sure what is wrong with the below SQL. I used to have a primary key based off of the customer_reference_no. They now have some duplicates so I am creating a column called uniquePoint that is a combination of customer_no, customer_reference_no and stop_zip. The below works fine: CREATE...

How to set network security group rules for azure storage services?

azure,sql-azure,azure-table-storage,windows-azure-networking
I need to setup Network Security Group rules for my application so it can receive HTTPS requests from the Internet and write data into Table Storage and Azure SQL. Nothing else is allowed. I know how to setup the HTTP inbound rule. But I could not figure out how to...

Is there any benefit to splitting DECLARE into two parts in a SQL Stored Procedure?

tsql,stored-procedures,sql-azure
I've seen code that looks like this in a stored procedure: DECLARE @Var1 NVARCHAR (64), @var2 NVARCHAR (64), @Var3 NVARCHAR(512); DECLARE @Var4 AS INT, @Var5 AS INT, @Var6 AS INT, @Var7 nvarchar(32); Is there any benefit to declaring them that way, as opposed to just putting them all inside one...

How to write part of the app on azure?

azure,windows-phone-8.1,sql-azure,azure-mobile-services
Hi all hope this question is actually asked the right way i have been researching for hours and i can't get anything that would help me achieve what i want... Here's the thing i am currently developing a windows phone app that uses cloud features (like sql azure,authentication,etc...) and what...

Limiting Data With Lucene.NET

full-text-search,sql-azure,lucene.net
We are using Sql Server 2012 Full-Text indexing, however we would like to move our database to Sql Azure. Using the migration tool it is telling us that Full-Text indexing is not compatible with Sql Azure (even v12 which is in preview does not support it so it doesn't look...

UTF8 support in Azure SQL Server

sql-server,spring,hibernate,azure,sql-azure
I read that need to use "nvarhar" for utf8 fields. But how to define it through Hibernate & Spring? @Column(name = "TITLE", nullable = false) private String title; ...

SQL Azure retry logic using EnterpriseLibrary.TransientFaultHandling

c#,sql-azure,enterprise-library
Trying to implement a retry logic in a correct way, but couldn't find any good sample on how to properly leverage EnterpriseLibrary.TransientFaultHandling. So far I found two samples: First - using ReliableSqlConnection & conn.Open(retryPolicy) var retryStrategy = new Incremental(3, TimeSpan.FromMilliseconds(500), TimeSpan.FromSeconds(1)); var retryPolicy = new RetryPolicy<SqlDatabaseTransientErrorDetectionStrategy>(retryStrategy); retryPolicy.ExecuteAction(() => { using...

How can I deploy an app using Identity Model to Production on Azure?

c#,asp.net,asp.net-mvc,azure,sql-azure
I'm pretty new to MVC. I'd like to deploy the default sample web app to Azure with a basic Identity Model installed so that I can confirm basic user authentication is working in production. I can't seem to get it working. I am using Visual Studio 2015 RC. I launch...

Getting error when runs script on Azure sql server but working correctly on local sql server

sql-server,azure,sql-azure
When I run following query on Azure SQL, it gives me following error: Error: Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again. Whereas the script runs perfectly fine on local sql server Script: --Script for removing...

Check if record exists in subquery

sql,sql-server,azure,sql-azure
I have the following 3 tables Source Id | Name | SiteId ---+--------------+--------- 1 | Source 1 | 1 2 | Source 2 | 1 3 | Source 3 | 2 4 | Source 4 | 2 SourceAccount SourceId | AccountId ---------+---------- 1 | 1 2 | 1 3 |...

Azure Get Live Queries

sql-azure
I'm looking for a query to get the current running queries in Azure SQL. All of the T-SQL I've found do not show the running queries when I test them (for instance, run a query in one window, then look in another window at the running queries). Also, I'm not...

How to speed .NET MVC site deployed on AZURE? [closed]

asp.net,asp.net-mvc,performance,azure,sql-azure
Of course i want to reach maximum perfomance. What can I do for it? Use Bundles for CSS & JS files? Ok. What kind of storage shold I use? Now its SQL Database. But site and DB are placed in different regions. Size of DB will be not too big...

Granting read only access to a view in user-defined database in SQL Azure

sql-azure,login-script
I have a view called 'cust_view' in a SQL Azure database. My goal is to give end users of my application read only access to some data in the application database, so they can run their ad-hoc queries from their side by directly connecting to the application database in SQL...

Azure geo-replication: Can't create a secondary server

azure,sql-azure,database-replication,geo-replication
I have an Azure SQL data base on a premium tier I try to activate Geo-replication on the preview portal. I clicked Server name on CREATE SECONDARY blade I then selected CREATE A NEW SERVER on SERVER blade I filled the form, but the OK button still stay disabled Bellow...

Could not load file or assembly Microsoft.SqlServer.TransactSql

sql-server,azure,sql-azure,ssdt,sql-server-2014
Database project build failed. Error Details: Error: MSB4018: The "SqlBuildTask" task failed unexpectedly. System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.TransactSql, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.SqlServer.TransactSql, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' I also go through this answer on stackoverflow...

SQL Azure Elastic Scale - reference table

azure,sql-azure,azure-elastic-scale
I am not sure if I understand the idea of reference tables correctly. In my mind it is a table that contains the same data in every shard. Am I wrong? I am asking because I have no idea how should I insert data to the reference table to make...

Data streams in case of Merge

sql-server,ssis,sql-server-2012,sql-azure,sql-server-2014
We are seeing enormous amounts of data-traffic to and fro our SSIS server. We cannot find the culprit. Is there any way to find out which package is causing all the trafffic? Any advice on that? We are thinking that maybe all the merges we do cause all the traffic....

Cache “dictionary-like” DB entities in ASP.NET MVC app

c#,asp.net-mvc,azure,caching,sql-azure
I have asp.net mvc5 project hosted in Azure that is using SQL Azure for data persistence. Some tables in my database are like dictionaries, they are referenced by lots of tables, and very rarely changed. One example of such table can be Client app type: Windows, Windows Phone, Android, etc....

Setting a SQL Azure server's name

azure,sql-azure
One can create a SQL Server on Azure with cmdlet New-AzureSqlDatabaseServer But how is it possible to set the server name? Azure gave an automatic name, but it is not easy to get it back later...

Triggering Code when a specific value is inserted into a table column in an Azure SQL Table

triggers,alert,sql-azure
I am seeking suggestions on methods to trigger the running of code based on specific event occurring. Basically I need to monitor all inserts into a table and compare a column value against a parameter set in another table. For example, when a new record is added to the table...

Does SQL Azure support REPLACE T-SQL function with cyrillic characters?

sql-server,tsql,azure,sql-azure,management-studio-express
I am trying command like USE [aaa] GO SELECT [Id] ,REPLACE([BlaBlaField], 'xyz','') FROM [dbo].[aaa] GO through SQL Management Studio on SQL EXPRESS and SQL Azure Web Edition DB. In SQL Express it works, but on Azure it does not. I searched on the web at 'Azure SQL Database General Guidelines...

How to create a sequential auto-number field in Azure SQL without IDENTITY?

sql-server,azure,sql-azure
I've tried all sorts of things but so far I've been unable to find a solution to this... We have an Orders table with an OrderID field that is currently an IDENTITY value. This has been causing problems for my customer because although the IDs are mostly sequential, there are...

Timeout accesing SQL Azure on Basic/Standard tier - works fine on Web tier

sql,azure,timeout,sql-azure,tiers
I am upgrading a legacy azure site to use one of the current SQL azure tiers from the old web tier. The site works fine on the website and locally but when I switch from web to basic or standard I get timeout errors. The code that is timing out...

The best way to retrieve large amounts of data from a SQL Server (or SQL Azure) database

sql-server,database,ado.net,entity-framework-6,sql-azure
I have a table with 40 millions rows. I'm looking for the best technology for retrieving this data to JSON via API. The performance is critical! I think, the best way is to use ADO.NET and a SqlDataReader. But, I want to use automapping (like EF). Could you tell me...

Always Get 1 record from Table 2 based on some condition

sql,sql-server,sql-server-2008,sql-azure
I have two tables, Product and ProductImages. Product table has 2 columns: ProductID and Name ProductImages table has 4 columns: ID, ProductID, ImageName and Primary(bit). The relation between Product and ProductImages is one to many, so one product can have many images, but for each product only one ProductImage will...

Start-AzureSqlDatabaseImport completed

sql-azure
Is there a any way to know when a Start-AzureSqlDatabaseImport command has finished importing? The command returns pretty much immediately, but i can't find a way to check when the import has actually completed into my existing database.

How do I add line breaks/images to SQL database/MVC Application

c#,asp.net-mvc,azure,sql-azure
Sorry for the terrible title. I followed this MVC tutorial on asp.net to the end. After I finished it, I realized that I had a personal use for this. I'm making a site where I can organize D&D spells (since the player's handbook is so bad about that). It'll be...

Azure linked Resource: Web app + SQL db. What does it actually do?

azure,sql-azure,azure-web-sites
Im using Azure to develop and host my website. Im using an SQL db located in Azure. I have linked my Web App to the SQL db.. But what is the use of it? What changes for my web app that it is not linked to my db? I mean,...

SQL Azure Federation Database Backup

sql,azure,sql-azure,federation,sql-azure-federations
We are using SQL Azure Federation and now we want to take backup. We tried using Migration tool and Enzo cloud backup utility but the SQL Federation version is deprecated in both of the tools. Is there any alternative method to take backup of federated database apart from the one...

Creation of Microsoft Azure Web App with sql server failed

azure,model-view-controller,sql-azure,azure-web-sites
I've been attempting to create a new MVC web application in visual studio and have it hosted in Microsoft Azure. If I choose to have a database server it fails with the following error. Creating Microsoft Azure Web App Creation of Microsoft Azure Web App failed. Object reference not set...

Membership not working with Azure SQL database-level firewall

asp.net,azure,asp.net-membership,sql-azure,firewall
We have an Azure Cloud application which stores user login (Membership) info into an Azure SQL database. We have several versions of this database, one for production and one for development. We want our development database to be open to the world and the production limited to Azure cloud applications....

Get Selected values in SQL

sql,sql-server,sql-azure
I want to compare datetimes and delete the rows thats more than 72 hours old. Then I want to update another table boolean "HasClone". How do I get the ints (ID's) from the first selection into the other? see code below: SELECT Allocation_plan_details_Clone.Allocation_plan_id AS ID FROM Allocation_plan_details_Clone WHERE DATEDIFF(hour, start_date,...

Cannot drop/alter column in SQL Azure

sql,sql-azure
As the title says, I cannot drop or alter a column in SQL Azure. I wanted to change its datatype from int to tinyint. I did specify tinyint, but it seems Azure overrode that. I've tried via the Management Console as well as from SSMS. I found the following SO...

How to use Azure Mobile Service with Cordova Project AngularJS and C#?

c#,angularjs,cordova,sql-azure,azure-mobile-services
I want to use a database hosted on Azure with some sort of backend for my app made with apache cordova tools for visual studio. My thought was that I could create my JS object in the app itself send that to the C#/JS code on azure which will then...

how to use one core project for a SQL Server 2014 and Azure SQL Database

sql,database,azure,reference,sql-azure
we want to deploy our Software on different editions of SQL Server. So we made a CoreDB Project, and for every edition (Express, Standard, Enterprise) seperate projects. Each references the CoreDB to reduce the amount of objects to define. Now we want to deploy to Azure DB, but we can...

Statement 'CREATE QUEUE' is not supported in azure

sql-server,sql-azure
I am trying to execute this command on Windows Azure to be able to use SqlDependency USING [mytable] CREATE QUEUE NewsAddedQueue; CREATE SERVICE NewsAddedService ON QUEUE NewsAddedQueue ([http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification]); but it retuns this error: Statement 'CREATE QUEUE' is not supported in this version of SQL Server. Is there any solution or...

Reduce the number of SqlCommands required to send information to three tables

c#,sql,query-optimization,sql-azure,sqlcommand
I have the following code: command = new SqlCommand("SELECT UserId from Users WHERE Username = N'" + userName + " AND " + userPassword + "= N'" + userPassword + "AND AccountStatus = 0"); command.CommandType = System.Data.CommandType.Text; command.Connection = conn; int uid = (int)command.ExecuteScalar(); if(uid > 0) { command =...

How to get notified upon database updates in SQL Azure

sql-azure
We host data in SQL Azure, we used to have query notifications if we host data on premise, how do we address it in case of SQL Azure? to get query notifications upon updates, inserts events other than keep polling from code? Or is any other Azure services support this,...

Azure Online SQL Database Management is Unavailable

azure,sql-azure
I am trying to host a sql server on azure to communicate with a node app. I have gone through the process of creating the database server and the database itself successfully. Now, I would like to edit my database structure. From what I have found online, there should be...

New table Mobile Service Azure, can't get data

c#,azure,sql-azure,azure-mobile-services
How can I add additional tables in azure mobile services and programmatically insert and read data. I tried doing it similarly as the code from TodoItems table. My new table is created and I can insert data manually by using sql, but when I use private MobileServiceCollection<User,User> users; private IMobileServiceTable<User>...

Azure vm public ip?

azure,sql-azure
we need to access our partner's sql azure db, they ask for an ip so they add to the whitelist, thing is we doing the dev work on our azure vm (under different subscription), what ip should we give them, I suppose a public IP address? Will that change over...

ShardMapManager.TryGetRangeShardMap wont retrieve the RangeShardMap

c#,azure,sql-azure,azure-elastic-scale
I am trying to play around with the sample app provided by Microsoft here. This works fine for creating a new database and its shards etc. But it fails when i try to connect it to an existing DB with a single shard. It has a class named ShardManagementUtils which...

Configuring Azure web and SQL UK Culture

asp.net,iis,azure,asp-classic,sql-azure
I've recently moved a classic asp site which uses SQL Server to Azure Shared websites, with SQLAzure as the database. Its region is north Europe (Ireland). I need the database to be running under en-GB locale and as such dates returned from SQL to be in the format DD/MM/YYYY and...

Select sum or updating a field for Total Balance?

sql,database,entity-framework,database-design,sql-azure
I'm using Entity Framework and Azure Sql. I have users and they have records on balance table.Some of users may have 1 million record.I need total balance of the user before every http requests. I have two approaches for getting total balance of user: First: Insert balance and update totalbalance...

Unable to publish to Azure after 2014 update

asp.net,asp.net-mvc,azure,sql-azure
I have an APS.net MVC project I have been publishing to azure for a while. I recently change laptop and moved to SQL Server 2014. Now when I try to publish I get 3 errors. The fist one looks to be the root course: Error 3 .Net SqlClient Data Provider:...

Partial support in VS 2013 for certificates and symmetric keys in azure v12

azure,encryption,visual-studio-2013,sql-azure
In a Visual Studio 2013 project targeting azure v12, I get SQL70015 errors (Statement x is not supported in the targeted platform) when creating key and certificate artifacts. However, before creating independent key and certificate objects in the project, I'd had a postdeploy script add them if they didn't exist....

microsoft azure sql v12 in-memory table max size

size,sql-azure,in-memory
What is the maximum table size of in-memory tables on microsoft azure sql (v12) databases? For the different service tiers?

Does SQL Azure/ SQL Server Transparent Data Encryption encrypt .bacpac files?

sql,sql-azure
I am looking into implementing Transparent Data Encryption (TDE) on a SQL Azure database. Azure creates backups as .bacpac files. The documentation at TDE mentions that "Backup files of databases that have TDE enabled are also encrypted by using the database encryption key. " The documentation does not mention anything...

How to override Azure Sql connection in Azure portal

entity-framework,azure,sql-azure
I tried to override connectionstring in Azure portal with this connection : Server=tcp:server.database.windows.net,1433;Database=mydatabase;User [email protected];Password=xxxxxx;Trusted_Connection=False;Encrypt=True;Connection Timeout=30; It gives me an error Keyword not supported: 'server' and when I tried it as: metadata=res://*/DataAccess.MyDataBase.csdl|res://*/DataAccess.MyDataBase.ssdl|res://*/DataAccess.MyDataBase.msl;provider=System.Data.SqlClient;provider connection string=&quot;data...

Are intermittent long CLR waits to be expected when updating geography columns in SQL AZURE?

c#,sql-server,sql-azure,spatial
I have a table with 14 records and the following query running through Entity Framework using "ExecuteSqlCommandAsync" UPDATE [par].[UserActivity] SET Position = {0} WHERE [email protected] This query typically executes in about 2 to 10 ms.. But once or twice an hour it takes anywhere from 10 to 30 seconds.. Position...

How can I manage Azure SQL user/login/credentials

sql-server,azure,sql-azure
I read this article: https://msdn.microsoft.com/en-us/library/azure/ee336235.aspx I don't know how to connect to the master database. I don't see it anywhere on the portals. I want to be able to manage which credentials have access to which db and at which level. Preferably using a GUI....

A parameter cannot be found that matches parameter name 'MaxSizeGB'

azure,sql-azure,azure-powershell
New-AzureSqlDatabase command on execution suddently started failing with parameter not found message. MSDN link mentions the parameter as supported. https://msdn.microsoft.com/en-us/library/dn546722.aspx Command : New-AzureSqlDatabase Input PS C:\scripts>$database1 = New-AzureSqlDatabase -ServerName "lpqd0zbrseg" -DatabaseName "Database1" -Edition "Business" -MaxSizeGB 50 -Collation "SQL_Latin1_General_CP1_CI_AS" Output Error New-AzureSqlDatabase : A parameter cannot be found that matches parameter...

Azure SQL and my ASP.NET C#

sql,asp.net,sql-server,azure,sql-azure
I have made application ASP.NET C# and my connection string is as follows: <add name="ASPNETDB" connectionString="Server=tcp:MYDATA.database.windows.net,1433;Database=MYDATA;User ID=MYDATA;Password=MYDATA;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;" providerName="System.Data.SqlClient" /> Now it doesn't work at all, I mean I can't connect to my SQL server on Azure at all. When I want to login nothing happens, when I want to...

Unable to deploy DB from local SQL Server

sql-server,azure,sql-azure
I'm trying to export a DB from my local SQL Server to Azure SQL. So far I've tried Tasks > Deploy Database to Windows Azure SQL Database I then connect to the Azure DB, give the new DB a name and then let it run. However, it fails with the...

How to write the results of Azure ML web service to the azure sql database (The output of Azure ML web service is in Json structure)

sql-azure,azure-scheduler,azure-machine-learning
The results can be written to SQL Azure using the writer module in the experiment but after publishing the web service the output comes in the Json Structure and it doesn't go to the writer module

How to Improve SQL Azure Query Performance

tsql,entity-framework-6,sql-azure,query-performance
I am using EF 6 to execute a SqlQuery, which is a SELECT statement returning 47 columns with a max of 500 rows. The query has eight LEFT JOIN statements. In my local environment, the query only takes around 300 ms, as indicated in Express Profiler. On SQL Azure, the...