Introduction to Amazon RDS

AWS has hundreds of services available through their console or through their SDK. Amazon RDS is one of the most commonly used services. Amazon RDS standards for Relational Database Service – essentially it’s a large collection of different SQL databases.

Continue reading

AWS Tools to Optimize and Reduce AWS Costs

Cloud costs can become expensive really fast if we aren’t consistently tracking and modelling our expenses. There are a number of ways that we can track our costs leading to a lower total cost.

AWS Cost Explorer

In the AWS User Interface, we are able to use a service called Cost Explorer which gives us an interface to look at our costs by service, by cost tag, and looks at predictions for the next three months based on current usage. AWS also gives potential recommendations on how to reduce costs.

AWS Budgets

The AWS Budgets interface allows us to track cost per service, service usage, and our reserved instance utilization. Reserved Instances are a commitment to use a certain service or EC2 instance for a length of time which results in a billing discount from AWS. I’ve seen discounts as high as 72% if you’re willing to commit to three years and pay upfront.

AWS TCO Calculator

The AWS TCO Calculator allows technology departments or architects to determine what could be saved by leveraging cloud infrastructure.

AWS Simple Monthly Calculator

The Simple Monthly Calculator is an easy way to determine the rough costs for running specific AWS infrastructure. It’s suppose to be deprecated soon but the Pricing Calculator doesn’t have all of the same features today.

AWS Resource Tags

AWS Resource Tags are metadata that is assigned to a specific resource in the AWS account. They’re a great way to track usage across departments, environments or projects. The Cost Allocation Report can include costs grouped by active tags.

The tags can also be utilized in the AWS Cost Explorer to better understand the costs and better allocate costs against departments, projects or environments. I love to use Resource Tags to reference the various environments (dev, staging, and production).

Generating A PDF in Nodejs

The PDF format is one of the most common file formats for transmitting static information. It’s a really common request for businesses to be able to export a document or data into a really well-formatted PDF file whether it be an invoice or a report.

Continue reading

NetSuite: View Recent Logins

Auditing the number of users and who the power users are of NetSuite is unfortunately one of those things Administrators need to do just as the company begins it’s renewal process. Answering questions like can we reduce the number of users and save dollars is always important.

In NetSuite, it’s pretty easy to see who is regularly using the software. To do this, we simply need to sign in as an Administrator so we can Use the Login Audit Trail. To access it we simply go to Setup -> Users/Roles -> View Login Audit Trail

The Login Audit Trail is a prebuilt search that allows us to filter results by user, by role, or by a specific date rate. The form will load and then we’re able to see the results by clicking “Submit”.

And then, you’ll see a page of the results with the login date, email address, user’s name, the Role they used, the IP address, and whether it was successful or not.

What I then do is export the list and build a pivot table with the user’s name and the count of sign ins to better understand who my power users are.

Hope this helps!

Common Reasons Salesforce Integrations Fail

Moving data between systems consistently through an integration can be difficult especially given all of the limits that Salesforce throws at us!

The purpose of this blog post is talk about all of the common reasons that a Salesforce integration could fail.

Continue reading