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

We usually set the REPEATABLE READ Transaction Isolation Level in order to overcome Inconsistent analysis (nonrepeatable read) and Lost Upda...

It hit me again. This does not allow you to deploy any reports or open report manager via the browser. This is because of the invalid conf...

This error comes when we try to configure Reporting Services 2008 with Reporting Services Configuration Manager . The reason for this is fu...

Doing my presentation. Giving a prize to a winner. All prize grabbers. SQL Server crew

I am proud to announce that the SQL Server 2008 Community Launch, Kandy took place in grand scale. This was organized with some great diffic...

Can we use a different word instead of GO ? Yes, it is possible because GO is not a T-SQL statement; it is a command that is recognized as ...

We, SQL Server MVPs are organizing Community Launch of SQL Server 2008, next week in Kandy and 4th week of January in Colombo with the suppo...

Microsoft MVP award team has decided keep my MVP title for another year. Thanks Microsoft award team, Microsoft Sri Lanka, Lead Lilian Quek ...

This was another issue we came across. See the below images, They show the same index property of AdventureWorks database in 2005 instance. ...

Hi everybody, wish you all very happy, lovely, peaceful new year!

This ate few minutes from my allocated time :). I was able to successfully deploy the Analysis Services 2008 project to another server that ...

This question of raised by one of my students in my new batch, excellent question. We all know that when we use LIMITED mode, it scans only ...

I had written code filtering some records out and had assumed that it would produce the result I want. After few minutes I realized that how...

I was thinking of doing 70-448 (MS SQL Server 2008 Business Intelligence Development and Maintenance) exam and thought to take a practice ex...

Most of the time, the decision of the usage of data types, char or varchar is depending on, whether the values are fixed-length or variable-...

Another batch for course 2779B that is for exam:70-431 was started on last Saturday at NetAssist. Fourteen students have been registered but...

I had installed Klipfoloio for testing purposes, and then I decided to uninstall it today. Un-installation started smoothly, once the “done...

I was facing some issues with my SSIS packages and thought to install hotfixes that have been released after SP2. I had a cumulative hot fi...

Are you using? I have been looking for some nice, elegant chart controls for Office PerformancePoint 2007 but still the search is not succes...

Few months back, Microsoft had announced the next version of SQL Server ~ Kilimanjaro ~ that is due on 2010. Two major things related to the...

If anyone look for my previous blog posts, please visit  http://dineshpriyankara.spaces.live.com . I still use live.com blog but not for tec...