Monthly Archives: May 2018

PL SQL using NOT IN instead of NOT EXISTS

Posted on May 31, 2018 by chanmingman

This post show how to use NOT IN in Oracle PL SQL I have 2 table service_request_dtls, and SERVICE_REQUEST_HDR. I want to filter ACT_STATUS in service_request_dtls table when the value is “WIP” but not “SOL”. Below is my first attempt … Continue reading →

Posted in Community, Computers and Internet, Oracle | Tagged , | Leave a comment

Visual Studio 2017 installation problems

Posted on May 21, 2018 by chanmingman

This short post shows the issues many countries will face while installing Visual Studio 2017 Today, if you download the offline installation files for Visual Studio 15.7 is 42.8 GB as compare to 23.3 GB for Visual Studio 2017 15.0.0. … Continue reading →

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

Free ebook Azure Quick Start Guide for .NET Developers

Posted on May 18, 2018 by chanmingman

This is a nice ebook for you to know most of the key services in Azure. This is not the book that will give you a complete running samples. It provides high overview but leave with many arguable such as … Continue reading →

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

VSTS Iterations not appear in Work

Posted on May 17, 2018 by chanmingman

This blog shows you how to add iteration to your Work area. Let’s say you have Sprint up to 22. Somehow when you click on Work in your VSTS you only see up to Sprint 20. Click on the Gear. … Continue reading →

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

SSIS The connection “” is not found

Posted on May 17, 2018 by chanmingman

This blog shows you how to get the SSIS component that generates the error such as “The connection “{6A2BEE57-1779-4B4F-9573-116F568F928F}” is not found” in your SSIS package. When you open your SSIS Package dtsx, you might see the dialog below pop … Continue reading →

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

Skype for Business App no audio

Posted on May 16, 2018 by chanmingman

When you browse to Skype for Business meeting using Chrome, and it will prompt you the following screen to start Skype for Business App. In some cases, your meeting start without audio after it has started. This what you need … Continue reading →

Posted in Cloud, Community, Computers and Internet, Office 365 | Tagged , , , | Leave a comment

Microsoft.SqlServer.Dts.Runtime missing

Posted on May 15, 2018 by chanmingman

This short blog just to show you where can you get the Microsoft.SqlServer.Dts.Runtime namespace. There is no such thing as Microsoft.SqlServer.Dts.Runtime.dll The namespace is in Microsoft.SQLServer.ManagedDTS.dll. My one is located at: C:\Program Files (x86)\Microsoft SQL Server\120\SDK\Assemblies\ Microsoft.SQLServer.ManagedDTS.dll

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

JavaScript runtime error: ‘Excel’ is undefined

Posted on May 14, 2018 by chanmingman

This blog shows you the cause of the error “JavaScript runtime error: ‘Excel’ is undefined”. There is a solution but might not resolving your problem. When I run my Add-ins in Office 2013 Excel then I got the error “JavaScript … Continue reading →

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

Windows ML Visual Studio 2017

Posted on May 10, 2018 by chanmingman

This short post just to show you how to get started with Windows ML code running in Windows 10, you must have a Windows 10 to do this. Do not confuse Windows Machine Learning and Azure Machine Learning. There are … Continue reading →

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

SSIS deploy a project to Azure SSIS Integration Runtimes

Posted on May 9, 2018 by chanmingman

This blog is showing you it is not straightforward to deploy a SSIS Project to Azure SSIS Integration Runtimes for now. It might get easier or it may not. The first thing you need is Sql Server Management Studio at … Continue reading →

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