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

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

The success of Business Intelligence solution can be measured with Visualization of data, hence Visualization in proper manner is important....