This new DMV is basically a modified version of the DBCC IND command that is used to display the page allocations for a specific database object like a […]
Business Intelligence on a Phone Bill
I often tell my trainees that BI can be done on pretty much anything. A common example of this is the Phone Bill or the Bank statement. Your […]
Why BI professionals should believe in Aliens
I am pretty serious about this one, not because I believe in UFOs or any other extra-terrestrial theory but because as a DBA who implements Business Intelligence solutions […]
Row level permissions in SQL Server
We all know that SQL allows object level permissions down till the table, some of even know that it allows permissions at the column level too. But recently […]
Metrics vs Mass appeal? What companies probably don’t yet understand.
I wanted to ask a question today instead of blogging about a topic. To be honest I don’t know the answer to this question and that is why […]
CHN SQL Azure 17th -19th
Just finished an action packed MSBI training in HYD and now on a quick break before heading to Chennai for SQL Azure training. Can’t wait to meet and […]
When it’s an Emergency, what do you do ?
I recently needed to send a courier on a very urgent basis to a friend of mine and was stuck on how to do it. Time was critical […]
Why I Train
It is always rewarding to hear back from those who have attended my trainings. Recently I have been getting a lot of emails and face to face meetings […]
SQL INJECTION using Dynamic SQL and How to fix it
At a training recently I was explaining how to do as well as prevent SQL injection and figured I should make a blog about it since very few […]
Optimistic concurrency
Hi Jayanth, QUESTIONHope you are doing good.My question is :Is there a way 2 select from tables with no timeout when u r inserting data into them via […]