I have been trying to complete NandToTetris Course Part one,and finally completed it due to recent holidays.Taking this course has been extremenly satisfying. I highly recommend taking this course if you want to understand computer internals and want to thank the Shimon Shocken and Noam Nissan for their valuable time... [Read More]

Missing index recommendations should be not blindly trusted,even for a single query..Below is a small issue i faced today..You need to download performancev3 sample database from Itzik Ben-Gan to follow below example.. [Read More]

Thank you everyone for 2000 likes on facebook page.This means a lot to me.I am trying to post atleast once in a month,but there are many things going on in my life as of now…I will try to post once a month for sure. [Read More]

Microsoft released SQL Operations studio for Mac,Linux and Windows.This editor is highly configurable,one particular thing caught my attention was creating Insights.. you can think of this as SSMS Inbuilt reports.. [Read More]

SQLSERVER 2017 introduced a new function called TRIM.It’s just a replacement of LTRIM,RTRIM..Let’s see a quick demo to see how that works [Read More]