Glad to announce that we have a new video on YouTube explaining how to export a database hosted in SQL Azure into a BLOB storage account and then […]
What I am reading: Nikola Tesla (Sean Patrick)
Just finished reading Nikola Tesla by Sean Patrick off of Google Play. The book tried to provide inspiration to the reader by covering the challenges Nikola faced during […]
Datawarehouse and Plastic Bags ….
I was recently having a discussion about the role of default values in the fact table. The example being discussed had to do with a retail business who […]
What I am reading: – Day Trading Secrets (Harvey Walsh)
Starting today we are also including a list of books read by us when we are not coding, developing, attending meetings … Jayanth has always been a voracious […]
Bangalore – Bengaluru Slowly Changing Dimensions
I would like to introduce Type 6 EBS Modified SCD and get your feedback. I couldn’t find any documentation explaining this approach so I guess this is a […]
When does a machine become human? When they can Lie…
Don’t worry I am not talking of androids or cyborgs. I am talking about the classical definition used to determine artificial intelligence. The most widely used benchmark or […]
It’s gorGEOus what you can do with this data type
Had some spare time on my hand today and created the company logo in the MS SQL Server Geometry datatypes. The Geography and Geometry datatypes are one the […]
Proof that MS SQL Server is the better relational database
I am probably going to start a war with this one but I need to set the record straight. Often in my trainings I have a mix of […]
User based security in SSAS
Recently a trainee from one of my MSBI trainings contacted me about how to implement user based security in SSAS. This is a common requirement where companies want […]
Game Theory and Databases
CASE 1 Two members of a criminal gang are arrested and imprisoned. Each prisoner is in solitary confinement with no means of speaking to or exchanging messages with […]