T-SQL.dk

A blog on code, coffee & curiosities

Search
  • About
  • Contact
  • Engagements
    • Delivering BI Continuously
  • Volunteering
Skip to content

Tag: Teradata

Programming

Subtle differences in Teradata and SQL Server, Part 2

Jens Vestergaard17/02/2014 Leave a comment

Implementing Business logic in views is something seen quite often. Actually a view in my experience often contains some sort of data enrichment, -enhancement or -extension. So I am surely not the first one to come across the thought of adding some nifty tricks to a view. Well, tonight it seems I got too creative. […]

Read the article
Programming

Subtle differences in Teradata and SQL Server

Jens Vestergaard11/02/2014 2 Comments

Imagine the hair pulling experience, when you port knowledge from one RDBMS to another, and it just doesn’t work. I had one such experience today, when I had to generate a certain filter for at Query. I wanted to combine the year and month value, to filter on the unique month key which consisted of […]

Read the article
Programming

How to do a String REPLACE in Teradata

Jens Vestergaard04/02/2014 Leave a comment

String Replace does not exist but can be accomplished with the following procedure: INSTALL REQUIREMENTS:– 1) GRANT ALL ON “%TDUser%” TO “%TDUser%” WITH GRANT OPTION 2) C++ compiler, if running the TD Demo How to replace “old” with “new” so that  ‘Hello, old world’ becomes ‘Hello, new world’ 1) Logon to teradata using the %TDUser% […]

Read the article
Programming

Teradata based Data Source Views in Analysis Services

Jens Vestergaard05/11/2013 3 Comments

Now here’s a catch. I was trying all night long to figure out why Visual Studio was hanging on me, every time I wanted to add a Teradata based relational data source. Turns out that the list of available objects gets populated with all the objects in the current server, regardles of permissions. So connecting […]

Read the article

Categories

  • Coffee (9)
  • Community (56)
  • Entry Level (12)
  • Family (3)
  • Mixed (50)
  • Music (5)
  • Personal (4)
  • Programming (179)
  • Roleplay (6)
  • The Who (3)
  • tsql2sday (13)

Tags

.Net Analysis Services azure BI Business Intelligence C# Coffee Community D&D entrylevel Espresso FAIL Fejl Humor iot IWantToShare MCP MDX MsBIP MSConnect NFL Personal PowerBI Powershell Security Speaking SQL SQL2012 sqlfamily SQLPASS sqlsaturday SQLServer SQL Server SQL Server 2008 SQLTip SSAS SSIS SSIS 2008 SSMS SSRS T-SQL Teradata TSQL2SDAY VS2008 VS2010

LinkedIn

I am happy to connect on LinkedIn:

Jens Vestergaard

Subscribe

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Categories

  • Coffee
  • Community
  • Entry Level
  • Family
  • Mixed
  • Music
  • Personal
  • Programming
  • Roleplay
  • The Who
  • tsql2sday

Archives

LinkedIn

I am happy to connect on LinkedIn:

Jens Vestergaard

Social

  • View vestergaardj’s profile on Twitter
  • View vestergaard_jens’s profile on Instagram
  • View jvestergaard’s profile on LinkedIn
Theme: Ameno by BG Web Agency