Posts by agoddard
Azure Containers
Azure Containers Just as Virtual Machines or “VMs” virtualize physical machines, Containers virtualize operating systems. Containers are designed to “bundle” what is minimally required (executables, binary code, libraries, and configuration files) to run a tiny microservice or a huge application in any environment. Containers thus provide an easy way to run applications without having to manage…
Read MoreHow Do I Create a Simple Azure App Service Web App?
The Azure App Service is a Platform as a Service (or PaaS) offering from Microsoft. It’s a component that provides resources for deploying web applications and for making deployed web applications accessible by HTTP clients. You can use it to host web applications, REST API’s and backend services for mobile applications in almost any programming language…
Read MoreHow Do I Use Azure Cosmos DB to Create a NoSQL Database and Manage Data?
Azure Cosmos DB is a fully managed NoSQL database designed for modern app development. Microsoft states that “…any web, mobile, gaming, and IoT application that needs to handle massive amounts of data, reads, and writes at a global scale with near-real response times for a variety of data will benefit from Cosmos DB…”. In this post I want to demonstrate…
Read MoreHow Do I Create and Run a Docker Application Using a Python Script and Dockerfile?
Create a project To create a Docker application, you need an application and a (Docker) image file. In this example we’ll use a very simple Python script as the application, so we have to create 2 files: A “py” file (the python script that will contain the code to be executed) A ‘Dockerfile’ file (the…
Read MoreHow Do I Use pgAdmin to Explore and Manage PostgreSQL Databases?
PostgreSQL is a powerful, open-source object-relational database system with 30+ years of active development that has earned it a formidable reputation for reliability, feature robustness, and performance. In this post I want to show how you can get started quickly with PostgreSQL by creating a sample database and running some simple queries against it using…
Read MoreHow Do I Use the SQL GROUP BY Statement to Aggregate Data in Queries?
So far, we have gone over the SELECT, FROM and WHERE clauses. These three clauses are used to control what we are seeing in a view. What if we want to control how what we are searching for appears in the view, that is where GROUP BY comes in. The GROUP BY clause is used…
Read MoreHow Do I Use the SQL ORDER BY Statement to Sort Query Results?
Similar to the GROUP BY clause, the ORDER BY clause also determines how the data is displayed in the view and not so much what the view is displaying. The ORDER BY clause controls the order in which records appear in a view. The order can be determined by the numerical magnitude if it is…
Read MoreWhat Are SQL Joins and How Do I Use Them to Combine Data from Multiple Tables?
Now that we have set a basis for how to control a view from one table, we should have enough knowledge to tackle how we incorporate information from two or more tables into one view. Joining in SQL is extremely useful and is used time and time again in a relational database. Often times we…
Read MoreEuclid Studio: Navigating the Business Rules Node
Using the Business Rules Node in Euclid Studio is an extremely effective way of managing business rules, giving you total control over their scope and impact. It’s important to understand the tool’s options and settings before adjusting or implementing new rules. In this example, we’ll go through the basic options and settings of the node.…
Read MoreEuclid Studio: Connecting to a database via JDBC
When using an ETL and modeling tool like Euclid Studio, it’s extremely likely that you’ll want to access your relational databases. The following steps will walk you through configuring a JDBC connection within a Euclid Studio flow. Once you’ve logged into Euclid Studio and created/opened your flow, hover over the ‘Server’ menu at the top…
Read More