Category Archives: Teradata

Teradata SQL Assistant Options for SQL Server Users

At first glance SQL Assistant seems quite different from SQL Server Management Studio.  However there are two options that go a long way in making SQL Assistant behave more like SSMS.  The first option to set will display all databases … Continue reading

Posted in Database Administration, Teradata | Tagged , , | Leave a comment

Converting from Teradata Timestamp to SQL Server Datetime ‏

Teradata has a timestamp data type that appears to be equivalent to a SQL Server datetime.  It is not. Attempting to use the SSIS Data Conversion task will likely fail with a truncation error.  While the solution below is extremely … Continue reading

Posted in SQL Server Integration Services, Teradata | Tagged , , , , | Leave a comment

Logging query output with Teradata SQL Assistant

It is often useful if not required to save the output of queries run against a production database.  Here is how to log the output using SQL Assistant 13.10.x: 1. Select Tools->Options 2. Select the Query tab.  Uncheck ‘Stop query … Continue reading

Posted in Database Administration, Teradata | Tagged | Leave a comment

Connecting SSRS to Teradata

I have found that SSRS works quite well with Teradata.  Microsoft has a page on TechNet about using Teradata data sources.  I disagree with some of the directions and would like to see more detail on how to perform the … Continue reading

Posted in SQL Server Reporting Services, Teradata | Tagged , , | Leave a comment

Teradata Parallel Transporter Dependencies

When installing Teradata Parallel Transporter (TPT) there are a couple of dependencies to keep in mind.  TPT requires CLIv2, GSS client as well as Shared ICU Libraries.  These need to be installed prior to installing TPT components.  TPT will let you … Continue reading

Posted in Teradata | Tagged , , , | Leave a comment

Teradata SQL Assistant Query History

The Teradata SQL Assistant stores query history.  This is a handy feature that helps recall a query that was run earlier but might not have been saved to a file.  The problem is that the history can only be deleted … Continue reading

Posted in Teradata | Tagged , , | Leave a comment