Monthly Archives: July 2018

SQL Azure resources in Windows Azure that you might need

Posted on July 31, 2018 by chanmingman

This post is to show the minimum resources I have to access to a SQL Azure database using SQL Studio Management Studio. Kind of hard that there are too many dependencies in Windows Azure that you can know that at … Continue reading →

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

The requested URI is invalid for this FTP command

Posted on July 29, 2018 by chanmingman

This post shows you one of the possible problems with C# ftp code upload. The below code will give you the error “The requested URI is invalid for this FTP command”. Uri uri = new Uri(@”ftp://localhost”); FtpWebRequest request = (FtpWebRequest)WebRequest.Create(uri); … Continue reading →

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

SQL Server Create Database Object reference not set to an instance of an object C#

Posted on July 19, 2018 by chanmingman

This post shows you one of the possible cause for the error message “”Object reference not set to an instance of an object C#”. When you create database using C# on SQL Server then you get the following error. ‘ex.Message’ … Continue reading →

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

Power BI tables relationship

Posted on July 14, 2018 by chanmingman

The post shows you how to ensure the relationship between 2 tables in Power BI. This is also request from a friend. Let’s say in my Excel I have 2 Worksheets one named Categories and Products. Obviously they have relationship. … Continue reading →

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

SSMS The Microsoft Office Access database engine could not find the object

Posted on July 12, 2018 by chanmingman

This post shows you one of the possible problems of the error “The Microsoft Office Access database engine could not find the object” when you are Export from SQL Server database table to Excel. The full error will be like … Continue reading →

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

Power BI conditional format for only one row of data

Posted on July 8, 2018 by chanmingman

This post dhows can how to put color on single row of data in a table. When you see the below dashboard there is a table with Item and Score. The Score with green and red color. Somehow this will … Continue reading →

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

SSMS SQL Server Profiler

Posted on July 4, 2018 by chanmingman

This post is showing you how to use the stand alone SQL Server Profiler with the SQL Server Management Studio. SQL Server Profiler used to come with SQL Server Standard Edition and above. When I have downloaded the SSMS for … Continue reading →

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

XMLTools.dll is not compatible with the current version of Notepad++

Posted on July 3, 2018 by chanmingman

This post shows you a possible solution for the error “XMLTools.dll is not compatible with the current version of Notepad”. I am using Notepad++ version 7.5.1/ XMLTool, Xml Tools 2.4.9.2 x64 Unicode.zip. Once you unzip the Xml Tools 2.4.9.2 x64 … Continue reading →

Posted in Community, Computers and Internet | Tagged , | 2 Comments