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!
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:
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
2013 was quite a busy year. At the start of the year Continue reading
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.
Although 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
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.