SQL Ninja gets Products from Group Tree CTE

Hi, today I want to show you comparison of 2 possible techniques fro get data about all Products mapped to the Product Groups tree. I wrote as usual one T-SQL script that you can run each time you want to modify something to recalculate your results and check how they perform in your SQL Server. There are 2 nice things you can get from provided example. First is 2 ways of calculation that you can choose from. Continue ReadingSQL Ninja gets Products from Group Tree CTE

SQL Ninja moves Data in Auto Balancer Loop

Hi, today I want to share with you one of my last invention. That is extremely useful when you need to move data for example to historical or archive tables on your SQL Server. Imagine that the same moment you move your data someone can with lower probability use table you move data from. When you decide to insert data to new table and then delete them of course in delete query you lock whole table. Now Continue ReadingSQL Ninja moves Data in Auto Balancer Loop

Coding by to Design of KinectCamV2

Hi, today I want to share with you design example of KinectCamV2. Steve Jobs sometimes used to say that design is not about how solutions and devices look, it is about how they work. And I just have seen today very nice design example at home of KinectCamV2. So, at this moment I had a good idea of today’s post for my blog. I think the best example of any design is to watch how people use Continue ReadingCoding by to Design of KinectCamV2

The Clock

Hi, today I made a nice clock for my blog, I put it just under my picture on it. And because I like the way it is build I want to share the solution with you. This solution is nice, because it uses ProcessingJS library. And because I really like analog watches and I like the simple way I was able to made it I want to share the solution with you. You can download source code Continue ReadingThe Clock