Change β€˜Edit Top 200 Rows” on SQL 2008

Working with live data and ‘concerned’ clients, i always have to recheck and modify data from database using SQL 2008. 

The default value for editing table only 200 rows, and the rest i have to do it using script. A bit tedious because i cannot actually read the data and edit it. 
But here is the solution yey πŸ˜€
Tools >Options >SQL Server Object Explorer, Expand this tree β€˜Commands’

I change the ‘200’ to 0 , and i will get all data πŸ™‚

Hope this will help πŸ™‚

This pregnancy and my skin become all dry..

When some people says during pregnancy you’ll glow and the skin will be softer, plumper and beautiful. Well not everything is a myth, but it’s all depend on the person. For me my skin become dry and i sometimes feel like an alligator πŸ™

Now in my 15 weeks, my baby bump become obvious. I am now having problem putting lotion on my leg..It’s quite hard to bend haha..i have to sit down and take my leg up so i can put the lotion on. 
How do i prevent or at least minimize the dry skin? Based on some reading i found out that:
1.  Warm but not hot.
Having frequent hot shower / bath will take away the moist on the skin. So avoid it. Try to just lukewarm water. Our skin is not like a sponge (the more it on water the more it absorb), no. Hot water will strip your skin from its natural oil barrier.
2. Avoid alcohol contained cleanser.
Alcohol can make your skin dryer. If can wash with soapless cleanser.
3. Cover up
Never never go out without sunblock. Me myself i use at least SPF30.  Use any sunscreen product suits you.
Well there you go, 3 tips but at least some idea rite πŸ™‚
   

No juicing during pregnancy?

Yes of course you can!

 During my first trimester i have a very very i mean very bad all day sickness. I lost 5kgs just in 3 months. I would be so happy loosing weight if i’m not pregnant πŸ˜€ .

I really need to get all the nutrient i can get for my baby, but i can’t barely eat anything. So i decided to drink lot and lots of juice to gain nutrient. Of course with meal too. During pregnancy you cannot do juice diet! No no and no. Detoxing by juice diet will harm your baby, since you will flush the toxin through your bloodstream and end up you pump it to your baby. So again NO, drink juice but eat your meal.

Here is one juice that i really love.

Ingredients:
1. Cucumber
2. Carrot
3. Celery

Blend it all together and drink immediately. It’s yummy!

Homade baby wipes :)

Another 5 months for me n hubby to prepare ( mentally and physically hehe) for our baby.. I haven’t do any baby shopping yet since i don’t know where to start – i have my long list i haven’t really recheck.

But well, i am someone who won’t spent a lot for my  baby stuffs. I prefer to save more on my baby’s college fund rather than spend it with expensive unnecessary things. I never knew that baby stuffs nowadays is really expensive – well just because some people love to spend on expensive stuffs for their baby. Expensive doesn’t mean good, sometimes it’s just because of brand and commercial.

Ok i found a very useful tips to do my own baby wipes.

Main Ingredients :
1. Baby wash
2. Baby oil
3.distilled water
Optional :
1. Tea Tree oil (To prevent Rash)
2. lavender oil 
Mixed all together and you can use it with clean,soft fabric. You can wash the fabric after use. Reusable and go green! :You can also check this comparison for branded baby wipes if you prefer to buy.

Top 10 Baby Wipes: A Side by Side Comparison

Shoppers may want a quick go-to guide for a side-by-side comparison of different baby wipes brands. The chart below compares the features of each brand.
Brand
Hypoallergenic
Additions
Flushable
Free of chlorine, parabens, and alcohol
Biodegradable
Huggies
Some
Available with aloe and Vitamin E
Some
No
No
Pampers
Some
Available with aloe and Vitamin E
Some
No
No
Seventh Generation
Yes
No
No
Yes
No
Luvs
No
No
No
No
No
Earth’s Best
Yes
No
Some
Yes
No
Bambino
Yes
Chamomile, aloe, and lavender
Yes
Yes
Yes
Naty By Nature BabyCare
Yes
Available with scents, lotion, or aloe
No
Yes
Yes
Charmin
No
No
Yes
No
No
BabyGanics
Yes
Skin conditioners and emollients
No
Yes
Yes
gDiaper
Yes
Aloe and Vitamin E
No
Yes
Yes


Get image details using PHP

Syntax

list($width, $height, $type, $attr) = getimagesize(“image_name.jpg”);

Code

