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

Few days back, one of my friends asked me whether there is a way to find the last accessed date of their SQL Server databases. What he reall...

I have worked with many products/projects and have played many roles in projects such as developer, tech-lead, DBE, DBA, project manager :...

If you are working (or have worked) with a Reporting Services project, you know that most of the reports have similar characteristics such a...

Are you interesting in SQL Server 2008 R2 resources? Here is a good resource. It is a free eBook, published by Microsoft Press. Click on the...

Just created a Polygon-Layer Sri Lanka map using SQL Server 2008 R2 for showing population by provinces. It is fun to work with R2, I will s...

Have you ever come across a situation where you need to disable an action set to a series in Reporting Services? If so, you might know that ...

When I was installing and configuring SharePoint 2010 in my machine, the following error appeared, stopping my installation. The specified...

If you are planning for installing SharePoint 2010 on Windows 2008 R2, here are some installations should be done before starting the ShareP...

If you have read my previous post “ Reporting Services Error on Doughnut Chart when Tooltip is set: Parameter is not valid ”, you know about...

One of my colleagues had been facing a funny issue since yesterday, and I had to find a solution for it. It is related to Reporting Services...

How do we make sure that we accept values for datetime columns correctly? Has the month stored as it has been sent? Has the day stored as it...

If you have read my previous post , you know why I went for “ OLE DB - Microsoft OLE DB Provider for Analysis Services 10.0 ” instead of “ M...

If you try to set some other dimension elements as the first axis other than measure dimension, you will receive an error like below: ...

If you see a “missing” issue with ADOMD.NET and SQLNCLI when configuring PerformancePoint 2007 on Windows Server 2008 R2, Download the lates...

Sri Lanka SQL Server User Group meeting will be held on Wednesday, 17th March, at Microsoft Sri Lanka. Dinesh Asanka will be doing a sessio...

When we execute DELETE operations against tables, SQL Server is supposed to delete records and deallocate emptied, associated data pages. De...

If my composed mail has a sentence like “… find the attached …”, click on send button shows below:

When a scalar value has to be compared with a single-column set of values, we usually use IN or JOINs. In addition to that, we can extend th...