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

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

Replication is used for copying data and database objects from one location to another on a recurring basis. The topology of replication is ...

The February meeting of SQL Server Sri Lanka User Group meeting was held on last Wednesday and sessions were done by Dinesh Asanka and me. M...

The Guest user is an account which is automatically created when a database is created. This account is used when a login connects to a data...

Although this is not much popular among DBEs, it is one of the facilities should be used. The Template Explorer gives us various type of tem...

It came up while my class was being conducted. We were discussing of finding the size of files attached to a database and available free spa...

Microsoft PowerPivot is slowly becoming an essential technology for Business Users addressing Self-Service Business Intelligence. It is inno...