XML Made Easy – LINQ to XML

LINQ to XML is an in-memory XML programming interface that enables XML manipulation. Similar to the more traditional Document Object Model (DOM), LINQ to XML brings XML documents into memory and lets you query and modify them before saving the results to a file or data stream. What is different from the DOM is the new, lighter, and more intuitive object model and LINQ integration.

CodingSight - LINQ to XMl
Read More

Upload Files to AWS S3 with the AWS CLI


Amazon Web Service, aka AWS, is a leading cloud infrastructure provider for storing your servers, applications, databases, networking, domain controllers, and active directories in a widespread cloud architecture. AWS provides a Simple Storage Service (S3) for storing your objects or data with (119’s) of data durability. AWS S3 is compliant with PCI-DSS, HIPAA/HITECH, FedRAMP, EU Data Protection Directive, and FISMA that helps satisfy regulatory requirements.

CodingSight - aws cli upload to s3
Read More

Introducing LINQ to Entities

When we think about querying databases, the first thing that pops to mind is usually some SQL query. Then other questions arise in regards to the database type, connection, query design, etc.

LINQ to Entities combined with Entity Framework allows the developers to skip a big portion of these questions and worries.

Entity Framework handles the database structure and connection while LINQ to Entities gives the possibility to write database queries in the same way as for any other data collection operation with LINQ.

CodingSight - Introducing LINQ to Entities
Read More

How to Protect MySQL Databases from Ransomware Campaigns

MySQL is known for being easy to use and highly secure. That’s why it is the number one choice for many organizations, including the biggest brands like Facebook, Google, Uber, and YouTube. Because it’s open-source, it’s free to use and modify even for commercial purposes. But although it can be very secure, the security features are not always utilized properly.

Cybercriminals are good at finding ways to exploit the masses. Ransomware attacks have penetrated everything from cities, schools, and hospitals to large and small businesses. Victims are tricked to allow malicious programs into their systems where those programs lock files until getting ransom. Organizations of all kinds that use MySQL and other database management systems are at risk of attacks.

CodingSight - How to Protect MySQL Databases from Ransomware Campaigns
Read More

How to Trigger Lambda Function in Amazon Web Services

When we think about a cloud solution provider, we often consider the most popular ones, i.e. Amazon Web Services, Microsoft Azure, and Google Cloud Platform. There are other popular providers (IBM, Oracle, etc.), but the three giants take the lion’s share of the market. Hence, companies prefer migrating their architectures to them. Amazon is a leader with over 200 web services currently, and it adds more every month.

CodingSight - AWS Lambda and Auto-triggering its Functions
Read More

Introduction to Advanced Analytics Features in Oracle Analytics

Advanced Analytics is a mandatory trend for Business Intelligence platforms and Self-service Analytics tools. It offers a set of statistic functions and algorithms, such as trending, forecast, etc. They help business users, analysts, and others specialists to deep dive into data insights for making better business decisions.

The current article is the first part of the series dedicated to the usage of Advanced Analytics with Oracle Analytics and data hosted in Oracle Autonomous Data Warehouse (ADW). It is not going to cover all the details about statistic functions, algorithms, or probability functions. We are going to discover prebuilt Advanced Analytics features developed in Oracle Analytics.

CodingSight - Advanced Analytics with Oracle Analytics Part 1
Read More

Introduction to AWS Lambda Layer with Examples

AWS Lambda is an event-driven, serverless cloud computing service provided by Amazon, a part of the Amazon Web Services. It responds to multiple events like uploading files to S3, clicks on websites, etc. Then, it takes action based on the trigger.

AWS Lambda supports multiple programming languages, such as Node, Python, C# (using dot net core), etc. For each of them, multiple runtime versions are supported. For example, it is possible to develop Python applications that target multiple versions of the runtime (3.6, 3.7, and 3.8).

Lambda functions are also known as serverless, as you do not need provisioning any infrastructure to run your applications. You can just write the code, deploy it to Lambda, and get it executed.

CodingSight - Layers in AWS Lambda Functions
Read More