Monthly Archives: June 2020

Clean all bin obj folder in all folders Visual Studio

Posted on June 28, 2020 by chanmingman

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

Posted on June 27, 2020 by chanmingman

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

Posted on June 25, 2020 by chanmingman

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

Posted on June 23, 2020 by chanmingman

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

Posted on June 22, 2020 by chanmingman

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

Posted on June 20, 2020 by chanmingman

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

Posted on June 20, 2020 by chanmingman

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

Quantum computing simulation using Q# with C#

Posted on June 20, 2020 by chanmingman

This post shows you a Quantum computing sample that works using Visual Studio 2019 version 16.6.2. First download and install the Microsoft Quantum Development Kit, https://docs.microsoft.com/en-us/quantum/install-guide/standalone#installation, is in preview. Download the code here https://github.com/microsoft/Quantum/tree/master/samples/interoperability/dotnet.. Open dotnet.sln. The solution is actually … Continue reading →

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

SSIS ETL from SQL Azure database to Azure Blob Storage

Posted on June 18, 2020 by chanmingman

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 | 2 Comments

SQL Server Remove duplicate record(s) from database table

Posted on June 15, 2020 by chanmingman

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