This is a sample code, change image_name to your image name and test it!

list($width, $height, $type, $attr) = getimagesize(“image_name.jpg“);

echo “Image width ” .$width;
echo “
“;
echo “Image height ” .$height;
echo “
“;
echo “Image type ” .$type;
echo “
“;
echo “Attribute ” .$attr;

?>

Simple rite πŸ™‚

Back running

It had been (and still) a hard weeks for me for the first trimester.. 8 weeks and having bad morning and evening sickness.. I tried to keep my daily as normal as possible, but it’s quite challenging.

I feel tired all the time , vomiting and headache. I miss running. I miss being outside and sweating.

And…today i decide that all this morning evening sickness must end. I must push myself and start workout again. Of course it gonna be very very slow and i think i will just do my power walk today, see how it goes. Hope i can slowly gain back my energy and stamina. While baby still very fragile, i know my priority..

The more active and fit you are during pregnancy, the easier it will be for you to adapt to your changing shape and weight gain. It will also help you to cope with labour and get back into shape after the birth.

Ah.. can’t wait for the clock to hit 5.30 πŸ™‚

Everything in short – and i am with my new life :)

February 2014 it is.

What happening during my absence in this blog? I get married on August 2013, went to Bali for honeymoon, having my second reception on December 2013 and…. now 7 weeks pregnant  πŸ™‚

Well everything happen sooo fast and im not sure if i register it well in my brain yet haha. But I am so blessed and thanking God with the gift and the life He choose for me.

Now life is full with planning for our little family. Life will be different and more and more fun!

Have a blessed Wednesday everyone πŸ™‚

How to save money on…food..in Kota Kinabalu.

Food in KK is really expensive. You won’t get any complete food if you only have RM3, at least you need to have RM10 on hand if you want to eat outside.

Saving on food is one of the easiest way to do. Some people says when you stay alone, it’s cheaper to eat outside than cook your own meal. But nah, that’s just an excuse actually haha.
I only spend around RM40 weekly to buy groceries and it can lasts more than a week actually. Let me give you some example :
Veggies 1 : RM2 ( for 3 meals)
Vegge 2 : RM 3 ( for 3 meals)
Chicken : RM 4 ( 3 or 4 meals)
10 eggs : RM4.50 (5/6 meals)
frozen food : RM8 ( 8 – 10 meals)
Fish : RM12 (4 -5 meals)
Others : RM10
If you eat outside:
Breakfast ( Mee + telur mata ) + drinks : RM5.50
Lunch  : RM8
Dinner : RM8
If you have RM40, eating outside can lasts u only 2 or 3 days. But if you cook, it can lasts for more than a week.  You only spend RM50 the most per week if you cook. So it’s only maximum around  RM200 per month. And you can eat healthy and delicious food!
Having your meal outside you will spend around RM350 or RM400 monthly. See the difference? You can save up to RM200 per month, which is RM2,400 per year!
And again what you can buy for RM2,400 ? You can settle your life insurance :).
Well it’s an individual choice and i just happen to choose to spend wiser and save a lot so that maybe someday i can live my dream πŸ™‚
Happy Monday people!

Being 30

Being 30 in 2 months plus now and i’m already feel the stress ha ha. I’m no longer so called women-in-their-20s but move a level up :).

When i was in my 20s weekend means go outing having fun with my friends. Thinking which movies haven’t watch, do my hair do my nails.  And after work will waste with hanging out with friends at some cafe.
Now weekend is about planning and executing. Trying to squeeze all the time i have to get more info, knowledge and money :D. Movie day turned to seminars, classes or reading some investment book. Haha. Well looking at the amount of saving in my account , it won’t survived me long enough, and im already 30! 
But of course i will always have time for myself, well i have to reward myself for all the hard work i did hehe. Like going for a cruise this weekend, oh i so can’t wait! πŸ™‚ 

How to increase Dropbox storage for free

I am new to Dropbox since i am very loyal to Google Drive πŸ˜›

But since i am looking to new storage of my too many stuffs, i finally accepting dropbox in my life :),but it only give 2G free storage when you first join. Unlike Google Drive which gives me 15MB now – as i said i am very loyal to Google drive he he.

But wait, i can actually increase my Dropbox storage, and i just did!
What i do is just login to my Dropbox, go to Bonus Space, and i simply invite my friend. Note a friend, not friends hehe. And walla! My storage increased to 50GB!

If you need more space , why don’t you try this trick πŸ™‚