Blog

The Elements of VUCA & What They Mean for Data Management in 2020

This post will discuss how each element of VUCA is affecting businesses, and why reliable, accurate data is a must-have in this tempestuous economic climate.

Building a SQL Server Virtual Lab in Windows: Virtualization Concepts

New blog series by SQL Server expert JP Chen lays out how to build a SQL Server Virtual Lab in Windows. The first post takes on virtualization concepts.

4 GoldenGate Use Cases You Didn’t Know About

Oracle GoldenGate is a powerful, mature solution for real-time data integration and replication—here are four ways that you can apply these capabilities.

3 Critical Components of Smart Financial Planning

Recent world events have roiled the global economy. This post covers the 3 critical components for smarter financial planning so you can be prepared for the future.

Improve Your Database Security with Transparent Data Encryption

If you don’t have encryption, but want another layer of security for your database, Transparent Data Encryption is a simple way to encrypt your data at rest.

The Challenges of ETL: OLTP vs. OLAP Databases

This blog post discusses what you need to know about one of the most important distinctions in ETL: OLTP and OLAP databases.

SmartView Essbase Ad-Hoc and EPM 11.2

Are you getting a pop-up error in SmartView when trying a top-level SmartView ad-hoc retrieve from Essbase? Read this blog post for the fix.

Solving ETL Challenges: 5 Command-Line Tools You Need to Know

Struggling with ETL? In many cases, you can solve some of the most pressing challenges using the command-line tools that you already have at your disposal.

SQL Server Database Engine Installation Tips

Installing a new instance of SQL Server is a common task for DBAs , this blog takes on the different approaches and highlights benefits of each.

Stop Editing Workspace EAR Files – EASY Way to Change the Title!

Do you know that a one-line SQL statement makes your EPM Workspace title and browser tab look similar to my screenshot above? Read more to find out how.

Let’s Compare: BARMAN vs. Manual Backup

BARMAN is one of the most popular tools for backup and recovery management in PostgreSQL. This blog compares BARMAN vs. manual backup options.

EPM 11.2.1.0 Initial Thoughts

Well, much to my surprise, EPM 11.2.1.0 has already been released! Shall we talk about it? Let’s begin with a comparison chart I whipped up.