root@geeklanka$_

How to distinguish between measures and KPIs…

Is your architecture leading to Stovepipe data mart?

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

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

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

Reporting Services 2008 Error: Invalid namespace

SQL 2008 Launch, Kandy: Few more pohotos

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

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

Community Launch of MS SQL Server 2008, in Kandy

MVP again

Index Properties window does not show the Fill Factor set

Happy New Year!

Unable to process the objects in Analysis Services but deploy

Silly mistake I had made

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

Are practice exams worth to purchase?

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

New batch for course 2779B

Why Kilpfolio-Uninstall open so many browsers?

MSSQLSERVER 2005 update 3073 == 3282 ???

Next version of SQL Server - Kilimanjaro

Third-party controls for Office PerformancePoint 2007

Please note that I have started a new site for blogging technical related things. The site is;
 
http://dinesql.blogspot.com/.
 
If you have added this site for seeing technical posts, please get the new URL added.
 
 

I experienced an issue with SQL Server 2008 installation. The installation was not successful and the reason prompted was "SQL Express tools". And I have not installed any express tool :).I searched the Internet and found out that the reason is "SQL Prompt" tool. Once uninstalled, the 2008 installation was successful. Read this discussion for [...]

My first article on SQL Server 2008 has been published at http://sql-server-performance.com. I wrote this article based on the tests I did regarding Transparent Data Encryption (TDE) that is newly introduced with SQL Server 2008. This articles covers; What is Transparent Data Encryption? Implementation of TDE. Is my database secure now, as it says? [...]

Yossi Elkayam has done a nice add-in to the BIDS that allows you to save views created for SSAS and run them as new requests. Seems this is very useful if you are currently working on a SSAS project.Read more and download from here.

I am back. I did not write anything on my blog for last two months, I am not sure what kept me away from my favorite area, my blog. One reason would be, I guess, I was influenced by many things. Few things I want to make a note on; My Personal lifeMany things came [...]

Gogula (MVP)Buddhika (MVP)ChandanaCharithEuan GardenFiqriJinath (MVP)KavindaLudmalMadawaMahasenMerill (MVP)Prasanna (MVP)ThusharaWela (MVP)Yeshan

We started a new series of sessions, called "Know before doing it" for SQL Server Sri Lanka User Group Meeting and the first part of it was presented at the last meeting. I did a the first part of it, demonstrating some of the internal process of SQL Server and feedback from the audience for [...]

Gogula has written, good, properly explained article on SQL Server 2008, one of the newest data types, hierarchyid and has been published at http://sqlserveruniverse.com . It is a very useful article, worth to read it.Click here to read the article.

I have been doing lot of development on SSIS for last two, three months and I made this note on what I faced during the project. It may useful for your future SSIS development, or brush up your SSIS knowledge. Read and see.Click here to read the article.Anyway, original name for the article was not [...]

My latest article, Data Comparison with Data Dude has been published at www.sql-server-performance.com. This talks about the way of comparing the data between two data sources and scripting the changes.Read and see, click here to visit the site.

Had to spend few minutes on this, to resolve the issue but found no solution. The problem was really weird. It was with variable window; Look at the variable window. All buttons are disabled, disallowing creating or modifying variables created. I made a search to see whether anyone has experienced this before but could not find [...]

Here is a chance to show your colors and win very valuable prizes. All you have to do is, write some, creative, good code on SQL Server 2008 that will help to the community and send to CodePlex.For more details, click on here.

Have you ever tried this and seen the speed of file allocation process? Though I had heard about it, I had not tried (I might have but I cannot remember :)). The default file allocation of SQL Server is zero initialization that takes long time when you try to create a database with a large [...]

Since the 20th is a Poyaday that is a mercantile holiday in Sri Lanka, we decided to have SS SLUG meeting on 21st, Thursday. Fiqri, ASP.NET MVP is going to join with us this time, showing his knowledge on SQL Server mobile edition. I am sure that Fiqri is going to deliver very valuable info [...]

Another note of mine talks about "Schema Comparison with Data Dude" has been published at www.sql-server-performance.com. This shows the way of doing the schema comparison and how Data Dude addresses the changes.Read it from here and let me know whether it is good enough for readers.

Two of my articles have been published; one at http://sql-server-performance.com and http://sqlserveruniverse.com.Test Data Generation with Data DudeThis article explains the usage of Data Dude for test data generation. It is published at http://sqlserveruniverse.com.SSIS: Usage of Checkpoint FileI wrote this few months back and it was in the queue. I made this note based on the [...]

The latest version is available with new stuff; with new rules, enhanced facilities for documentation, more support for SSAS. I did not test anything yet but you ca start testing, using it.Download the BPA from here.

My MVP title has been renewed, for the third year. I believe that I have done a fair community service last two years and thanks for Microsoft for evaluating and awarding me the title again.Two new MVPs have been introduced but I expected the count as three. Hope that third one is being reviewed by [...]