Monthly Archives: November 2013

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 … Continue reading

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

T-SQL vs. MDX

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 … 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.

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