In D & A Projects, building efficient SQL Queries is critical to achieving the Extraction and Load Batch cycles to complete faster and to meet the desired SLAs. The below observations are towards following the approaches to ensure writing SQL queries that meet the Best Practices to facilitate performance improvements. Tuning Approach Pre-Requisite Checks Before […]
Software Development
Performance Tuning Guidelines – Informatica PowerCenter
Quite often, while building the Data Integration Pipeline, Performance is a critical factor. The factors below are vital for following the guidelines while working on ETL processing with Informatica PowerCenter. The following items are to be considered during ETL DEV: Pre-Requisite Checks and Analysis Basic Tuning Guidelines Additional Tuning Practices Tuning Approach Pre-Requisite Checks/Analysis Before […]
Using PowerShell Scripts to Help the Client Make Informed Decisions
Every week, you buy broccoli at the grocery store to make for the family dinner. If you knew that 3 of your 5 family members didn’t like broccoli and never ate it, would you still buy it every week? If your client constantly funnels effort towards a component that was rarely used or in a […]
The Importance of Web Accessibility in Site Navigation
What is Web Accessibility? You may have heard that term a lot lately. With almost 62% of the world’s population using Internet today, it is crucial for the business to be available to all out there. The Web is designed to work for all people, regardless of their hardware, software, language, location, or ability. Image […]
Maximizing Efficiency with Copado: Tips and Tricks
Introduction to Copado Salesforce-specific DevOps platform Copado is hosted in the cloud. It offers automation and collaboration technologies to assist businesses in streamlining their deployment procedure, increasing productivity, and minimizing manual errors. As well as integrating with other tools and monitoring the health of their Salesforce system, Copado assists teams in automating change management. Organizations […]
Deploying a Sitecore Instance on a “Local” Kubernetes (k8s) Setup Pt2
In the first blog of this series (here), I laid the foundation of why I chose this POC and my investigation into potential tools such as MiniKube and Kind, and why these did not work for me. I eventually settled on AKS Edge Essentials from Microsoft. Now I will take a slightly deeper dive into how […]
The Importance of Tracking Requirements Updates
The beauty of Agile is its ability to adapt to change. One of the principles behind the Agile Manifesto is “Welcome changing requirements, even late in development. Agile processes harness change for the customer’s competitive advantage.” Clients change their minds. Maybe they don’t like how something looks or functions once it’s using real-world, actual content. […]
Optimizely CMS 12 – Unique upgrade challenges
By now, a lot of us have already participated in one or more Optimizely CMS 12 upgrade projects. The others are still evaluating whether they should do it now or wait some more. Regardless of when you do it, there will definitely be some unique upgrade challenges you will come across, as I and many […]
Safeguard Your Mobile App With This Security Checklist
Time spent on mobile apps has increased exponentially in the past few years. The development team must safeguard with the tools and technology available at their disposal. We will review techniques for mobile app security. You may also reference Give Your React Native Apps a Titanium Shield Against Vulnerabilities and OWASP Mobile Top 10 for […]
Introduction to Tailwind CSS
What is Tailwind CSS? Tailwind is a utility CSS library that allows developers to use the styling properties within the HTML file. It is done by labeling the class name as styling properties. Instead of defining the class name such as Navbar, and Footer, developers can define the classes as styling properties. Such as display […]
Battle to Use Artificial Intelligence Heats up, Introducing Google Bard Rival to ChatGPT
The battle to use artificial intelligence is heating up as companies worldwide are investing heavily in the technology. Companies are investing in AI to gain a competitive edge in the market, as well as to automate processes and increase efficiency. Google on Monday released its own chatbot similar to ChatGPT, called Google Bard, as the […]
You Just Got Vectored! SVG Image Formats
If you’re reading this, you’ve come across a need that nearly all Opti developers encounter in their careers; You need to correctly display a vector image format (SVGs and the like). The <IMG> tag just isn’t going to cut it anymore. Posts like this are a right-of-passage for Opti bloggers. “So,” you think, “if there […]