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

Tuesday, August 25, 2009

New class on 2780B

›
I started another class for course 2780B - Maintaining a Microsoft SQL Server 2005 database. Though I wanted to do this on 2008 (6231A), thi...
Monday, August 17, 2009

Microsoft XPS Document Writer cannot be found

›
I am experiencing this error with Microsoft PowerPoint 2007, when the hibernated machine which had PowerPoint presentation opened, is start...
8 comments:
Sunday, August 16, 2009

Are you using "Windows Services window" for changing the SQL Server Service Account?

›
If you are using the "Windows Services" window for changing the assigned account for SQL Server service, you may face some problem...
Monday, August 10, 2009

PerformancePoint error: Unable to connect to Server - Part II

›
Once I blogged about this error with this link . Today I faced the same, but the reason was different. My new machine is installed with Vis...
Saturday, August 8, 2009

Connecting to Analysis Services with the Port Number

›
First of all, let me tell you that why I need to connect to Analysis Services with the Port number; because the Analysis Services 2008 is ru...
4 comments:
Wednesday, August 5, 2009

Foreign Keys with TinyInt do not recongnize by SSAS

›
This is still there, with SQL Server 2008 too. I usually use TinyInt for tables' primary key when the number of records to be held are l...
2 comments:

Restoring one File Group

›
Today, I came across a situation where I had to explain the FILEGROUP restore of SQL Server. Since I have not done this for a long time, I b...
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:
‹
›
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.