Select Page

Blog

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

Category: Analytics & Business Intelligence

Art of BI: SQL Exception: The TCP/IP Connection to the host has failed.

It turns out this error is caused when TCP/IP to the SQL Server server instance has been disabled. Below are the steps to resolve the issue.

Christian Screen | July 7, 2009

Art of BI: Simple SubSonic Project Collection Retrieve

Using the subsonic project ORM for .NET clearly has tons of benefits for DAL and BLL purposes.

Christian Screen | July 4, 2009

Art of BI: SQL Server CASE IN() Statement Revealed- Who Knew?

I am about to show you a great sql trick that only a few SQL Server T-SQL masters actually know.

Christian Screen | July 1, 2009

Art of BI: An error occurred while processing the EXECUTE PHYSICAL statement

Typically I haven’t bumped into this error in the past with OBIEE but the other day it smacked me in the face.

Christian Screen | June 28, 2009

Art of BI: Flatten Parent Child Vertical Table to Horizontal Generations

This is just another post that I’ve been meaning to put up for a while but it just became relevant again on an OBIEE project I am working on.

Christian Screen | June 26, 2009

Hostname resolved to an IP Address – Windows 2008 Hyperion System 11 Installation Issue

In continuation with VM Image installation of Hyperion 11x I decided to stand-up a Windows Server 2008 Hyperion 11x image with just the basic Foundation Services.

Christian Screen | May 27, 2009

Art of BI: Remote Desktop Connect to a VM Image

After we put together our Hyperion 11x VM Image I started thinking about how I wanted to use the new server environment for testing, etc.

Christian Screen | May 24, 2009

Art of BI: SQL Server – Truncate and Shrink Log File

Often when building a database, not all properties and settings are configured properly when initially created.

Christian Screen | May 22, 2009