Posts Tagged ‘sql’

Young Caucasian Female Programmer In Glasses Writes Program Code On A Laptop

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

Introducing Azure SQL Data Warehouse

Today, during annual Microsoft Build conference keynote, Microsoft’s own Scott Guthrie (executive VP  of cloud and enterprise group) introduced new Azure service which is going to be available in public preview in June: Azure SQL Data Warehouse. Large enterprise today can’t effectively function without big data realtime analytics. Realtime analytics means processing large amounts of […]

Getting to know Oracle Data Integrator (ODI)

As an avid user of IBM DataStage for over 8 years I was recently on a client engagement where I had to use Oracle’s Oracle Data Integrator (ODI).  At first I was disappointed as I was out of my confront zone.  But after a week or two I was very surprised how quickly I was […]

SQL Querying Sitecore Database Directly: Ordered Content Tree

In my last blog post, I gave you a SQL function that will return the FullPath of a given Sitecore Item.  Another common set of information one might want to retrieve from the Sitecore DB is the descendent items in the proper order as they show in the Sitecore Content Tree.  The trick to this […]

SQL Querying Sitecore Database Directly: Get FullPath of Item

It’s not often that a Sitecore developer has to write SQL queries against the Sitecore databases because the Sitecore API handles basic CRUD operations for the developer.  It’s also a best practice to use the API so that all the hooks and handlers and pipelines and events fire the way they’re designed to.  However, there […]

Load More