Select Page


Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.


Refactoring Databases: A Strategy for Improving Performance and Data

Database professionals can improve existing assets by using the refactoring concept, which allows slow and steady improvement through incremental changes.

Eric Russo | August 11, 2015

Using Microsoft Excel Power Query to Shape Databases

With the release of Excel 2013, Microsoft introduced a set of powerful new features called Power Functions. These include Power Pivot, Power View, Power Maps and Power BI. These Power features take data shaping to a whole new level.

Eric Russo | July 7, 2015

Data Shaping with Microsoft Excel Power Query

Anyone who works with data probably has some comfort working with Microsoft Excel. The software’s tabular presentation of data, combined with its ability to easily export, import, and sort, gives it the core capabilities of data analysis.

Eric Russo | June 23, 2015

Best RAID For SQL Server | RAID 0, RAID 1, RAID 5, RAID 10

Which RAID should you use with SQL Server? Learn the differences between RAID 0, RAID 1, RAID 5, and RAID 10, along with best practices.

Eric Russo | June 8, 2015 Essbase Configuration Bug

A minor Essbase configuration flaw introduced in Hyperion / Oracle EPM remains present in

Eric Russo | February 9, 2015

FDM Enterprise Edition and ODI

As mentioned in one of our previous blog posts about Hyperion / Oracle EPM, the 32-bit “classic” edition of Financial Data Quality Management is no longer available

Eric Russo | February 8, 2015

How To Change Oracle SmartView Download Location

As mentioned in our previous post about, clicking Tools->Install->SmartView within Hyperion / Oracle EPM Workspace now directs users to an external website hosted by Oracle.

Eric Russo | February 1, 2015

Life Cycle Management Changes in

There are several constants in our world: death, taxes, and minor Hyperion LCM tweaks with each Oracle EPM release! is no different.

Eric Russo | February 1, 2015

How to Use sys.master_files For SQL Servers

When using SQL Server, you may want to find file information to gather statistics you can use to make database management decisions.

Eric Russo | December 2, 2014
1 2 10 11 12 14 15