Dinesh's Blog :::: Being Compiled ::::

The cumulative update #3 for SQL Server 2012 is available for downloading now at: http://support.microsoft.com/kb/2723749 . Make sure you ap...

As I get many offline questions regarding the presentation “Reducing RoundTrips” I did, thought to summarize the content we discussed as a p...

The @@IDENTITY is a system function that returns last generated identity value. But the question is, is it the last identity generated by my...

There are some instances we have to create parameters with multiple items, including an item representing all items in the list, mostly call...

As you all know, Pivoting and Unpivoting are supported with SSIS but the implementation of PIVOTing is bit difficult when compared with UNPI...

Everybody knows how important logging is, when it comes for troubleshooting. It applies for SSIS packages too. Unfortunately, most of develo...

Simple thing that you may not know ………. Structured Query Language was born in 1970, supporting Edgar F. Codd’s Relational Database Model. ...

If you run on 64-bit environment and try to debug a script task after placing a breakpoint, it is not going to work as you expect. The reaso...

This is not about processes or usage of Business Intelligence solutions, it is about usage of this term. Unfortunately it looks like this is...

Few days back, I faced for a strange issue with PerformancePoint web-parts. It was a simple thing, all I had was, a web page created with Sh...

Understanding how SQL Server resolves objects’ names will be an effective remedy against performance issues. This name resolution happens if...

Setting the value of this option as GLOBAL has been understood wrongly by many developers. All you have to remember is, this “ global ” doe...

If you plan for doing MS exams, better hurry up. Following certifications are slated for a price increase: Microsoft Certified T...

Think about a scenario where you have to show your top 10 customers based on their purchases. If the record set is as below; and if you ...