Datapipe has been awarded the 2010 American Business Award for Customer Service in the Computer Services category.  Datapipe was recognized for its accomplishments on June 21st at the awards gala in New York City which benefitted Oceana's efforts toward ocean conservation.

"We come to work every day challenging ourselves to deliver the best customer service experience in the industry," said Robb Allen, Datapipe Founder and CEO. "This recognition from the American Business Awards is an exceptional honor that reflects the dedication and professionalism of our people to be the best at what we do," Allen added.

The American Business Awards describes excellent customer service as an unparalleled level of support and 100 percent responsiveness to customer needs and emergencies.

Stevie Awards were presented in over 40 categories including Best Overall Company of the Year, Executive of the Year, and Corporate Social Responsibility Program of the Year.  More than 2,700 entries from organizations of all sizes and in virtually every industry were submitted for consideration.

More than 200 executives across the country participated in the judging process to determine the Finalists and Stevie Award winners. Details about The American Business Awards and the lists of honorees in all categories are available at www.stevieawards.com/aba

About The Stevie Awards
Stevie Awards are conferred in four programs: The American Business Awards, The International Business Awards, the Stevie Awards for Women in Business, and the Stevie Awards for Sales & Customer Service.  Honoring organizations of all types and sizes and the people behind them, the Stevies recognize outstanding performances in the workplace worldwide.  Learn more about The Stevie Awards at www.stevieawards.com.

Today Datapipe announced we will sponsor The WIRED Business Conference: Disruptive by Design on Monday, June 14, 2010 in New York City. Industry leaders headline the agenda for this cutting edge event focused on bringing together the best in business transformation.

"WIRED has put together an event that will deliver an exceptional experience for participants," said Robb Allen. "It is important to be part of a conference that embraces innovation and creative thought leadership in response to the constant evolution of today’s dynamic business environment."

Headline speakers and conversation sessions with WIRED editors include top executives from AOL, NPR, Starbucks, Progressive Insurance, Hunch, and Zynga Game Network. Chris Anderson, Editor-in-Chief of WIRED, known for New York Times best sellers, The Long Tail and Free: The Future of a Radical Price, will address the conference and conduct a conversation with Frederick W. Smith, Chairman and CEO of FedEx Corporation. Complete conference information is available at http://wiredbusinessconference.com/index.html.

“The WIRED Disruptive Business Conference is where the world’s most innovative executives come together to share their ideas about how technology is propelling business into the future,” said Howard Mittman, VP Publisher at WIRED Magazine. “As we embark upon our mission to uncover radical solutions that will help reshape the corporate landscape, we see Datapipe as an organization who shares our own sense of corporate responsibility and we are incredibly proud to have them as a sponsor of this exciting event.”

Datapipe and WIRED have a long standing relationship including past sponsorships of presentations by Chris Anderson and NextFest. The two companies share a mutual commitment to digital business and the growth of technology.

Mark Cravotta, Vice President of Worldwide Sales, was interviewed at a recent 3PAR event about Datapipe, Cloud Computing and Storage.

The permanant link can be found on 3PAR's Blog - StorageRap

Datapipe announced today that we have been named a finalist in the Customer Service Department of the Year category in The 2010 American Business Awards. The American Business Awards are the nation’s premier business awards program. All organizations operating in the USA are eligible to submit entries to The ABAs – public and private, for-profit and non-profit, large and small. The Awards are administered by the Stevie Awards Organization.
 
“Every day our people go above and beyond to ensure our clients’ success,” said Robb Allen, Datapipe CEO. “This nomination from such a prestigious program recognizes our team as among the best in customer service, and is a testament to their expertise and dedication,” Allen said.

Members of the Awards' Board of Distinguished Judges & Advisors and their staffs will select Stevie Award winners. Finalists were chosen by business professionals nationwide during preliminary judging in April through early May. This year’s Stevie Award winners will be announced during the annual gala on Monday, June 21st at the Marriott Marquis Hotel in New York City. “Datapipe was given a high rating by the judges for its noted accomplishments in striving for excellent customer service,” said Michael Gallagher, founder and president of the Stevie Awards. “The 2010 ABAs have yielded a tough field of competitors demonstrating the innovation, hard work, and progress of American organizations, executives, and workers,” Gallagher said.

