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.

Oracle Oracle.DataAccess.Client.OracleException ORA-01843: not a valid month

This post shows how to resolve the error “Oracle.DataAccess.Client.OracleException ORA-01843: not a valid month” when using C# to insert or update the data with date. In my below statement I have SS_COMPLETED is a date column. I want to update … Continue reading

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

CREATE FILE encountered operating system error 5(Access is denied.)

This post is showing you how to resolve the following error. This error has happened to me when I was trying to Attach a database. CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create … Continue reading

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

SQL Server find a column name in databases

The post gives a common useful SQL statement that finding a column name in databases. I always looking for it again and again, so I decided on to put this statement into the blog. The example below is to find … Continue reading

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

Find Long Running SQL Server Queries Using SQL Profiler

This post shows you how to achieve the steps in this article https://www.mssqltips.com/sqlservertip/4401/find-long-running-sql-server-queries-using-profiler/. What this video is doing is find the sql queries that are running longer than 10 seconds. We choose the event SP_StartCompleted and SP_Completed. We filter by … Continue reading

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

SQL Server 6.0 documentation

This is a short SQL Server 6.0 documentation I found in Internet so I just keep a copy and share it. https://1drv.ms/b/s!Aje-DdIVpfjSgiht9NahsmhAldEq?e=LIIQEk

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

70-229 SQL2000 Design

This is a book that I use for my MCSD back then. Should be legal to share it today. https://1drv.ms/u/s!Aje-DdIVpfjSgiWHJSVTi67I3kd1?e=n346V7

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

Excel cell data type

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