Search found 1713 matches

by JimKnicely
Wed May 17, 2017 1:28 am
Forum: Vertica Links
Topic: Vertica Integration with Dundas BI: Connection Guide
Replies: 0
Views: 63

Vertica Integration with Dundas BI: Connection Guide

The Dundas BI connection guide is out!

This document explains how to connect Dundas BI, a feature-rich data exploration tool, to your Vertica database.

Get the details here:
https://my.vertica.com/kb/DundasBIConne ... -Guide.htm
by JimKnicely
Wed May 17, 2017 1:18 am
Forum: Vertica Links
Topic: Best Practices for Preparing Your Cluster for Rebalance
Replies: 0
Views: 57

Best Practices for Preparing Your Cluster for Rebalance

Great best practice post "Best Practices for Preparing Your Cluster for Rebalance" by Rakesh Bankula and Soniya Shah . This document describes how to prepare your cluster for rebalance and how to estimate how long it will take to rebalance your database. Check it out here: https://my.vertica.com/kb/...
by JimKnicely
Wed May 10, 2017 1:31 pm
Forum: Vertica Links
Topic: Scott Saktanaset's HPE Brand Ambassador Application for Discover 2017 Vegas
Replies: 0
Views: 104

Scott Saktanaset's HPE Brand Ambassador Application for Discover 2017 Vegas

On June 5-6 in Las Vegas, Hewlett Packard Enterprise is hosting its Discover and Global Partner Summit together, making this the largest gathering of the HPE ecosystem. As employees we were invited to be a part of it by submitting a video explaining how we bring the HPE values to life and why you wo...
by JimKnicely
Tue May 09, 2017 5:26 pm
Forum: Vertica SQL
Topic: Empty string handling...
Replies: 1
Views: 106

Re: Empty string handling...

Hi Julie,

You can use a CASE statement:

dbadmin=> select case '' when '' then 'FOUND' else '' end;
case
-------
FOUND
(1 row)
by JimKnicely
Thu May 04, 2017 1:28 pm
Forum: Vertica Links
Topic: Troubleshooting Tips for the Vertica Catalog
Replies: 0
Views: 66

Troubleshooting Tips for the Vertica Catalog

Another great article on the Vertica Knowledge Base titled "Troubleshooting Tips for the Vertica Catalog" co-authored by Shrirang Kamat and Soniya Shah . The first section of this document describes how a persistent copy of the Vertica catalog is managed and laid out on disk. This information is use...
by JimKnicely
Thu May 04, 2017 1:08 pm
Forum: Vertica Links
Topic: K-Safety Best Practices
Replies: 0
Views: 64

K-Safety Best Practices

Great new "K-Safety Best Practices" post on the Vertica Knowledge Base co-authored by Shrirang Kamat and Soniya Shah . Overview This document provides an overview of K-safety, data safety, and node dependencies. These concepts are important when considering the high availability and recovery feature...
by JimKnicely
Sat Apr 29, 2017 3:37 am
Forum: Vertica Links
Topic: Monitoring Vertica
Replies: 1
Views: 186

Monitoring Vertica

Great new "Knowledge Base" post "Monitoring Vertica"... The purpose of this document is to help you monitor your Vertica database. The document is categorized into sections of query execution. You can use the queries in this document to investigate and troubleshoot database issues by monitoring the ...

Go to advanced search