Kontext Project

Kontext is multi-user, cross-platform and full cloud based blog web application created by Raymond Tang using .NET Core 2.1. It utilizes VSTS as CI/CD tools and Azure as hosting environments.

Learn more

Install Hadoop 3.0.0 in Windows (Single Node)

16 views   0 comments last modified about 3 days ago hadoop yarn hdfs

View detail

Kontext Release 3.0.0.0-alpha.4

4 views   0 comments last modified about 5 days ago kontext

View detail

C# version history and core features

12 views   0 comments last modified about 5 days ago C# lite-log

View detail

Install Zeppelin 0.7.3 in Windows

24 views   0 comments last modified about 16 days ago lite-log zeppelin spark

View detail

Introducing a new blog post type – LiteLog

19 views   0 comments last modified about 17 days ago lite-log

View detail

Connect to Teradata database through Python

96 views   0 comments last modified about 2 months ago teradata python

View detail

New domain kontext.tech is now in use

109 views   0 comments last modified about 4 months ago kontext

kosmisch.net is recently upgraded to Azure and a new domain kontext.tech is in use.

View detail

Teradata Tutorials Summary - October 2017

105 views   0 comments last modified about 5 months ago teradata

This post summarizes the tutorials I created in the past about Teradata. It is trying to help you gain the basic SQL skills with Teradata especially if you are a new beginner or you just move from SQL Server or Oracle. It also includes some guides about setting up your own Teradata server (latest Teradata Express version TDExpress16.10.00.03_Sles11_40GB.7z).

View detail

Setup Teradata in Microsoft Azure

60 views   0 comments last modified about 5 months ago Windows Azure teradata

This page provides the steps to create a Teradata database in Microsoft cloud computing platform Azure.

View detail

Teradata SQL Tricks for SQL Server/Oracle Developers

118 views   0 comments last modified about 5 months ago teradata SQL

For many SQL Server or Oracle developers, you may encounter some inconveniences when writing SQL queries. For example, how to select from dummy table or local defined variables. This page summarize the equivalents in Teradata SQL.

View detail

Teradata Tutorial – DateTime Related Functions and Examples

106 views   0 comments last modified about 5 months ago teradata

This post summarize the common functions that are used when dealing with DateTime datatypes in Teradata.

View detail

Logging configuration in .NET core

100 views   0 comments last modified about 5 months ago .net core

.NET core introduces a logging API that works with a number of logging frameworks. The built-in providers are configurable and extensible to support different level loggings.

View detail

Retrieve Identity username, email and other information in ASP.NET Core

95 views   0 comments last modified about 5 months ago asp.net core identity core 2

The identity system in ASP.NET has evolved over time. If you are using ASP.NET Core, you probably found User property is an instance of ClaimsPrincipal in Controller or Razor views. Thus to retrieve the information, you need to utilize the claims.

View detail

Sending Emails in .NET Core Applications

391 views   0 comments last modified about 5 months ago .net core

Sending emails are common in applications. For example, when user registers, we need to send account activation emails. This post summarize the approaches we can use to send emails in .NET Core 1.x and 2.x.

View detail

Querying Teradata and SQL Server - Tutorial 1: The SELECT Statement

26275 views   7 comments last modified about 3 years ago

View detail

Install Teradata Express 15.0.0.8 by Using VMware Player 6.0 in Windows

10553 views   21 comments last modified about 4 years ago

View detail

Working with SQL Server Compact 4.0 using Entity Framework 6 and ADO.NET

9532 views   0 comments last modified about 4 years ago

View detail

Generate Formatted Excel Destination (Output) in SSIS Data Flow Task

7196 views   0 comments last modified about 4 years ago

View detail

Create ETL Project with Teradata through SSIS

6890 views   2 comments last modified about 3 years ago

View detail

Connect to Teradata Virtual Machine Guest from Windows Host

4776 views   16 comments last modified about 3 years ago

View detail

[C#] Connect to Teradata Database via .NET Data Provider

3545 views   2 comments last modified about 3 years ago

View detail

Resolve the Issues in Upgrading Entity Framework to Version 6.1

3325 views   0 comments last modified about 4 years ago

View detail

Querying Teradata and SQL Server - Tutorial 2 Filtering and Sorting

2577 views   2 comments last modified about 3 years ago

View detail

Create and Debug C/C++ Programs with Eclipse and Cygwin in Windows

2386 views   0 comments last modified about 2 years ago

View detail

Querying Teradata and SQL Server - Tutorial 0: Preparation

2376 views   0 comments last modified about 3 years ago

View detail

Surface RT/Pro 版本Windows 8 QQ下载与安装

2287 views   0 comments last modified about 5 years ago

Surface的用户可能会遇到一个难题,在应用商城里边无法搜索到QQ应用程序。但是让我疑惑的是,我的Windows 8.1 系统之前是成功安装了QQ。

后来在腾讯QQ下载官网发现,其实是有QQ应用安装的链接:

按照如下方法安装Surface QQ.

Have fun!

image

View detail

Raymond about 2 months ago

Version 3.0 beta1 is now available. 

Raymond about 2 months ago

@Matt

If you followed all the steps, in the UNIX virtual machine, Teradata Studio Express is already included. You can use that tool to connect to the Teradata server using dbc account and then create any database you like.

Alternatively, please follow the link below to setup client tools in your Windows (host machine for the Teradata VM), which will enable you to connect directly:

http://kosmisch.net/Blog/DataAndBusinessIntelligence/Archive/2015/5/18/connect-to-teradata-virtual-machine-guest-from-windows-host.html 

You can use Teradata Administrator client tool if you are not familiar with SQL.

Matt about 2 months ago

@Matt I simply don't have the Create Data base in the Tools. I am very new to Teradata. 

Raymond about 2 months ago

@Matt what is the error message you got when creating database?

Did you follow all the steps including logging with dbc user?

Matt about 2 months ago

Did all that. But still can't create a database. I need to create a database and them tables to load some data. So I can play with that? Could you please show us?

John about 3 months ago

Thanks for taking time to post this! That saved a lot of time!

Raymond about 5 months ago

@Brian Daves You are welcome. It is probably because Edge has no such issue and eventually it will replace IE.

Brian Daves about 5 months ago

Thanks for the help. That was a very annoying issue and I'm surprised it hasn't been fixed by the Core team.

Raymond about 5 months ago

Just a quick update:

The same installation steps are still applied to the latest version 16.10.00.03

TDExpress16.10.00.03_Sles11_40GB.7z

Raymond about 5 months ago

@Michael

https://github.com/aspnet/Identity/blob/dev/src/Microsoft.Extensions.Identity.Core/RoleManager.cs

The default query doesn’t include property Users as it is extended by us. Thus, you can write your own Linq query to use entity framework core extension method Include(r=>r.Users) to ensure Users are also loaded.

 In this way, the query generated will be a join SQL.


Raymond about 5 months ago

@Sasi Kumar

Apologies  for the late reply.

You can pass variables as you can do with any database, I.e. use variable expressions to prepare the statement.