Over time, Salesforce orgs get more and more complicated especially when a consultant, admin or developer leaves the organization with their knowledge of the system.
Analyzing Salesforce Field Usage

Solution Architect skilled in Salesforce, NetSuite and JavaScript Development
Over time, Salesforce orgs get more and more complicated especially when a consultant, admin or developer leaves the organization with their knowledge of the system.
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.
On Salesforce, if you want to process thousands of records the only way to truly achieve it is through asynchronous apex.
In this blog post, we cover the various ways of doing Asynchronous Apex.
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.
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.
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.
The AWS TCO Calculator allows technology departments or architects to determine what could be saved by leveraging cloud infrastructure.
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 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).
The NetSuite stock Electronic Bank Payments module doesn’t actually support the CPA-005 format.
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.
Security in Salesforce and on the Force.com platform can be really hard to understand. In this blog post, we’re going to have a look at the “With Sharing” and “Without Sharing” Apex keywords.
This year for Christmas I was really blessed to receive The Software Architect Elevator book from a family member. Gregor Hohpe has done such an incredible job putting incredibly technical details into a really easy to follow book.
In Salesforce, the Standard Query Language (SQL) didn’t have a great way of doing SELECT * or select all fields but that changed in Spring 2021.
When writing SOQL queries we can use the IN operator or the = operator as long as we are using variables instead of hardcoded strings. This works because the result will be identical.
This past year, Salesforce has finally released some security enhancements that can make our lives easier as developers.
There’s two enhancements that can really improve our code and reduce the use of the Schema.sObjectType methods.
Adding a valid DKIM record to NetSuite is pretty easy! Follow these instructions to get it done in a few minutes.
Programming on any cloud platform can be a really frustrating experience. NetSuite has a lot of the same quirks and annoying things that other platforms have whether it be Salesforce, SharePoint, or something else.
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!
As you may recall, in Salesforce, there are some fairly stringent governor limits that can cause things to unexpectedly fail.
In this blog post, you will learn three easy steps to bulkify any method in Apex.
An outbound message sends information in XML format using SOAP to a specific URL endpoint. The information contains the fields specified when the outbound message is created.
It’s not possible to modify Apex code directly in production so doing deletes can be really difficult. In production, Apex classes and triggers cannot be deleted declaratively so we need to go through a special deployment process.
Understanding what Salesforce Integration Pattern to use is vital to a successful Salesforce implementation. Choosing the wrong pattern can result in a really weak architecture that fails regularly, or costs a lot.
The first step for a successful integration is understanding the goals, planning and documenting the current processes. The most important thing is to understand the stakeholders and what they need to do with the data.
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.