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

Thursday, July 16, 2009

Was really busy

›
Had no time to update my blog for few weeks, was really busy with work: - New BI project: This is for one of the leading banks in Sri Lanka...
Wednesday, May 27, 2009

Another victory of Sri Lanka

›
This clearly shows the reality, this shows who wants to destroy the great country, Sri Lanka. Sri Lanka won again, defeating the internation...
Thursday, May 21, 2009

PerformancePoint error: Unable to connect to Server

›
Are you experiencing this? You might. There are different set of connection related errors with PerformancePoint 2007. If you get errors lik...
Wednesday, May 20, 2009

Skipping prerequisities when installing PerformancePoint 2007 SP2

›
While installing the SP2 of PerformancePoint 2007, you may get an error like; Failed package requirement analysis, please refer to the log ...
Tuesday, May 19, 2009

Installing PerformancePoint 2007 SP2

›
If you are using PerformancePoint 2007 and you have not installed the SP2, then this is the time for installing it. As you know, it did not ...
2 comments:
Monday, May 18, 2009

Sri Lanka is free from Terror

›
After 30 years, His Excellency Mahinda Rajapakse, President of Sri Lanka has freed the country from LTTE terror, keeping his word. How for...
Saturday, February 28, 2009

Another BI workshop

›
This is the first workshop organized by IronOne Technologies. It was started on last Thursday and will continue till this Tuesday. I feel bi...
2 comments:
Thursday, February 12, 2009

How to distinguish between measures and KPIs…

›
As you all know, measures are identified at the analysis stage of Data Warehouse/BI project. Are all identified measures KPIs? This question...
3 comments:
Wednesday, February 4, 2009

Is your architecture leading to Stovepipe data mart?

›
Question arose while we were discussing BI. I asked myself, whats the hell is "Stovepipe" data mart, I was aware of the word but p...
1 comment:
Sunday, February 1, 2009

SSRS 2008 Video: Formatting text blocks individually in a single textbox

›
This is my first video, had been planning for months, and somehow was able to do one. I do not know whether the quality of this lesson is ok...
1 comment:
Friday, January 30, 2009

REPEATABLE READ is fine, but want to let others to read non-locked records

›
We usually set the REPEATABLE READ Transaction Isolation Level in order to overcome Inconsistent analysis (nonrepeatable read) and Lost Upda...
Friday, January 23, 2009

Reporting Services 2008 Error: The underlying connection was closed. An unexpected error occured on a send.

›
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...
9 comments:

Reporting Services 2008 Error: Invalid namespace

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

SQL 2008 Launch, Kandy: Few more pohotos

›
Doing my presentation. Giving a prize to a winner. All prize grabbers. SQL Server crew
Monday, January 12, 2009

Sucess of Community Launch of MS SQL Server 2008, in Kandy

›
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...
1 comment:
Sunday, January 4, 2009

Separating batches using a new word, instead of “GO”.

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

Community Launch of MS SQL Server 2008, in Kandy

›
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...
Thursday, January 1, 2009

MVP again

›
Microsoft MVP award team has decided keep my MVP title for another year. Thanks Microsoft award team, Microsoft Sri Lanka, Lead Lilian Quek ...
1 comment:
Wednesday, December 31, 2008

Index Properties window does not show the Fill Factor set

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

Happy New Year!

›
Hi everybody, wish you all very happy, lovely, peaceful new year!
1 comment:
Tuesday, December 30, 2008

Unable to process the objects in Analysis Services but deploy

›
This ate few minutes from my allocated time :). I was able to successfully deploy the Analysis Services 2008 project to another server that ...
4 comments:
Monday, December 29, 2008

How sys.dm_db_index_physical_stats - LIMITED shows the leaf level fragmentation?

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

Silly mistake I had made :)

›
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...
Sunday, December 28, 2008

Are practice exams worth to purchase?

›
I was thinking of doing 70-448 (MS SQL Server 2008 Business Intelligence Development and Maintenance) exam and thought to take a practice ex...
1 comment:
Sunday, December 14, 2008

Char column contains a lot of NULLs. Should change to varchar?

›
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-...
‹
›
Home
View web version

About Me

My photo
Dinesh Priyankara
Colombo, Sri Lanka
Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and business intelligence related projects. He is the Founder/Principal Architect of dinesQL (Pvt) Ltd and he consults, teaches and runs training programs on data related solutions and subjects.
View my complete profile
Powered by Blogger.