Subscribe to Terdata Developer Exchange - RSS feed for all blogs Latest blog posts
15 Nov 2010

Have you ever tried to figure out ahead of time how many CPU seconds an application would require after upgrading to a new hardware platform?    I talked about one approach to solving this problem at the recent Partners Conference in San Diego, and would like to share my approach with you.

First, there a couple of assumptions we need to agreed upon when it comes to converting CPU seconds from one node generation to another:

12 Nov 2010

This blog will show you how to retrieve the SQL statement that is generated by the Entity Provider when it processes a  LINQ to Entities or Entity Sql statement.  LinqPad will be used to show you how this can be done.  The blog Using LINQPad to Access Teradata shows how to setup LINQPad to access Teradata.

LINQPad is only able to show the SQL statement that corresponds to a LINQ to Entities or Entity Sql statement when executed against SQL Server.

12 Nov 2010

In this blog I am going to show you how to setup LINQPad v2.26.2 to access a Teradata Database.

LINQPad is a very flexible query tool.  I use LINQPad to primarily execute LINQ to Entities and Entity Sql statements against Teradata when testing the Entity Provider for Teradata.  It is free to use and is available here:

However, you will have to pay for the auto-completion feature.  I highly recommend that you purchase this feature.

04 Nov 2010

Support for the Entity Framework 3.5 SP1 is coming in .Net Data Provider for Teradata (TDNETDP) 13.10. This release of the Data Provider for Teradata includes the Entity Provider for Teradata.

The Entity Provider gets installed during the installation process of TDNETDP. Once installed, applications can be written that execute LINQ to Entities and Entity Sql statements.

In the following examples, an Entity Data Model that references the Northwind database is used. The Northwind EDM and database were created by Microsoft.  These items have been modified for Teradata.

11 Oct 2010

With the autumn closing in, it's about time for another recap of activity here on Developer Exchange.

14 Sep 2010

Nice article today in the NY Times on 3-D Printing, one of the enablers of the Long Tail concept for manufacturing.

One interesting quote:  "'It costs $5,000 to $6,000 to print one of these legs, and it has features that aren’t even found in legs that cost $60,000 today,' Mr. Summit said."  A promise of both faster AND cheaper?  Basic project management rules would disagree, but who can tell.

27 Aug 2010

I have been struggling to move a huge retail application into database engine with Teradata UDF for 2 years. From my point of view, the current Teradata still has a great space to move ahead. Here is the feature list in my dream data warehouse.

25 Aug 2010

I did some research and could not find a good Teradata SQL formatter. There is a 'Formatter' button in SQL assistant, but the output is a bit ugly. I wrote a small tool with lex & yacc which is able to format a Teradata query.

I will distribute this tool if anybody is interested.

20 Aug 2010

Penalty boxes have been around for years.  They come in all shapes and sizes.  Their single, focused purpose is to lock away bad queries and thereby protect good queries, while not condemning the bad ones to the ultimate penalty of being aborted.  If you’re using penalty boxes, I want to encourage you to look inside them once in a while, and open your eyes to some of the side-effects you might not have noticed in the past.

13 Aug 2010

Following up on the outside influences that will drive EDW growth, Babbage's blog posted an article on the "Internet of Things."  It looks back to the promise of connecting not just all wireless devices to the internet, but everyday objects, “from food, clothing, pills and pets to personal electronics, appliances and cars,” and the current progress along these lines.