Jirka's Public Notepad

Data Engineering | Python | SQL Server | Teradata

June 21, 2020 By Jiří Hubáček Leave a Comment

EightKB Virtual Conference – Demystifying Statistics in SQL Server

I've heard of the EightKB conference from Brent Ozar's webcast. I checked the schedule and thought: OMG, this is precisely the kind of nerdy event I'm

March 14, 2020 By Jiří Hubáček 1 Comment

Iterative approach – Photo Of The Day App

This post demonstrates the iterative approach that is an integral component of agile development on my personal project. It started small with a

January 30, 2020 By Jiří Hubáček Leave a Comment

Things To Do In Melbourne – Explore Like a Local

I asked my good friend Rod, who grew up in Melbourne, for some useful like-a-local tips. He pulled a fantastic list of great pieces of advice I go by

January 27, 2020 By Jiří Hubáček Leave a Comment

Python Libraries Installed By Visual Code

I use Visual Code for all my Python projects. It's easy to navigate, looks great, comes with shortcuts, performs code validation

August 12, 2019 By Jiří Hubáček Leave a Comment

Docker container for Python development

I wanted to package my Python application to a Docker container. By doing so, I’d be able to smoothly run my application wherever I wanted to – either

January 2, 2019 By Jiří Hubáček Leave a Comment

TOP N Syntax error: Top N option is not supported in subquery.

Unlike other database engines, Teradata doesn't support top N clause in suqueries (error Failed [6916 : HY000]). I came across this limitation when I

«
»
  • GitHub
  • LinkedIn
  • RSS
  • Twitter
© 2021 · Jiří Hubáček, PGP