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

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 ...

Microsoft announces the availability of Service Pack 1 as Community Technology Preview for SQL Server 2008 R2. Here are some of enhancements...

I believe that everybody knows that Referential Integrity is for maintaining the relationship between two entities; Parent and Child. It mak...

As each attribute in a dimension can have a key column and optionally name column, attribute can be sorted by either key or name column. Sor...

The SELECT statement can be constructed with various clauses as per the requirement. It can be as simple as just a set of columns from a tab...

When I configured a subscription for Transactional replication with updatable subscription, the following error occurred. SQL Server could...