Category Archives: Uncategorized

Project Oxford: Computer Vision API pros & cons

Microsoft project code named Oxford has number of interesting APIs. Let’s dig into one of them – OCR. Computer Vision API provides OCR conversion from images to text. It could be tested from here. It is really fast, but requires understanding of the subject. … Continue reading

Posted in Uncategorized | Leave a comment

All date formats in one query

WITH N0 as (SELECT 1 as n UNION ALL SELECT 1) ,N1 as (SELECT 1 as n FROM N0 t1, N0 t2) ,N2 as (SELECT 1 as n FROM N1 t1, N1 t2) ,N3 as (SELECT 1 as n FROM … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Tea(m)making golden rules

That is brilliant metaphor by adding “m” letter to get 5 golden rules of team building.

Posted in Uncategorized | Tagged , | Leave a comment

Shoot me if I create that table

I have seen “that” table many times in different systems. It sounds like alien from another planet irresponsible developer creates that table without understanding how many efforts would be spent to maintain that structures. I am talking about organizing date ranges, aka slow changed dimension (SCD). … Continue reading

Posted in SQL, Uncategorized | Tagged , , , | Leave a comment

How to get enterprise features within budget edition. SSRS

Typical question which I was asked many times. Ok, here is my report, can you send it to XXX when YYY is happened? Usually I say, sure we can use data driven subscription and … wait a minute, do you have SSRS express/standard edition? … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Motion on steroids

Buisness is constantly looking for new user experience. Industrial control systems (SCADA, PLC, etc.) provide machine to machine, human to machine interfaces. They are all about sensors. But they look too complicated and not always user/developer friendly. I have spent 3 years in automation … Continue reading

Posted in Uncategorized | Leave a comment

Second shot. LightSwitch HTML Client Preview 2

As was promised, Microsoft announced HTML5 Client Preview 2. It looks I am last person in LightSwitch v2 community who did not post about it. Yes, it is highly desirable and expectable feature. It was not included in official release of Visual Studio … Continue reading

Posted in Uncategorized | Leave a comment