Posts Tagged ‘sql’

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

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

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

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

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

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

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

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

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

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

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

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