Monthly Archives: March 2020

The Web Service threw an error during method execution. The error is: Unable to connect to the remote server at Microsoft.SqlServer.Dts.Tasks.WebServiceTask

Posted on March 30, 2020 by chanmingman

This post shows you one of the possibilities to resolve the error above. I have written to Microsoft team in email as below. I spent a day to troubleshoot this but no luck. I have web service running fine in … Continue reading →

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

Ubuntu Hyper-V display resolution

Posted on March 25, 2020 by chanmingman

This short post shows you how to change the display resolution in Ubuntu when you have your ubuntu in Hyper-V. Go to you Terminal in Windows people call in command prompt then type the following. sudo nano /etc/default/grub Change this … Continue reading →

Posted in Community, Computers and Internet, Operating System, Servers | Tagged | Leave a comment

Webassembly with C++ Ubuntu

Posted on March 23, 2020 by chanmingman

This post shows you how to create Webassembly in Ubuntu 10.08. I get 2 links one is https://medium.com/@cchaconsartori/introduction-to-webassembly-with-c-part-i-64bcfad7ecb4 and another is https://medium.com/@tdeniffel/pragmatic-compiling-from-c-to-webassembly-a-guide-a496cc5954b8. Unfortunately you need to combine these two to make it works for now. Whether it will continue to … Continue reading →

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

Windows Hello Fingerprint not working

Posted on March 23, 2020 by chanmingman

This post show you one of the possible ways to resolve Windows Hello Pin or Windows Hello Fingerprint cannot function. In short you have to rename C:\Windows\ServiceProfiles\LocalService\AppData\Local\Microsoft\Ngc to something else. The below video link has the step by step. References: … Continue reading →

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

PowerShell compare date then move file

Posted on March 22, 2020 by chanmingman

This post shows you how to compare move the file to another location based on the date. It sounds simple but I could not find a single location showing me the code below. I combined 3 links under the references … Continue reading →

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

CTO Articles March 2020

Posted on March 21, 2020 by chanmingman

This post shares the articles and videos good for CTO. Executive Spotlight: Top Priorities For Security And Risk Leaders In 2019. This document showing a good security transformation. https://1drv.ms/b/s!Aje-DdIVpfjSi2b7rM_2d8ZkGHmL Four ways to maximize your business intelligence investments https://1drv.ms/b/s!Aje-DdIVpfjSi2geksh8VqN4d6Vb?e=cDSSp1 The Sprawling … Continue reading →

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

SQL Server convert varbinary blob to Excel

Posted on March 17, 2020 by chanmingman

This post shows you the code to convert SQL Server varbinary field back to Excel. You might get some errors if you are using the code here https://chanmingman.wordpress.com/2011/06/21/read-image-file-blob-from-binary-field-in-ms-sql-database/. The pre-requisite of this post is you need to know ADO.NET. The … Continue reading →

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

SQL Server 2014 Service Pack update

Posted on March 16, 2020 by chanmingman

This post shows you how will it look like if you are installing a Service Pack. I believe many SQL administrators out there are wondering how exactly the process is like. I show it using SQL Server 2014 because this … Continue reading →

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

SQL Server Case in Where clause

Posted on March 14, 2020 by chanmingman

This post shows how to use the Case…When keyword in WHERE clause. I found a good article which has given me the idea to do this. Firstly, create a empty database name SQLShackDemo. Create Employee table and insert the sample … Continue reading →

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

Check hard disk for bad sector to recover your files

Posted on March 10, 2020 by chanmingman

This short post shows you how to temporary get back your data before your hard disk is total gone. If you have realized the some files in your hard disk is corrupted out of the blue, of course not because … Continue reading →

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