Vertica Blog

Vertica Accelerator – Ease of Use Plus Control

Posted November 12, 2021 by Paige Roberts, Vertica Open Source Relations Manager

Read More

Vertica Wins the Gold in Bloor Market Update

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
May 3, 2022

Know Your Options for Analytical Databases and Data Warehouses For CDOs and CIOs, there have never been more options to choose from when deciding where to run their analytical workloads. Analytical databases and data warehouses are two popular options – with the data warehouse market experiencing 10% annual growth and many new entrants* – particularly...

Vertica for Time Series Analytics and IoT

Steven Sarsfield, Vertica Senior Product Marketing Manager – Partner Ecosystem
May 3, 2022

When you want to make a prediction – stocking levels for items in your store, predicting energy usage so supply is ready, or being proactive about equipment failures – those predictions often rely on time-series data, a series of data points measuring the same signal or process through time. By analyzing that data, companies can...

Hybrid Deployment for an Enterprise Data Warehouse Provides Maximum Benefits

Hemendhira Muralidharan, Senior Product Marketing Manager
July 28, 2021

Hybrid cloud strategy is the future of enterprises. As vital as the cloud can be to improving the economics and agility of Enterprise Data Warehouse (EDW) provisioning, most enterprises will need some on-premises capability as well to satisfy requirements for performance, privacy, and security, for both them and their customers. In addition, a lot of...

First annual “Data Disruptors Awards” caps Vertica Unify 2021

Mike Perrow, Senior Product Marketing Writer/Editor
July 27, 2021

“Vertica has been powering the world’s data disruptors for a decade, including companies that have created new industries, and have had an impact on the environment, and on the health of humans and animals.” Those were the opening comments by Joy King, Vertica’s VP of Product and Go-to-Market Strategy, at Thursday morning’s opening session for...

DataGals Panel reveals common workplace biases, but also opportunities

Mike Perrow, Senior Product Marketing Writer/Editor
July 23, 2021

  Representing five different time zones, and committed to sharing their thoughts and guidance based on the success they’ve achieved in their careers, five women gathered live and online Thursday, July 22 to discuss their experiences in high tech. Here's how they appeared in this virtual panel discussion: Far left: Joy King, VP of Product...

Subscribe For Email Updates

Sign-up and select Vertica in your preferences to receive our monthly Vertica newsletter.

Sign-up

Vertica Unify 2021 – Day 2 keynote spotlights a noble cause

Mike Perrow, Senior Product Marketing Writer/Editor
July 21, 2021

At Vertica Unify 2021, the focus this week has been on the techniques and best practices around data analytics. Naturally. There’s a lot of technology to cover in this space, and we’re delighted to have so many of the best and brightest minds in virtual attendance, helping us deliver, explain, and demonstrate these things. And,...

Vertica 11 announced at Unify 2021: Delivering on vision of Unified Analytics

Mike Perrow, Senior Product Marketing Writer/Editor
July 20, 2021

Introduced by Joy King, Vertica’s VP of Product & GTM Strategy, Colin Mahony, SVP and General Manager of Vertica, kicked off today’s Vertica Unify 2021 by explaining Vertica’s founding philosophy and sharing “some of the advancements we’ve made most recently, as well as the direction we’re going in future.” That included the announcement of Vertica...

DaaS Labs Embeds Vertica for Machine Learning Analytics at Superior Speed and Scale

Hemendhira Muralidharan, Senior Product Marketing Manager
July 19, 2021

Uncovering hidden patterns, trends, correlations, and insights in data has become a common business pursuit as companies look for different ways and means to monetize their data. Most of this activity relies on advanced data techniques like artificial intelligence, natural language processing, machine learning, deep learning, computer vision, and more. These techniques are DaaS Labs’s...

Explore Popular Topics

SQL
DBadmin
Advanced Analytics
machine learning
Best Practices
Cloud
VSQL
Eon Mode
Analytics
Vertica
Partner Integrations
IoT
Time series
AWS
Open Source

Quick Tip: Replacing non-UTF-8 Characters

James Knicely, Vertica Field Chief Technologist
July 16, 2021

Vertica database servers expect to receive all data in UTF-8 and Vertica outputs all data in UTF-8. However, you can load or insert data into Vertica that is non UTF-8, but you'll want to clean it up. I used to recommend the REGEXP_REPLACE function for that task, but now there is a better way! Vertica...
Quick Tip - blue button

Quick Tip: MC Adds a New Feedback Button

James Knicely, Vertica Field Chief Technologist
July 15, 2021

Do you love Vertica and want to let us know, or want to provide some constructive criticism? Well, now you can easily do that. Starting in Vertica 10.1.x, Management Console added a new Feedback Button which lets you submit a star rating and free-text comments to Vertica. The button displays vertically at the bottom-right of...
Helpful Tips in blue text with magnifying glass

Quick Tip: Determining Database “Cell” Count

James Knicely, Vertica Field Chief Technologist
July 14, 2021

The Vertica system tables LICENSE_AUDITS and USER_AUDITS include a mysterious column called CELL_COUNT. What exactly is the Cell Count? It's simply a calculation that looks like this: DATABASE CELL_COUNT = (Table_1 Column Count * Table_1 Row Count) + (Table_2 Column Count * Table_2 Row Count) + … + (Table_n Column Count * Table_n Row Count)...

The Climate Corporation awarded for outstanding AI/ML: We’re all winners with sustainable agriculture

Cheryl Bradstreet
June 28, 2021

The Climate Corporation, a subsidiary of Bayer, aims to help all the world’s farmers sustainably increase their productivity with digital tools. The Climate FieldView™ platform provides farmers with a comprehensive, connected suite of digital tools aimed at mitigating risk and optimizing farm productivity. As Vertica’s customer references manager, I gather stories around what our users...

Taking the pulse of cloud adoption trends: The Flexera “State of the Cloud” report

Jeremiah Morrow, Senior Industry Product Marketing Manager
June 23, 2021

Before I joined Vertica, I worked in the cloud services world, first for a reseller and then for a Cloud Services Provider (CSP). During my time in this space I followed cloud adoption trends closely by necessity, and one of my favorite sources of data on the subject was RightScale’s (now Flexera’s)  “State of the...

Partners Showcase Solutions at Vertica Unify ’21

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
June 21, 2021

Registrations for Vertica Unify ’21 are rapidly climbing as we anticipate thousands of data experts to convene for the analytics event of the year. Vertica customers have long adopted a "best tool for the job" approach – and that goes beyond choosing Vertica to accelerate analytics and machine learning at scale. Success often requires our...