TRUNCATE Log File in SQL Server 2008

USE [TestDb]
GO
ALTER DATABASE [TestDb] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(TestDbLog, 1)
ALTER DATABASE [TestDb] SET RECOVERY FULL WITH NO_WAIT
GO

How to upgrade to VMware ESX 4.1 or VMware ESXi 4.1 using esxupdate

Watch the video here:

or download it from here.

VMware ESXi

Step 1. Connect to ESXi console and press the Alt+F1 key combination.

Step 2. Type unsupported and then press . Note that nothing will appear on the screen whilst you type this.

Step 3. When prompted enter in the Root password and press.

Step 4. You will now be presented with a prompt on the console. From this prompt type vi /etc/inetd.conf

Step 5. vi (the file editor) has now opened the inetd.conf file. Using the direction arrows scroll through the lines until you reach the line that has #ssh and remove the hash (ie: #). This is effectively un-commenting this line so that the ssh service can be started.

Step 6. Now that you have made this minor file you want to save this change and exit out of the editor (vi). To do this press the ESC key (to put vi back into Command Mode) and then type :wq *Note: If you want to exit without saving any changes to the file then just press the ESC key (Command Mode) and then type :q!.

Step 7. With the SSH service now un-commented from this file we want to restart the

How To Download YouTube Videos

  1. find the URL of your favorite YouTube video
  2. go to VideoDownloadX.com and paste the video URL into their download box
  3. now click “Download” and it will present a list of links to download video in different formats / quality

Bulgarian Pancakes

How to make pancakes – the Bulgarian way

Ingredients

  • 3 eggs
  • 1 cup milk (1 cup = 240 ml)
  • 1 cup water
  • 3 x 1/2 cup white flour
  • 2 tablespoon sunflower oil or olive oil
  • 1 teaspoon salt

Preparation

Mix the eggs, the milk, the water, the oil and the salt in large enough pot.
Start adding the flour gradually stirring the mix at the same time until it becomes homogeneous.
When ready pour the mix into a jug with a handle – it will be easier to pour it on the pan later. Get an empty plate to put the ready pancakes into.
Put a non-sticking pan on the hot-plate (electric ring). Turn the dial to 5 (middle of a 10 position dial). Wait about 4 or 5 minutes for the pan to heat up.



Pour some of the mix onto the pan – put enough to cover the bottom but not too much because you do not want the pancake to become too think. Wait few minutes until the pancake starts to come off the pan. Then flip it and wait another few minutes. Watch this short video to see how to do it:


Download video

And these are the ready pancakes. You will get about 10 pancakes if you use the ingredients mentioned above.
Use some chocolate spread or strawberry jam or whatever you like – spread it on the pancake and then roll it. You can add some whipped cream if you want.

Bread recipe with Breadman TR875

This is a recipe for making bread with Breadman TR875.
Breadman TR875

Ingredients

  • Water – 275 ml, pre-heat it in a microwave for about 1 minute
  • Salt – 2 tsp (teaspoon)
  • Sugar – 1 tsp
  • Olive oil or sunflower oil – 2 tablespoons
  • Whole Wheat Flour – 1 cup
  • White Flour – 2 x 1 cup + 3 x 1/4 cup
  • Yeast – 1 teaspoon

Preparation

Make sure the bread pan and the kneading paddle are clean – wash it if necessary and then dry it. Pour the water into the pad, add the salt, sugar, oil and the flour. Do not mix it. Lastly add the yeast at the top. Put the baking pan back inside the bread machine and close the lid. Choose program 2 (FRENCH) by pressing the MENU button until it shows up on the display. Press the START button. The bread is ready in 3 and a half hours.

For more