Monthly Archives: July 2019

Excel cell data type

Posted on July 28, 2019 by chanmingman

This post shows you a workaround to handle Excel data type. The Excel empty cell data type does not belong to any common type such as string, integer, or datetime. The data type is actually called System.RuntimeType. So if you … Continue reading →

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

Connect to Azure SQL Database using Visual Studio

Posted on July 25, 2019 by chanmingman

This post lets you know the additional steps that you can use Visual Studio to connect the Azure SQL database that you have just created using the instruction here https://docs.microsoft.com/en-us/azure/sql-database/sql-database-single-database-get-started?WT.mc_id=gallery&tabs=azure-portal. After you create a Azure SQL Database at 9.On the … Continue reading →

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

SharePoint Site Contents doesn’t load in Chrome

Posted on July 19, 2019 by chanmingman

This post shows you a quick fix when your SharePoint Site Contents doesn’t load in Chrome. You can check through the Internet people is talking about Ad Blocker like this one, https://techcommunity.microsoft.com/t5/SharePoint/Site-Contents-doesn-t-load-in-Chrome/td-p/59227. For me, there is one versions of Chrome … Continue reading →

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

SSIS convert Excel IF to Derive Column component

Posted on July 16, 2019 by chanmingman

This post shows how to convert Excel IF function to SSIS Derive Column component. In Excel you have the expression as below. =IF([@[REHANDLE_REASON]]=”TERMINAL”,”RHCDCTERM”,IF([@[REHANDLE_REASON]]= “VESSELOP”,”RHCDCOPER”,IF([@[REHANDLE_REASON]]=”NONE”,IF([@[move_kind]]= “UNIT_DISCH”,”DISCHARGE”,IF([@[move_kind]]=”UNIT_LOAD”,”LOAD”,””))))) You will convert to SSIS Derive Column as below. You release in Excel you ended … Continue reading →

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

Generate all SQL Agent Jobs

Posted on July 14, 2019 by chanmingman

This post will provide you the code to generate all SQL Agent Jobs in a single server. Copy and paste code here display horrible. I will post the github link here for you to reach the code. https://github.com/chanmmn/ConAppSQLAgentJobs

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

SQL Agent Job email notification not working

Posted on July 13, 2019 by chanmingman

This article shows you one of the possible reasons why your SQL Agent Job does not send out notification when error. You have setup Database Mail. You have setup an Operator. You have also created a SQL Agent Job with … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | 1 Comment

Where to get Microsoft.SqlServer.Management.Common dll

Posted on July 11, 2019 by chanmingman

This blog showing you get Microsoft.SqlServer.Management.Common dll. When you see the code using Microsoft.SqlServer.Management.Common; I will not be a Microsoft.SqlServer.Management.Common dll, rather, the Microsoft.SqlServer.Management.Common is in Microsoft.SqlServer.ConnectionInfo dll.

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

PowerPoint screen recording not working

Posted on July 7, 2019 by chanmingman

In one of my previous blog https://chanmingman.wordpress.com/2019/07/07/record-video-using-powerpoint/, I show you have to enable screen capturing or recording using PowerPoint. I have come to realize that, in order for mine recording to work. I cannot disable my Microphone, https://chanmingman.wordpress.com/2019/07/06/windows-turn-off-microphone/. Of course, … Continue reading →

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

Record video using PowerPoint

Posted on July 7, 2019 by chanmingman

This blog showing you how to record video using Microsoft PowerPoint. My version is Office 365 Pro Plus. When you stat PowerPoint click File. Click Options. Choose Customize Ribbbon. Check the Recording.

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365, Uncategorized | Tagged | 3 Comments

Windows 10 Turn off microphone

Posted on July 6, 2019 by chanmingman

This post is showing you how to turn off your microphone in Windows 10. In Windows 7 you may not have this option beside disable your microphone device using Device Manager. In Windows 10 you can press Start. Go to … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Operating System | Tagged | 1 Comment