Monthly Archives: May 2018

PL SQL using NOT IN instead of NOT EXISTS

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

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

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

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

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

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

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