Skip to main content

Posts Tagged ‘sql’

Istock 1308640312

SQL Tuning

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 […]

Data Center Corridor Server Room With Abstract Overlay Of Networked Connections By Sdecoret Gettyimages 1197646065 2400x1600 100857776 Orig 1

SQL Best Practices and Performance Tuning

The goal of performance tuning in SQL is to minimize the execution time of the query and reduce the number of resources while processing the query. Whenever we run the query, performance depends on the amount of data and the complexity of the calculations we are working on. So, by reducing the no of calculations […]

Dependency Injection

Sneak Peak of the SQL Order Of Execution

After writing SQL codes for a few years now, I noticed I used to make mistakes in the order of execution of SQL Queries. So here I am with my new blog on the same topic. Let’s jump in to understand the SQL order of execution & learn practical, correct ways to write SQL Codes. […]

Man working on a computer with lines of code superimposed over him.

How to Improve SQL Performance – Antipatterns

Ever come close to writing a perfectly looking and valid SQL just to see it take hours to run? SQL optimization might be the thing you need! For business and customers, time is limited and precious and as Software Developers, QA Engineers, DB Developers, etc we should strive to improve the efficiency of our queries […]

Programer Codes On A Laptop Connected To Additional Screen

Creating an EBS Target application in Data Management from a SQL query

When integrating an on-premise system like an E-Business Suite application with an Oracle Enterprise Performance Management Cloud application, SQL queries can be used as means to extract the data from the source database. You can extract the data and then load the data directly to the EPM Cloud applications using the EPM Integration Agent. The EPM Integration Agent […]

Istock 636249678

To SQL or to NoSQL? That is the question.

There is a lot of confusion and hype out there regarding persistence technologies. It can be difficult to choose the right one. There are many considerations, and each situation requires thoughtful investigation. In this post, we’ll take a 10,000-foot view to help orient you in this landscape. To get the most out of this discussion, […]

Upgrading the Password Hashing Algorithm for Sitecore 9+ Installs

The Importance of Security Maintaining security is critical. Take a look at any of the major data breaches that have occurred in the past few years where millions of Americans have had their data compromised, and you might start to agree. One of the simplest measures we can take to protect our information is through […]

Web API Using Azure

Upgrading the Password Hashing Algorithm for Sitecore 9+ Installs

The Importance of Security Maintaining security is critical. Take a look at any of the major data breaches that have occurred in the past few years where millions of Americans have had their data compromised, and you might start to agree. One of the simplest measures we can take to protect our information is through […]

How to Recycle PBCS Backups on AWS S3 Bucket After 61 Days

In this blog post, I will cover the necessary steps to create the S3 bucket storage that will transition to standard – IA (Infrequent Access) for 30 days to finally move to Glacier where the files will be archived for 61 days. Amazon Web Services’ (AWS) low-cost S3 cloud storage provides a cost-efficient solution to […]

SQL, NoSQL, and NewSQL

Traditional SQL databases and data warehouses have been around for decades and have been doing really well. However, Big Data NoSQL changed the game with big returns for big investments. Concepts like Edge Analytics have been game changers “uberizing” foundational changes in business models. I recently attended a conference hosted by Snowflake, a data warehouse […]

HTML Report Generation from Database in Unix

Now-a-days most of the organizations/corporations are still using legacy software which produces output in the form of flat files. Integrating these flat files and text files with other data formats such as HTML, XML, etc. in a modern computing environment is increasingly difficult. Many tools are available in the market to convert flat file to […]

Azure: Did You Know? No Integrated Authentication in SQL Azure

Microsoft Azure SQL Database is very similar to on-premises SQL Server, but there are a few key differences. One of these difference is that SQL Azure doesn’t support integrated authentication (i.e. when caller is identified by its domain account). I assume this is a technical limitation which could be explained by the lack of domain […]

Load More