Posts Tagged ‘sql’

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

Sales Report in SSRS

I hope everyone has found my articles useful and have used my articles in creating some great looking SSRS reports.  This week we will take a look at creating a product breakdown report or a detailed sales report. Let us refresh our memory.  Our sales table has the following fields: Fields Description Data Type ID […]

SQL

Some Useful Items to Take on the sql Optimization

Currently, we have a long time running issue for a data warehouse job, so we decided to optimize some stored procedures. After analyzing the stored procedures. we have some findings regarding the sql optimization. 1. Use the temporary table to minimize disk access. From the sql tuning view, the main concern for the database applications is to minimize disk access. Try […]

Load More