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

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 more info: http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3457603&SiteID=17

This time Gogula did a session regarding Views, not just about views but options, things we did not know, etc.. Next one was from Preethi. He did a presentation about trouble-shooting SQL Server that contained excellent information about trouble-shooting, performance info gathering and some real-world samples. Both did a very nice job.

The presentations and samples will be available soon at the http://sqlserveruniverse.com. Here are some of photos;

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?
• What needs to be considered before enabling TDE?
• What is the impact when TDE is enabled?

You can read my article at http://sql-server-performance.com/articles/dba/Transparent_Data_Encryption_p1.aspx. Please let me know you thoughts on this, you can either add a comment to the article or send me an email to dinesh@sqlserveruniverse.com. I will writing two more articles on SQL Server 2008, will be publishing at http://sqlserveruniverse.com and http://sql-server-performance.com.

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 life
Many things came and went, happiness, sadness, love, affection, success, failure... Most shattered my life with both green and red lines. I got sick again and had to hospitalized for couple of days. I was suffering from lot of sickness, some were known to me, and some were newly diagnosed. Many thanks go for Dr. Chandima de mel, my family, my friends and, Nawaloka hospital staff. Special thanks go to a person, who stayed with me in every possible minute, until I got recovered. I experienced a lot, with all of that, hereafter I will be singing a different tune.

My Msc :)
I have completed all my exams, assignments and, I am in last stage of the Msc, which is the project. I started doing the project, started with project proposal, project charter and finally poster session that gave me both good and bad comments :). I will be completing my Msc by end of August, hope I can get through without any complications.

My Database life
I started exploring SQL Server 2008 few months ago, gradually absorbing it. I recently did a session at SQL Server Sri Lanka User Group meeting on SQL Server 2008 - new features. Still I had no chance to use it with any commercial applications, hope will have a chance soon.

Our http://sqlserveruiniverse.com web site
It is growing and growing, spreading the word of SQL Server. Must thank Gogula for his dedication to the site, he has done a great job in my absence (even in my presence).

Doing my presentation.	Dinesh Asanka, Gogula and me, getting ready for the community launch.

That's about few things happened in last two months. I will be writing technical related things again in my blog, so, stay tune.

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 the session of really good.

Use this link to get all the presentation we did at last meeting, including Preethi's great presentation about Performance of Stored Procedures.

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 this :), thanks for Gogula, naming it with nice title.

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 anything related to this. However, closing and reopening the packed resolved the problem :).