This marks Datapipe’s second time as a finalist in the customer service category of The American Business Awards. Datapipe’s award winning service has been recognized by the Stevie Awards for Sales and Customer Service, the Inc. 500, the VAR500, the New Jersey Technology Council and NJBIZ.
About The Stevie Awards

Stevie Awards are conferred in four programs: The American Business Awards, The International Business Awards, the Stevie Awards for Women in Business, and the Stevie Awards for Sales & Customer Service.  Honoring organizations of all types and sizes and the people behind them, the Stevies recognize outstanding performances in the workplace worldwide.  Learn more about The Stevie Awards at www.stevieawards.com

Datapipe is sponsoring Startup 2010: The Mobile Revolution.  Startup 2010 is a one-day conference and business plan competition co-hosted by Silicon Alley Insider and New York University's Stern School of Business. On May 20, 10 startups will compete for the grand prize which includes $5,000 in managed hosting services from Datapipe.

"Building partnerships with exceptional service providers is critical in the early stages of a startup. We're thrilled that Datapipe is offering $5,000 of managed hosting to the winner of Startup 2010,” said Julie Hansen, Publisher and COO for Business Insider. “Datapipe’s industry leading hosting service should position the winner of Startup 2010 for success, just as it has for Business Insider,” Hansen added.

“Datapipe is proud to sponsor such a dynamic event uniting innovative leaders, cutting edge technology, and experienced business professionals from the NYC metro area,” said Robb Allen, Datapipe CEO. “Our portfolio of clients feature numerous mobile technology companies, many of whom we’ve worked with from the ground up. The Startup 2010 contest finalists are poised for growth and we look forward to partnering with the grand prize winner,” Allen added.

Startup 2010 focuses on entrepreneurship in digital businesses, specifically in the New York City region. Speakers and panelists from emerging mobile companies will be featured at the event, including Dennis Crowley, CEO of Foursquare, Bob Bowman of Major League Baseball, Justin Shaffer of Hot Potato, Eric Litman of Medialets. Details about Startup 2010 are available on the Business Insider website - http://www.businessinsider.com/startup2010

Just one month after announcing that our New Jersey data centers will be 100% powered by renewable energy we can proudly say we are partners in the U.S.  Environmental Protection Agency’s (E.P.A.’s) Green Power Partnership.  The purchase of nearly nine million kilowatt-hours (kWh) of green power annually, that now powers our Somerset-One facility, has qualified us for such an honor.  The data center became powered solely on renewable energy resources immediately following the purchase of Renewable Energy Credits (RECs) through Constellation NewEnergy.  This purchase demonstrates our proactive choice to switch away from traditional sources of electricity generation and support cleaner, renewable energy alternatives.  As Robb (Datapipe CEO Robb Allen) has said previously, “Investing in sustainable energy is the right thing to do for our kids, our community and our clients.”  We are all proud of this announcement and look forward to the further Greening of Datapipe.

Datapipe, announced today a contract with Rapid7® to utilize its Vulnerability Assessment solution NeXpose as part of its managed security services and PCI DSS compliance solution. NeXpose delivers an unrivaled breadth of unified vulnerability scanning and was ranked the highest possible rating of “strong-positive” in Gartner’s MarketScope for Vulnerability Assessment 2010.

“Vulnerability Assessment is a critical component of our managed security and PCI DSS Compliance solution,” said Joel Friedman, Datapipe’s Chief Security Officer. “We conducted a rigorous investigation and testing process of market leading vulnerability scanners. NeXpose™ stood out from the competition for efficiency, accuracy, and reporting. The solution also identified the highest number of vulnerabilities. Their central, web-based console equips our clients with actionable reporting so they can proactively protect their sensitive data and significantly mitigate risk,” Friedman explained.

