Skip to main content

Posts Tagged ‘database’

Robotic Hand Pressing A Keyboard On A Laptop 3d Rendering

Databases from the Future: What is Database Version 954?

Have you started up a new Optimizely site, and prepared your database only get to this error message?   Reading the error message itself, you’ll see that the created DB version is at 957 where the current version of Optimizely, at the time of this writing, is 904. Where did this come from? How do […]

Changes In Sitecore 10

Upgrading Sitecore Platforms – Changes in Sitecore 10.x

So, you find yourself in a need of a Sitecore upgrade and don’t know what to start with or how to approach it? This series of blog posts will cover the whole process from zero to hero, or in upgrade terms – from planning to going live. It comes in the form of a guide […]

Focus And Dedication Got Her Far

Load Data From Amazon RDS to Snowflake Using Matillion ETL Tool

Amazon Relational Database Service, a  service provided by Amazon Web Services, is a fully managed SQL database cloud service that allows you to create and operate relational databases. With Amazon RDS, one can access all the files and database anywhere in a cost-effective and highly scalable way. Snowflake is a cloud-based platform that helps data […]

Understanding CRUD Operations Using PnP PowerShell

Create, read, update, and delete (CRUD) is an acronym used in database-related functions. James Martin probably coined the term (CRUD) in his 1983 book Managing the Database Environment. We can use the following models to execute basic CRUD operations in SharePoint: REST-API Object Model. JavaScript Object Model Client-Side Object Model Server-Side Object Model We must […]

[Part 2 of 2] How to Refresh Your Marketo Data for the New Year

New Year, New You… continued! Last week, I asked you to take a moment and think about your Marketo instance. When was the last time you focused purely on data hygiene for marketing automation? It’s a fresh new year, and now is the perfect time to refresh your data! As such, I posted a list […]

data-bar-chart

[Part 1 of 2] How to Refresh Your Marketo Data for the New Year

New Year, New You! It’s 2022! Take a moment and think about your Marketo instance. When was the last time you focused purely on data hygiene for marketing automation? If you’re like most Marketo Admins, it’s tough to find the time – but you know how important it is. Never fear, I’m not judging you! […]

How to Set Up Replication in MySQL

MySQL replication is a real-time mechanism that automatically copies or replicates data from one server to another backup server. Database administrators can use the master-slave replication procedure to replicate or copy data from multiple servers at the same time. This allows the database administrator to create a continuous live backup of the database. They can […]

Page Preview Master/Web Paradox

Does this scenario sound familiar? Sitecore CM/CD are on different servers Developer doesn’t have access to the CD server that is currently showing an error in the browser. Code base for both CM and CD are the same. Developer switches the database from Master to Web in CM and then previews the page but no […]

Optimizely/Episerver DXP Deployment API – Smooth Deployment Public Release

In my previous posts, we went over the deployment process in the Optimizely/Episerver DXP environment. The first and the second post of the Deployment API series went through the original methods that allow for deployment into the DXP environment. Smooth Deploy is a feature that I have been looking forward to for a long time now. It […]

Pexels Polina Zimmerman 3747139

DXP Deployment API – Azure.Storage Error Fix

As of March 29th, Microsoft made the decision to publish new VM’s which archived a bunch of Az, Azure, and AzureRM modules. The side effect of this was that when any of the deployment API scripts were run in Azure DevOps, it would throw an error. ‘Azure.Storage’ version 4.4.0 or greater is required. At C:\Users\VssAdministrator\Documents\WindowsPowerShell\Modules\EpiCloud\0.13.15\EpiCloud.psm1:189 […]

Pexels Photo 745708

EpiServer DXP Deployment API – Direct Deploy

As of Update 357, Optimizely (EpiServer) released Direct Deploy into their Deployment API, Episerver.PaaS.EpiCloud. This update changes a couple of my scripts to allow major speed improvements when deploying into the integration environment. In this post, we will go through the following: How does the current deployment to Integration work? Why Direct Deploy? Why does […]

Istock 649839956

Is It Time to Upgrade Oracle?

Current Support Policies If you are on Oracle EBS 12.1 or database 12c or below, you might want to consider upgrading.  Oracle support policies change, so be sure and check the latest updates, but at the time of this writing, premier support for EBS 12.1 ends in December 2021. Currently Oracle does not plan to […]

Load More