Author

Service Oriented Architecture‎ (SOA)

Service-oriented architecture (SOA) is a style of software design where services are provided to the other components by application components, through a communication protocol over a network. The basic principles of service-oriented architecture are independent of vendors, products and technologies. A service is a discrete unit of functionality that can be accessed remotely and acted upon... » read more

C# Data Contracts

A data contract is a formal agreement between a service and a client that abstractly describes the data to be exchanged. That is, to communicate, the client and the service do not have to share the same types, only the same data contracts. A data contract precisely defines, for each parameter or return type, what data... » read more

TSQL Convert

DATETIME to DATE and TIME Should I use CAST or Convert? Unless you have some specific formatting requirements you’re trying to address during the conversion, I would stick with using the CAST function.  There are several reason I can think of: CAST is ANSI-SQL compliant; therefore, more apt to be used in other database implementation.... » read more

TSQL CAST

INT to VARCHAR DATETIME to DATE and TIME Should I use CAST or Convert? Unless you have some specific formatting requirements you’re trying to address during the conversion, I would stick with using the CAST function.  There are several reason I can think of: CAST is ANSI-SQL compliant; therefore, more apt to be used in... » read more

Windows Communication Foundation (WCF)

WCF is a service layer that allows you to build applications that can communicate using a variety of communication mechanisms. With it, you can communicate using Peer to Peer, Named Pipes, Web Services and so on. Windows Communication Foundation (WCF) is a framework for building service-oriented applications. Using WCF, you can send data as asynchronous... » read more

Application Layers

Layer Used For Web Application Public facing site used by the user. WCF Service Windows Communication Foundation (WCF) Facade Serves as a front-facing interface masking more complex underlying or structural code. Business Object Enable designers to design software in manageable pieces by breaking the business down into a modular form. Data Access Object Provides an... » read more

Generate PFX (Private Certificates) from Key file and Certificate file using Open SSL

Obtain private key from SSL site.  Download directly from browser. mydomain_com_key.txt Company will send you the cert files in email. mydomain_com.crt Download OpenSSL for Windows https://slproweb.com/products/Win32OpenSSL.htmlC:\Program Files\OpenSSL-Win64\bin\openssl.exe Generate PFX (Private Certificates) from Key file and Certificate file. Provide a password https://www.ssl.com/how-to/create-a-pfx-p12-certificate-file-using-openssl/ Private Key (from download) + Certificate (from email) = PFX file (via OpenSSL) Source:... » read more

Pageant Key List

When you run Pageant, it will put an icon of a computer wearing a hat into the System tray. It will then sit and do nothing, until you load a private key into it. If you click the Pageant icon with the right mouse button, you will see a menu. Select ‘View Keys’ from this menu.... » read more