Push data to Azure SQL database

I am pretty new using Azure SQL database. I have been given a task to push a 100 million record text file to Azure SQL database. I'm looking for suggestions how to do it in an efficient manner. ...
more »

2017-12-03 21:12 (2) Answers

Getting exception suddenly from entityframework

I get this exception from time to time : The 'Email' property on 'User' could not be set to a 'System.Int64' value. You must set this property to a non-null value of type 'System.String'. Method Message:, LogException: System.InvalidOperationExc...
more »

2017-11-02 14:11 (0) Answers

Aggregate function results in select statement

Hopefully the code below should demonstrate what I'm trying to achieve. The issue is that none of the input selects are resolved by the time I try to calculate VatableCash so I get "Invalid Column" when trying to select it. Sorry if there's somethi...
more »

2017-10-21 10:10 (2) Answers

[Azure/mssql]How do I get Insert query recordset

I'm using mssql. After inserting a record,I want to get the id of the data. But I don't know hot to do that. My code is below. please give me answer. var mssql = require('mssql'); mssql.connect(config.mssql, function(err) { var request = new mssql.R...
more »

2017-09-03 14:09 (1) Answers

How to optimize SQL Server Columnstore Alignment

I have a Clustered Columnstore Index Table for our IOT metrics (timeseries data). It contains more than 1 billion rows and structured like this: CREATE TABLE [dbo].[Data]( [DeviceId] [bigint] NOT NULL, [MetricId] [smallint] NOT NULL, [TimeStamp] [da...
more »

2017-08-05 09:08 (1) Answers

Azure Data Factory Copy Identity Column With Gaps

I created a pipeline and two linked services to move data from an on-prem instance of SQL Server to an Azure Sql instance. The issue I'm running into is that we have a table "Table-1" in our on-prem with an Identity (1,1) column that is missing a se...
more »

2017-02-06 22:02 (2) Answers

Connect Cordova hybrid app to Azure SQL Database

I am using apache cordova and ionic framework in Visual studio 2015 to create a hybrid app. I would like to connect my app to a cloud sql database such as azure sql or google cloud sql. I need to be able to do inserts, updates, and selects. Fro...
more »

2016-05-27 20:05 (2) Answers