Monthly Archives: November 2017

SSMS Upgrade from 17.x to 17.3

Posted on November 26, 2017 by chanmingman

This blog shows you SSMS Upgrade from 17.x to 17.3 without first uninstall the existing SSMS. Previously to upgrade SSMS I need to manual the previous version of SSMS until this version, 17.3. I was using 17,1, when I have … Continue reading →

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

Passing PRINCE2 Foundation Exam

Posted on November 26, 2017 by chanmingman

This short article gives you some hints to pass PRINCE2 Foundation Exam. As many sources out there to help me to pass this exam. Go to the file share here https://1drv.ms/f/s!AuZYHSwsevw1hh1FT8nTPAMItRrq. The key sample question file sorted by ranked of … Continue reading →

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

DateTime.ParseExact String was not recognized as a valid DateTime

Posted on November 25, 2017 by chanmingman

This short blog shows one of the possible causes of the error “String was not recognized as a valid DateTime”. You have a code CultureInfo provider = CultureInfo.InvariantCulture; DateTime dte = DateTime.ParseExact(“2017-07-28”, “YYYY-MM-DD”, provider); The code seems fine but actually … Continue reading →

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

Message=ORA-01843: not a valid month

Posted on November 23, 2017 by chanmingman

This short blog is to resolve .NET C# insert a record to Oracle table with date format You will very likely get the error Message=ORA-01843: not a valid month when you insert a record to Oracle table with date format … Continue reading →

Posted in .Net, Community, Oracle | Tagged , , | Leave a comment

Visual Studio 2015 an error occurred while importing settings for ‘all languages’

Posted on November 22, 2017 by chanmingman

This short blog shows you how to resolve the error “error occurred while importing settings for ‘all languages’” in Visual Studio 2015. When you login to certain users on your computer beside Administrator then you might not see any project … Continue reading →

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

Microsoft Kerberos Configuration Manager for SQL Server

Posted on November 18, 2017 by chanmingman

Why Kerberos? Kerberos authentication provides a highly secure method to authenticate client and server entities (security principals) on a network. To use Kerberos authentication with SQL Server, a Service Principal Name (SPN) must be registered with Active Directory, which plays … Continue reading →

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

SSMS 17.3 New Import Flat File Wizard

Posted on November 17, 2017 by chanmingman

This short writing lets you know the New Import Flat File Wizard in SSMS 17.3. Import Flat File is one of the most common features to use for any kind of developer. The new import flat file wizard will get … Continue reading →

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

SQL Server Create parent child XML using Select

Posted on November 15, 2017 by chanmingman

I have a parent and child table in SQL Server database. The parent table name ATAHeader SELECT Header.txnDateTime, Header.[fileName] FROM ATAHeader Header The child table name ATA SELECT ATAInformation.[MCKey], ATAInformation.[MCValue], ATAInformation.SCN FROM [dbo].[ATA] ATAInformation We would like to produce the … Continue reading →

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

Disable Hexadecimal value in Visual Studio

Posted on November 8, 2017 by chanmingman

This short writing is for the Visual Studio displaying Hexadecimal during debugging. To turn it off just right the variable in the Locals Windows and uncheck the Hexadecimal Display.

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

Convert Excel Sheet to csv file for SSIS

Posted on November 6, 2017 by chanmingman

You can use the code below to concert Excel to csv. You need to add the Microsoft.Office.Interop.Excel. The reason I am doing this is, I have been facing many issues to read the Excel from SSIS to the database for example, … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office | Tagged , , | 1 Comment