Category Archives: Data Platform

Stop Azure Data Factory SSIS Integration Runtime

This short post shows you how to stop the Azure Data Factory SSIS Integration Runtime. Why you need to do that? It will be very costly if you let it running. When you go into Azure Data Factory. Click on … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , | Leave a comment

Azure SQL Server database to Json

This blog post shows you how to retrieve the data from SQL Azure database using Entity Framework and serialize it to Json string. The pre-requisite for this article; 1. You need to know Entity Framework, 2. You have an Azure … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , | Leave a comment

Deploy SSIS package to SSIS IR using Visual Studio

This blog post shows you to deploy SSIS project to SSIS IR in Azure. The pre-requisite of this post; 1. You need to know SSIS. 2. You have Windows Azure subscription. (They are few points missed in this document https://docs.microsoft.com/en-us/azure/data-factory/tutorial-deploy-ssis-packages-azure.) … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

VC++ CLR connect to SQL Azure Database

This post shows you how to connect to SQL Azure database using VC++ CLR. In previous post https://chanmingman.wordpress.com/2012/01/06/vc-clr-ms-sql-server-access/, the code connect to on-premise database. Here we connect it to SQL Azure database. What you need to do is to get … Continue reading

Posted in .Net, Cloud, Community, CTO, Data Platform | Tagged , | Leave a comment

A ‘R’ script error occurred during execution of ‘sp_execute_external_script’ with HRESULT 0x80004004. SQL Server

This post shows you one of the possibilities to fix the above error when you are running R script. Back then I have tested the script runs in SQL Server 2017 when I have posted this https://chanmingman.wordpress.com/2019/03/17/machine-learning-service-in-sql-server-2017/. Somehow I bumped … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , , , | Leave a comment

Azure Virtual Machine Web Server http port 80 Access

This post shows you how to enable web server access through port 80 if you have a Web Server running in a Virtual Machine setup in Azure. It used to only have something called “Firewall” but Azure has changed that. … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Servers | Tagged , | Leave a comment

SSIS ETL from SQL Azure database to Azure Blob Storage

This post is to show you want to use SSIS with full Azure environment, SQL Azure database and Azure Blob Storage. The pre-requisites to this article are; 1, Visual Studio 2017 and above. 2. You need to be familiar with … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

SQL Server Remove duplicate record(s) from database table

This post shows you how to remove the duplicate records in SQL Server database table. For example, I issue the follow SQL statement. SELECT * FROM [northwind].[dbo].[Products2] order by productid You can see ProductID 1 is duplicated. Issue the SQL … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

Excel VBA loop through SQL Azure database

In the previous article, hIttps://chanmingman.wordpress.com/2020/06/07/excel-vba-loop-through-sql-server-database/, is connect from VBA to SQL Server on premise. Now, you can use VBA to connect to SQL Azure database and populate the Excel sheet. The code is almost 95% the same except you will … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Microsoft Office, Office 365 | Tagged , , | Leave a comment

JDBC connect to SQL Azure

This post is because a friend of mine asking “From AWS connect directly to db in Azure via JDBC connection. Any advise?”. I do believe JDBC will work the same across Axure, AWS or Google cloud platform. The below code … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Java | Tagged | Leave a comment