I was conducting training recently where the participants asked for a solution on how to convert data from many different currencies into a target currency using an exchange […]
5 Mary series, SSIS using TSQL in MSBI
An All new video on using TSQL task in SSIS to run a query and fetch data from the database and assign it to a table. All part […]
Unable to establish server mode SSAS tabular mode
Ever encountered the above error when starting SQL server management studio and connecting to SSAS ? The error has a few different root causes one of which is […]
Not getting options when right clicking the report in report manager
I came across this issues today while doing a training today reporting services report manager doesn’t display the options when you right click the report . See the […]
Mary Series 3: Using SSIS to extract terms
All characters, events and data in this series are fictional. Any resemblance to any person living or dead is simply probability at work (More on that in the […]
The world needs to watch this
We are not promoting this video as an ad but simply a social awareness program. It hits home on the fact that Simple is Better doesn’t apply to […]
How would you get the most out of 10 Rs?
Today, we were chatting about efficiency and how it is different from utilization and we thought we would conduct a poll about it. So here is the background. […]
Part 3 of 4: Video on Difference between partitioning and just multiple FGs
Sorry it took so long but here is the third video in our 4 part series on MS SQL Server partitioning. http://www.youtube.com/watch?v=GSNYGpNbidc I cover the difference between simple […]
Mary connects her Excel sheet to SQL and start using pivots to view her data
All characters, events and data in this series are fictional. Any resemblance to any person living or dead is simply probability at work (More on that in the […]