Tech Blog: Sharing on the Go..

Capturing Request Headers (IP Address, User-Agent) in a SOAP BPEL Process within Oracle SOA Composite In today’s enterprise applications, especially those based on Service-Oriented Architecture (SOA) , security and auditing are critical requirements. One important aspect of this is capturing the metadata of incoming requests, such as the client’s IP address and User-Agent . Oracle SOA Suite provides a powerful platform for building composite applications that can benefit from capturing this kind of metadata for better monitoring, auditing, and compliance. In this blog, we’ll walk you through how to access and log HTTP request headers, like IP address and User-Agent , from a SOAP BPEL process in Oracle SOA using Java embedding . Why is Capturing HTTP Headers Important? HTTP headers are a vital source of information that can help: Track request origin : Identify which client or system is making the request. Security audits : Record and analyze IP addresses to trace suspicious activit...

Changing the Default SSH Port on Windows Server 2019: A Step-by-Step Guide By default, SSH uses port 22 for all connections. However, for enhanced security or due to policy requirements, it may be necessary to change this default port. In this guide, we'll walk you through how to change the SSH port on Windows Server 2019 . Changing the default port not only reduces the chances of brute-force attacks but also minimizes exposure to potential vulnerabilities. Let's get started! Why Change the Default SSH Port? Changing the default SSH port can offer several advantages: Security : Automated scripts often target the default SSH port (22). Changing it can prevent many basic attacks. Compliance : Certain compliance regulations or internal policies may require the use of non-standard ports. Segregation : If multiple services are running on the same server, different ports can be used for easier management and separation. Prerequisites Before proceeding, ensure that you: Have administ...

  Setting Up SSH on Windows Server 2019 and Securely Connecting to a Database Server via SSH Tunneling In this blog post, we'll build on the previous topic of using SSH tunneling to connect to a remote database server. Specifically, we’ll show you how to set up SSH on Windows Server 2019 (acting as the App Server ) and securely connect to a database server from a local PC via that app server. By setting up an SSH tunnel, you can bypass restrictions like firewalls or network configurations while maintaining security. What is SSH Tunneling? SSH tunneling, or port forwarding, is a method of securely forwarding network traffic from a local machine to a remote server. In this scenario, the app server acts as a bridge, forwarding traffic from your local machine to the database server . Why Use SSH Tunneling? Secure access to the database from a remote machine. Bypass network restrictions when the database server is not accessible directly. Encrypt traffic , ensuring that sensitive d...

Building a Dynamic Query Executor for SQL Server and Oracle in ASP.NET Web Forms - II  To complete the ExecuteSqlServerQuery method as well as the ExecuteOracleQuery method, we need to handle different types of SQL operations (e.g., SELECT , INSERT , UPDATE , DELETE ) and manage the execution of the queries appropriately. Here’s how you can structure these methods: ExecuteSqlServerQuery Method Definition This method will handle SQL Server queries, detecting whether the query is a SELECT or a data-modifying operation like INSERT , UPDATE , or DELETE . For a SELECT query, it will display the results in a GridView , while for the others, it will return the number of rows affected. csharp Copy code private void ExecuteSqlServerQuery ( string connectionString, string query ) { using (SqlConnection conn = new SqlConnection(connectionString)) { try { conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); SqlDat...

  Building a Dynamic Query Executor for SQL Server and Oracle in ASP.NET Web Forms In modern web applications, there are often scenarios where users need the flexibility to run dynamic queries against a database directly from a web interface. This is especially useful for admin tools, reporting dashboards, or troubleshooting interfaces where access to the database needs to be quick and easy. Today, we'll walk through building an ASP.NET Web Forms page that allows users to run queries against either SQL Server or Oracle databases with a flexible, user-friendly interface. In this blog post, we'll cover the following: Why a Dynamic Query Executor is Useful Building the ASP.NET Web Forms Page Supporting Different Types of Queries (SELECT, INSERT, UPDATE, DELETE, Procedures, Views) Handling SQL Server and Oracle Connections Securing the Application with Parameterized Queries Testing and Running the Application Let’s dive into the solution! Why a Dynamic Query Executor is Useful A ...

  Performing Bulk Updates in SQL Server Using C# While Maintaining Data Integrity and Enforcing Constraints In enterprise applications, bulk updates in a SQL Server database are common, especially when handling large datasets, such as updating inventory, financial records, or user profiles in bulk. However, performing these updates efficiently without compromising data integrity is essential to avoid data corruption and maintain consistency. In this blog post, we will explore how to perform bulk updates in SQL Server using a C# application , while ensuring that constraints like foreign keys , unique constraints , and triggers are respected. Key Considerations for Bulk Updates Before jumping into implementation, there are a few key considerations to keep in mind when performing bulk updates: Data Integrity : Ensure that the bulk updates do not violate database integrity by maintaining relationships between tables, ensuring valid data formats, and handling any triggers. Constra...