Monthly Archives: February 2018

Microsoft Power BI vs Qlik vs Tableau 2018

Posted on February 28, 2018 by chanmingman

Gartner 2018 reports shows Tableau, Qlik, and Microsoft are the leader in Analytics and Business Intelligence Platforms. The full Gartner url is at the bottom. The Gartner link will be expired in sometime later, that was my experience with Gartner … Continue reading →

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

Outlook display receiver instead of sender in folder

Posted on February 28, 2018 by chanmingman

This post show you how to change the Outlook folder to display receivers instead of senders. This is for Outlook 2013. Go to VIEW tab. Click View Settings. Click Columns. Select From in Show these columns in this folder. Click … Continue reading →

Posted in Microsoft Office, Office 365 | Tagged , , | Leave a comment

SSIS Web Service Task Unable to connect to the remote server

Posted on February 25, 2018 by chanmingman

This blog post shows one of the possibilities to resolve the error below in SSIS Web Service Task [Web Service Task] Error: An error occurred with the following error message: “Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The Web Service threw an error during method execution. … Continue reading →

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

SSIS Web Service Task Client found response content type of ‘text/plain; charset=utf-8’, but expected ‘text/xml’

Posted on February 22, 2018 by chanmingman

This blog post shows you one of the ways to resolve the error “The Web Service threw an error during method execution. The error is: Client found response content type of ‘text/plain; charset=utf-8’, but expected ‘text/xml’.” when you are calling … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet | Tagged , , , | 4 Comments

SSIS Script Task System.RuntimeMethodHandle.InvokeMethod

Posted on February 21, 2018 by chanmingman

This blog post shows one of the possibilities to resolve SSIS error “at System.RuntimeMethodHandle.InvokeMethod” when using Script Task. I have the below code in my SSIS Script Task: ConnectionManager cm; cm = Dts.Connections[“uCustoms”]; SqlConnection sqlConn; sqlConn = (SqlConnection)cm.AcquireConnection(Dts.Transaction); cm.ReleaseConnection(sqlConn); This … Continue reading →

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

How to unlock your USB ports

Posted on February 15, 2018 by chanmingman

This blog shows you how to unlock your USB port if it is locked by your group policy. First, you need to disable the group policy following this link: https://chanmingman.wordpress.com/2015/07/22/disable-group-policy/ To unlock USB you must have local administrator privilege. Run … Continue reading →

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

Update XML Node value using C#

Posted on February 13, 2018 by chanmingman

This blog show you the sample code to update the XML file content. Let say we have the following XML file. <?xml version=”1.0″ encoding=”utf-8″ ?> <Vessel>     <IMO>392060</IMO>     <SCN>1234567890123</SCN>     <VesselId>6535</VesselId> </Vessel> To get the XML … Continue reading →

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

SQL Server Database Mail not sending out email when your job failed

Posted on February 8, 2018 by chanmingman

This blog is to resolve Database Mail not sending out email when your job is failed. There is one of the possibilities as follow. In Object Explorer, expand a SQL Server instance. Right-click SQL Server Agent, and then click Properties. Click Alert System. … Continue reading →

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

The Future Computed: Artificial Intelligence and its role in society free ebook

Posted on February 4, 2018 by chanmingman

This is an ebook that is quite easy to read, 151 pages. https://blogs.microsoft.com/blog/2018/01/17/future-computed-artificial-intelligence-role-society/?MC=MachLearn&MC=Vstudio&MC=R&MC=WebDev&MC=MSAzure The Future Computed: Artificial Intelligence and its role in society. The two of us have written the foreword for the book, and our teams collaborated to write … Continue reading →

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