Monthly Archives: November 2017

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

Oracle Developer Tools for Visual Studio 2017

This short writing is showing you where to get Oracle Developer Tools for Visual Studio 2017. It is test installing successfully. You can see the Tools available after the installation. You will find Oracle.ManageDataAccess which is IIS friendly as compare … Continue reading

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

Managing SOA using Visual Studio with SQL Server Data Tools

This short article will show you how to manage Service Oriented Architecture (SOA) using Visual Studio with SQL Server Data Tools (SSDT). Let’s review the components in SOA Adapter, Business Process Modeling, Service Broker, SOA Governance, SOA Registry (https://chanmingman.wordpress.com/2017/10/24/do-you-need-enterprise-service-bus/). Adapter: … Continue reading

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