Starting a new blog

In the last months, I made a decision to launch a new blog in my own domain and hosted WordPress. I needed more flexibility over installed plugins and more content control. I would also like to focus more on Big Data domain and tools such as Hadoop and Aster. I’m looking forward to see you there!

http://blog.hubacek.uk

Cheers!

Posted in Microsoft SQL Server | Leave a comment

Learning new stuff

Through our career we face a lot of demands to learn new stuff. New versions of products are being constantly released and keep yourself up-to-date is quite demanding. What used to be widely used product in the last year might become obsolete this year. Sometimes we realize that our current platform is not the one we would like to work with in the next five years or you just get a great contract or job offer for concurrent platform. So we are constantly learning …

Learning new stuff takes time
According to Dr. K. Anders Ericsson becoming a top of the field expert takes 10 000 hours (however there are opinions refusing this statement). In the IT industry this estimate might apply to guys with master certifications (9 years give or take of experience). However one cannot be an expert in every area. Most of the time you need to be just more or less good enough.

I really liked Mr. Kaufman’s video from TED on this topic. According to him learning to a good enough level takes 20 hours which he demonstrated in the end by playing ukulele thus finishing his 20 hours learning spree.

Major points when learning something new:

Continue reading

Posted in General talks | Tagged | Leave a comment

How I Met Teradata

By the end of 2013 I was looking for a new place to continue my career. During January 2014 I had two great offers. First offer meant to stay with Microsoft and SQL Server, second to marry Teradata. Continue reading

Posted in Microsoft SQL Server | Tagged | 2 Comments

My 2013 in review

2013 was quite a busy year. At the start of the year Continue reading

Posted in Microsoft SQL Server | Tagged , | Leave a comment

Joys With Datetimes

Sometimes we need to generate current timestamp in a special format (e.g. suffixes for backup files). If we are unlucky that requested format is not supported by CONVERT function and SQL Server version is 2008 R2 and older this might be a little tricky.

In this blog post I will show how to get date with time in yyyymmddhhmiss (aka. YYYYMMDDHHmmSS or yyyyMMddHHmmss) in SQL Server versions up to 2008 R2 and 2012 and newer.
Continue reading

Posted in Microsoft SQL Server | Tagged , , , , | Leave a comment

T-SQL vs. MDX

T-SQL vs. MDXAlthough MDX has some similarities with T-SQL these languages are in many ways different. MDX is an acronym for MultiDimensional expression. Nowadays MDX is implemented in many non-Microsoft analytical platforms. Like T-SQL MDX in SQL Server has two usages:

  • Expression for cube development
  • Query for data retrieving from OLAP Cube

In this article I will compare some basic queries written in MDX with queries written in T-SQL. Continue reading

Posted in Microsoft SQL Server | Tagged , , | Leave a comment

Interview Question

During my interview I got an exam about general IT knowledge and some SQL stuff. However there was a question I was not able to answer right away.

Continue reading

Posted in Microsoft SQL Server | Tagged , | Leave a comment