Solving tech problems

How to get list of sequential dates in MS SQL Transact SQL and cursors alternative

Databases

Let’s imagine that we have table where we store some service prices and that this price can vary regarding period of the year. You would then have something like this in your table: $50 from January 1st to May 31th $70 from June 1st to October 31th $60 from November 1st to December 31th What we want is to get all daily prices for given date region. So, if we give range from May 15th to 15th June we want to get this: May 15th $50 May 16th $50 May…read more

Instagram crashes on start – when big company make things wrong

Thoughts

I am having iOS 6 installed on my iPhone (intentionally didn’t want to switch to ugly iOS 7) and yesterday on March 4th 2014 I installed the Instagram update. After doing this, the application is crashing on start. It doesn’t open. On opening the background graphic is showed very quickly and then everything disappear (crashes). It is the perfect example how big company can make a mess making millions of users angry. I thing they are aware of this. What is surprising for me is that the new update is…read more

Geek weekend with Acer Iconia W700 tablet

System Administration, Technologies, Thoughts

Acer Iconia W700 is great piece of hardware for Windows type technical guys.  It can be a helpful tool when you are on the road or out of the office and need to get things done (no matter if you are a developer, system administrator or company owner). It is basically a PC tablet with a touch screen, with i5 IvyBridge processor  (3337U at 1.8GHz) and with Toshiba 128GB SSD disk. It has 11,6″ 16:9 screen with great, full HD resolution 1920x1080px and it has great battery life – maybe…read more