NeXpose scans Web applications, databases, networks, operating systems and other software products to locate threats, assess their risk to the environment, and devise a remediation plan. Providing comprehensive vulnerability management and risk reporting NeXpose allows the broadest asset protection possible. NeXpose scans for over 14,000 vulnerabilities with more than 54,500 vulnerability checks against 1,500 devices in networks, operating systems, Web applications and databases across a wide range of platforms.

Datapipe offers a comprehensive suite of managed security and compliance solutions. We were among the first to achieve Level 1 PCI Certified Service Provider status and is an active member of the PCI Security Standards Council.

About Rapid7:
Rapid7 is the leading provider of unified vulnerability management, compliance, and penetration testing solutions, delivering actionable intelligence about an organization’s entire IT environment.  Rapid7 offers the only integrated threat management solution that enables organizations to implement and maintain best practices and optimize their network security, Web application security and database security strategies. www.rapid7.com

We can't imagine many announcements more important than the one we made on March 24th, 2010.  Datapipe has implemented an aggressive sustainability strategy that results in the annual reduction of more than 8.5 million pounds of carbon emissions.  The electricity powering our Somerset, New Jersey data center, known as Somerset One, comes from 100% renewable resources.  The primary source of this electricity is wind power.  Constellation NewEnergy made this possible through their NewMix Wind Energy solution that utilizes Green-e certified renewable energy certificates.

The importance of more efficient uses of energy is reflected in recent statistics regarding power consumption in the IT Industry.  The EPA estimates that data centers account for 1.5 percent of the nation's electricity consumption and they estimate that figure will increase 12% annually due to demand for digital resources.

We have a responsibility to support long-term sustainability through the technologies we implement and the electricity we consume.  Converting to 100% renewable electricity sources is a big win for our clients, our company and our community.  You know that you are at the forefront of innovation when your efforts are recognized as being "visionary" and that is exactly what Constellation NewEnergy Vice-president Keith Black had to say about Datapipe and CEO Robb Allen.

In April of 2010 Datapipe will open Somerset Three.  This facility will go online deriving 100% of its power from renewable resources, furthering our commitment to the environment and sustainability.  Datapipe is committed to being directly involved in the reduction of carbon emissions and the advancement of efficient energy use.

Datapipe has provided award winning service for over a decade.  The experts behind that effort are some of the most knowledgeable in the world.  This blog is intended as an open forum for our experts to express their thoughts and ideas regarding the managed IT services industry.  We welcome comments and questions and hope you find the entries helpful, informative, and thought provoking. 

You get a request to export a bunch of tables into a spreadsheet file. Sure there are ODBC connectors available for spreadsheets, but sometimes you don't want to have to figure all that out. This is where the power and simplicty of scripting languages can really shine, especially those that treat data as lists. Sure the following code block seems cryptic to a non-programmer, but it is really not that hard.

To solve this problem in less than 5 minutes I put together this piece of TCL code. It requires Tcl, and 2 of the support packages that are available for it: tcllib and Oratcl

This little script will take a list of tables and generate a [tablename].csv file for each one. The data in the csv file will be comma separated, and quoted. The first line of the output file will contain the column names.

#

# table_to_csv.tcl

#

#!/usr/local/tcl86/bin/tclsh8.6

package require Oratcl

package require csv

set lda [oralogon scott/tiger@database] set stm

[oraopen $lda] set tblList [list TABLE1 TABLE2 TABLE3]

proc csvjoin {values {sepChar ,} {delChar \"}} {

 set out ""

set sep {}

foreach val $values {

append out $sep${delChar}[string map [list $delChar ${delChar}${delChar}] $val]${delChar}

set sep $sepChar

}

return $out

}

foreach tbl $tblList {

puts $tbl

set t [open ${tbl}.csv w+]

oraparse $stm "select * from ${tbl}"

puts $t [csvjoin [oracols $stm name]]

oraexec $stm

while {[orafetch $stm -datavariable row] == 0} {

puts $t [csvjoin $row]

}

 close $t

}

Now sure, you could do this with perl or python or even 'C'. But then again, you would not be using my favorite scripting language.

Todd M. Helfter
Senior Oracle Database Administrator