Tai Sun Eating House

Tai Sun Eating House, French Rd, Singapore.

The food court which is located next to the Lavender’s Fair Price offers good choices of food. The fish head noodle and the ban mien are those which I have tried so far and they are recommended. Usually during the lunch time, these two stalls have quite long queue.

Sometimes back in mid November, I have been trying to de-stress by enjoying food and it seemed something have been bothering me a lot. I am slight losing some fate.

Back to the food, I walked to the food court from my office which is quite distance to have the ban mien for my lunch. I prefer to order the dry type with chili paste as this mixture is quite balanced and goes well with the handmade noodle, fried onions, fried anchovies and sliced of mushroom. If you do not like to take spicy food, you can go without chili paste.

SQL Server Export Data into Excel

How to export data from the SQL Server Management Studio into Excel file?

I used to save the data into .csv file and transfer the file out into my local machine via FTP or use the copy and paste command to transfer the data into the Excel directly from the database. This happened when you have control on the servers and security is not a big concern. Another method is using the SSIS.

Due to various reasons, my client did not allow installation of Excel into the database server and recommended me to use the Export Data function in the SSMS. I seldom used the Export Data function, anyway. Instantly, I gave a try after I was guided.

The steps are simple, guided and straight forward to follow. Here is the step:-
1. Right click the database > Task > Export Data.

2. Choose a data source. It means where the source location is. For this example, we select SQL Server Native Client 11.0. Enter the user credentials if you are using SQL authentication, otherwise, you can just continue with Windows Authentication.

Select the database which you want to export the data from.

3. Choose a destination. It means select the location where you want to save or export the data to. Destination selection, we choose Microsoft Excel, then enter the Excel file path where you want to save the file at. As for the Excel version, I believe it is based on the driver version we installed. If you want to keep the first row with column names, please check the checkbox.

Then, we can proceed with Next button.

4. Specify table copy or query. Here, we can choose either to select which table or tables we want to copy all its data into the Excel or we can write a SQL query to specify the dataset to be copied or exported. Let see how we can export a table out from the SSMS.

Choose the first option, Copy data from one or more tables or views. This allows copying the entire dataset from the selected tables or views into the Excel file. Select the tables by checking the checkbox at the Source.

The destination will name the Excel sheet according to the table’s name. If you want to change the name, you can click on each destination table’s name and edit it. If you do not want to export the entire table, you can select to write a query by choosing the second option from the previous screen.

Write your SQL statement in the next screen, just like below, which I selected top 1000 rows of records from the selected table. You can rename the table name at the Destination similarly to what I describe earlier in the next screen.

The table name will appear in the Excel sheet. One sheet for one table and as you know Excel has maximum number of rows, 65,536 for Excel 2003 and 1,048,576 for Excel 2007. I believe there is no concern about maximum column.

Next, we move to the Edit Mappings… button which is important to look into it especially when we want to format the Excel’s cell format.

In the Edit Mappings, you can select the data type of each field by clicking the dropdown selection list under the Type column. And, click OK to save the mappings. Then, you can view the dataset by clicking on the Preview button. A limited row of data will display in the next screen.

After editing the mappings and preview the dataset, it is time to review the data type mapping

5. Review Data Type Mapping. Click Next button to proceed and run the package.

6. Run Package. Nothing much you can choose, either run immediately or cancel the process. Click Next or Finish button to complete the wizard, it will run the package and save data into the Excel file.

Lastly, navigate to your Excel file path to retrieve the Excel file and check the data inside it.

Sweet Potato From Don Don Donki

Don Don Donki, Singapore. The Japanese store which just opened and was said to be very long queue. Japanese sweet potato, hot popping served in a paper bag. You know what… I’m the last person buying this sweet potato before their next batch which may take some time to prepare. Thank you for the sweet and lovely dessert of the day.

Address: Orchard Central, B1 & B2, 181 Orchard Road, Singapore, 238896.

Air-Fryer Salmon

I wanted to cook salmon for dinner, so I went to buy a fresh and good piece of salmon from the supermarket in the morning. With just salt and pepper and some mixed herbs, I put it into the air fryer and set the temperature at 200°c for 12 minutes. It worked the wonder for you.

My verdict for this piece of salmon is…
It was crispy on the top, juicy on the bottom, it was not overly marinated, can taste the lovely fresh salmon.

Zenso

The recommended appetizer, the shrimp cakes come in 3 pieces, which we cut them into smaller pieces for everyone to enjoy. Served hot, smell good and go great with the sauce. 

It is a recommendation from the waiter who served us. It is well marinated with some familiar ingredients which my aunt used to use in cooking. Truly a home cooked style, simple and good for a try although it is not a fantastically great for second time.

After the long wait for the fried basil chicken rice, it was served with a beautiful sunrise fried egg on top of the white rice. The basil chicken is not spicy, tasted normal and can still be improved.

Address: 91 Bencoolen Street Sunshine Plaza, Singapore 189652.

Sumire Yakitori House

Sumire Yakitori House
Address: 80 Middle Rd, #01-88/89, 188966 Singapore.

I visited this Japanese restaurant earlier this month, hours before my half marathon with my cousin and my aunt. I asked my friend for a suggestion of Japanese restaurants in town with reasonable price. She told me to go Sumire Yakitori House, which she brought me here last year after my NUS’ event.

We chose from the set lunch menu. We added ala-carte flame-seared salmon sushi rolls and hot green tea.

Salmon Nishoku Chirashi Gozen
It consists of sushi rice bowl with sushi sashimi, flame-seared salmon, salad with shredded chicken, chawanmushi and miso soup.

The set lunch serving is generous and filling. The salmon is fresh. The chawanmushi, miso soup and salad are the common Japanese side dishes.

Peanuts Porridge

Yesterday, my friend told me that she was cooking porridge for her dinner. She said it was a simple plain porridge and ate with fried vegetable. It gave me an idea to cook porridge for this weekend.

I prepared and washed one cup of the white rice, then marinated the rice with a pinch of salt. Meanwhile, I washed the peanuts and ready to put it into the rice cooker to cook. With the multi-functional rice cooker, it is very easy to cook porridge by adding 8 cups of water. I measured it and with 8 cups of water, it can make a thick porridge of my liking. It cooked for about an hour, the porridge was ready. The thick porridge serves as the base for me to prepare the porridge with other ingredients.

I added some carrots, mushroom, fish balls and an egg in the porridge and continue to cook for a while until the additional ingredients are cooked. It is smooth and favourable. Just add a pinch of pepper and few drops of sesame oil.