Thursday, June 5, 2014

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 :D

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 :)

Tuesday, April 8, 2014

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 :)


   

Monday, April 7, 2014

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 :D .

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!


Sunday, April 6, 2014

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




Related Posts with Thumbnails