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

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

Are you unable to find the Decomposition Tree in the menu? Is it not visible? Reason is simple, make sure SilverLight 3 (or 4) is inst...

Configuring Reporting Services 2008 R2 in SharePoint 2010 Integrated mode is straight forward and simple. If you have read my post Configuri...

Annoying…. This is all about SharePoint integrated Reporting Services deployment via BIDS. Web application for Reporting Services has been c...

If you face for this error when connecting to SharePoint site through PerformancePoint designer; … then check the domain account which...

If you face for this error when connecting to SharePoint server from Dashboard Designer; … simply add the site for Trusted Sites in you...

Course 6231A: Maintaining a SQL Server 2008 Database – This is my first class for 2011. Class will be started on Sunday, 23rd January 2011. ...

Everybody prefers a good URL for sites rather than server name with ports. Same for SharePoint Web Applications (SharePoint sites). When a W...

MVP again! Microsoft has awarded the title again for the 6th time, thanks for Microsoft, Microsoft Sri Lanka, Wellignton and Lilian ...

While configuring Analysis Services security on Dimension Data, I did not pay much attention on two options available with the screen; Selec...

Is the famous rule of thumb broken? I am sure that you all are aware the rule and you know that DENY always wins over GRANT. If you want to ...

The Era that Business User is used to carry an armload of tools for analyzing and visualizing data, has come to an end!!!!! Yes, Microsoft n...

Microsoft Reporting Services is an enterprise-capable reporting solution that can be used to create all types of reports such as Production,...