Category Archives: .Net

Message=ORA-01843: not a valid month

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’

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

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

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

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

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

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 , , | Leave a comment