American Cemetery

Yesterday my family and I went to the American Cemetery. There are 17,097 headstones. There are still soldiers that are Missing In Action. We are thankful for the soldiers who sacrificed their lives for our country at the World War II, Philippines. My sister had fun running through the memorials. But I just stayed on my seat so I don't get asthma. I actually have asthma since when I was a baby.

I'm allergic to furry animals but that doesn't stop me from taking care of Agnes and petting Yumi, my tutor's pet Shit Zu. 

Chemical Reactions

When you hear the word ''chemical reactions''. What comes through your mind? Usually it will be mixing different chemicals and then there will be explosions, new formed creatures and lots more. But if you want to see a real chemical reaction  you need mint candies (optional) and bottled soda. I f you have mints put the mints inside the bottle and you will see an explosion. If you don't have mints just shake the bottle and you will see the same reaction like the mint with soda. This experiment is usually done by beginning and budding scientists.

Having a diary or blogging?

Having a diary

Diary owners need to have these values: responsibility, alertness and security. Usually people do ''blogging'' or ''online diary''. Blogs need to post but unlike diaries you can hide it and keep it private. Now let's talk about the advantages and disadvantages of blogging. Advantages: you don't need to bring your diary everywhere and not but it in bags, you can share experiences with other people and you can tell everyone your experience during you day. Disadvantages: you can post everything, you need connections when blogging, and your problem: there will be no connection in provinces. 

All has a right to have respect

Everyone deserves a respect from other people. Many people doesn't receive respect many of these were students . Some times students are victims of bullying, every thing changes when they are bullied every day and I am one of them. When I was grade 5 I am bullied just because of my actions. When I can't get rid of it I attempted suicide I choked myself and  I suffocated my self. But none of these took effect so when at the right time at February 14 I told my adviser about it. Students who realize bullying they tend to kill his/herself. Then I realized that I have the right to say anything wrong to the adults that I trust.

Nature, I will protect

I am really sad because  our nature is ruined because of our human activities that we did. Our animals are really endangered for example like the Philippine Eagle-Owl that can be only found in the Philippines and also sea turtles their shells are hunted so the hunters will be rich. These must be stopped because when it is too late we will all regret it that we ruined our Mother Nature's beauty and bounty

How to Run SQL Script in Command Prompt

sqlcmd -S myServer\instanceName -i C:\myScript.sql

Reference :http://msdn.microsoft.com/en-us/library/ms170572.aspx

How to get SQL Instance Name.

set nocount on

Declare @key Varchar(100), @PortNumber varchar(20)

if charindex('\',CONVERT(char(20), SERVERPROPERTY('servername')),0) <>0

begin

set @key = 'SOFTWARE\MICROSOFT\Microsoft SQL Server\'+@@servicename+'\MSSQLServer\Supersocketnetlib\TCP'

end

else

begin

set @key = 'SOFTWARE\MICROSOFT\MSSQLServer\MSSQLServer\Supersocketnetlib\TCP'

end

EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE', @key=@key,@value_name='Tcpport',@value=@PortNumber OUTPUT

SELECT CONVERT(char(20), SERVERPROPERTY('servername')) ServerName,

CONVERT(char(20), SERVERPROPERTY('InstanceName')) instancename,

CONVERT(char(20), SERVERPROPERTY('MachineName'))

as HOSTNAME, convert(varchar(10),@PortNumber) PortNumber