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

This held our work for few hours. When we tried to make a connection to SQL Server 2008 server with “Native OLE DB\SQL Server Native Client ...

I used to use Char data type for character data types of variable length columns, if the maximum number of characters that will set for the ...

Last week, two batches, one for 2780B (SQL 2005) and another for 6231A (SQL 2008) were successfully completed and will be starting my next c...

Sometimes, we switch the execution context to different account when required. One of requirements when connected in such a manner may be, f...

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

I am experiencing this error with Microsoft PowerPoint 2007, when the hibernated machine which had PowerPoint presentation opened, is start...

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

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

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

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

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

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

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

Are you experiencing this? You might. There are different set of connection related errors with PerformancePoint 2007. If you get errors lik...

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

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

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

This is the first workshop organized by IronOne Technologies. It was started on last Thursday and will continue till this Tuesday. I feel bi...

As you all know, measures are identified at the analysis stage of Data Warehouse/BI project. Are all identified measures KPIs? This question...

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

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

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