Author Archives: chanmingman

About chanmingman

Since March 2011 Microsoft Live Spaces migrated to Wordpress (http://www.pcworld.com/article/206455/Microsoft_Live_Spaces_Moves_to_WordPress_An_FAQ.html) till now, I have is over 1 million viewers. This blog is about more than 50% telling you how to resolve error messages, especial for Microsoft products. The blog also has a lot of guidance teaching you how to get stated certain Microsoft technologies. The blog also uses as a help to keep my memory. The blog is never meant to give people consulting services or silver bullet solutions. It is a contribution to the community. Thanks for your support over the years. Ming Man is Microsoft MVP since year 2006. He is a software development manager for a multinational company. With 25 years of experience in the IT field, he has developed system using Clipper, COBOL, VB5, VB6, VB.NET, Java and C #. He has been using Visual Studio (.NET) since the Beta back in year 2000. He and the team have developed many projects using .NET platform such as SCM, and HR based applications. He is familiar with the N-Tier design of business application and is also an expert with database experience in MS SQL, Oracle and AS 400.

Power BI find Percentage on 2 columns in 2 different table

This post is showing how to find an average if you have sum of 2 columns in 2 different tables. For example, I have Sales 1 in Sheet 1. I have Sales 3 in Sheet 2. You will think to … Continue reading

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

Sql Server Remove all tables

This post shows you how to remove all the tables in a database. Sometime you just need to refresh all the table but you don’t want to keep deleting and creating the same database. The sql statements below work for … Continue reading

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

SQL Server on Linux Posts You Might Find Helpful

This post get have the useful links to SQL Server on Linux. Wanted to share a few links based on various conversions with you all https://blogs.msdn.microsoft.com/bobsql/2018/12/18/sql-server-on-linux-forced-unit-access-fua-internals/ https://blogs.msdn.microsoft.com/bobsql/2018/12/18/sql-server-linux-fsync-and-buffered-i-o/ https://blogs.msdn.microsoft.com/bobsql/2018/12/18/sql-server-linux-directory-fsync-activities/ https://blogs.msdn.microsoft.com/bobsql/2018/12/10/sql-server-instant-file-initialization-setfilevaliddata-windows-vs-fallocate-linux/ Previous Posts involving Linux you may also find handy: https://blogs.msdn.microsoft.com/bobsql/2018/07/31/sql-server-on-linux-how-is-delete-on-close-handled/ https://blogs.msdn.microsoft.com/bobsql/2018/07/18/sql-server-on-linux-why-do-i-have-two-sql-server-processes/Continue reading

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

SQL Agent System.Runtime.InteropServices.COMException: Microsoft Excel cannot access the file

This post shows you one of the possible ways to resolve the error when you are running SQL Agent job and you keep getting the error “System.Runtime.InteropServices.COMException: Microsoft Excel cannot access the file”. The complete message is the one below. … Continue reading

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

SSIS Script Task Read Write Variable

This post I wanted to post for quite a while but keep forgetting. In order to use Variable in SSIS Script Task there is no Intellisense. You have to remember the exact syntax for it. Very first you need to … Continue reading

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

SSIS Edit Script… not openning

This post shows you one of the remedies when your Edit Script in SSIS is not opening in Visual Studio 2017. When you need to do is to uninstall the SSDT. Reinstall it with the option Install new SQL Server … Continue reading

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

MS Access VBA accessing to SQL Server

This article expect you know how to create a Form with a button in Microsoft Access. Like it or not they are still many Microsoft Access users out there today, like a group that I am teaching today. Unfortunately C# … Continue reading

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