Category Archives: Community

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

CTO July 2020 articles and resources

These are the good reads found in this month. SECRET WEAPON IN YOUR ENTREPRENEURIAL SUCCESS: SOLUTION ARCHITECT In a nutshell, you could summarize the roles of a solution architect as follows: Analyzing the tech space for appropriate solutions. Harmonizing tech … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, News and politics, Operating System, Servers | 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

Clean all bin obj folder in all folders Visual Studio

This short post shows you how to clean all bin obj folder in all folders. This will clean up all the builds in all the development folder. You need to run the following PowerShell command with administrator right. gci -inc … Continue reading

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

Declare a Enum with bitwise operator

This post shows a good practise to declare a Enumerator, Enum. You can see the practical use of bitwise operator in the example. Instead of ReadWrite = 3 You can do ReadWrite = Read | Write like the example below … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet | 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

Update Microsoft Edge in Windows 10 1803

This post shows you how to update Microsoft Edge if you are still having older Windows 10 like 1803. There are many reasons people try not to update Windows 10 to newer version. The key reason is still software compatibilities. … Continue reading

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

Publish ASP.NET Webform to Azure App Service

This post shows you how to publish an ASP.NET Webform app to Azure App Services. Pre-requisite of this article is you need to know how to create an ASP.NET Webform application. 1. Create an ASP.NET Application using the default ASP.NET … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet | 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