Ming Chung Restaurant

Address:  67 Maude Road, Singapore 208348.

Since I began my half marathon’s practice with three other guys in my company, I was able to enjoy some good food for dinner at different locations, after the run. As the practice usually took place in the evening for an hour, by the time we started our dinner, it was usually around 10pm. The locations of our dinner were usually just nearby our office.

For this time, we went to a Heng Hua cuisine. If you are wondering what is Heng Hua. According to Google search, it tells me they are minority dialect from Putian, Fujian province in China. 

One of its signature dishes, the fried mee sua. It was well cooked and well tasted,  topped with peanuts and seaweed. They gave generous amount of ingredients, with some prawns, sliced meat, and green vegetable. For this cuisine, ingredients such as seaweed, clams, or other seafood are its main ingredients. 

Since seafood is their main ingredients, I am pretty sure, they know how to cook good dishes with seafood. We ordered the Fried Clams to share among us. Although the clams are small in size, they are fresh and well tasted. It is a good choice, delicious and worth to try.


Seven & Ate

Address: 78 Horne Rd, Singapore 209078.

Seven & Ate is a new cafe which replaced the Bao Makers, which is located near by the Lavender MRT station. Along this road, there are several cafes to hop if you around there for the whole day.

I visited the cafe along with three other colleagues on the Friday’s evening after work. It was the Chinese Valentine’s Day which is also known as Chap Goh Mei in Cantonese. On this eventful day, normally the Chinese single ladies will head to the river with the mandarin oranges to throw them into the river. It is said the right man who pick up the mandarin orange will find the lady and their relationship will blossom.

Unfortunately, in Singapore, I think if we were to throw the mandarin oranges into the Singapore River, the next thing we would get was a summon from the police officers, not a Mr. Right.

The waitress told us this was their new menu and plenty of the food from the menu are sold out. I was wondering how nice was it until some of them sold out. One of the food on the menu which remained same was the Pork and Oyster Burger.

I googled for this burger reviews as I tried it with having done my research. They say the burger comes with Honey Mustard Pork Patties, Fried Oysters, Onion Sour Cream and BBQ Sauce in between two buns. Well, the pork patties were really juicy and the fried oysters were crispy and fresh. The burger bun was soft but crispy from the outside. It came with the nacho chips served on the side.

Next, my colleague ordered the Spiced Blackened Chicken. It was nicely presented with garlic and sliced orange. Perhaps, it called blackened chicken, the chicken meat was grilled slightly darker but it was not too dry.

Next, I tried a small bite of the Duck Confit served with red wine sauce and red wine poached pear. It was soft and delicious, just that it looked quite small portion.

Lastly, it was the Hot Wings. I has about six wings with the chili paste spreaded across the wings. I did not try them, however, my colleagues said it was spicy.

Overall, the food is quite nice presentation, plenty of rooms for improvement if they want to change their menu again next time. The ambiance of the cafe is a little a bit noisy since it is a drinking place too. It is not spacious, probably cannot hold a big group of people. The cafe is decorated with old musical pictures and several instruments, so I am hoping to see a live band in the future with small groups of people enjoying the night.

Singapore Laksa

Address: Broadway Food Centre at the junction of Tyrwhitt Road and Horne Road, Singapore.

The Laksa smells good every time passed by this stall runs by an uncle alone. With some fish cakes, tau pok, cockles, quite fresh and clean, generous noodle and extra umphh with sambal, it looks spicy yet it is not. It is rich, filling, delicious and satisfied. If you are not very hungry for lunch, it is a good choice, otherwise, you can try his famous mee sua or handmade meatballs noodle which is great too. I will cover it next time. Stay tuned!


Chicken Rice

Address: Happy Hawkers, #01-273, 132 Jurong Gateway Rd, 600132, Singapore.

It is located just right behind the Food Clique and it is my second visit to this chicken rice stall after my accidental discovery that it sells chicken rice at cheapest price. It has roasted pork and barbecue pork as well. I guess usually people will order a combination of different dishes. It comes with a small bowl of soup as well.

I pretty enjoyed the chicken rice here and would like to visit again whenever I am in Jurong East. It is cheap, filling and tasted good, that is important.


Baja Fresh

Address: 9 Bras Basah Road, #01-03, Singapore 189559.

Baja Fresh Mexican Grill Rendezvous Gallery.

My cousin brought me to try the Mexican food which is located at the Rendezvous Hotel at Bras Basah Road. It is my second try for the Mexican food in Singapore, my first try was sometimes ago at the West side, after my marathon with my running kakis.

I ordered the combo set which comes with two taco of my choice. I chose to try the Baja Style with Baja rice and beans. The taco filled with salsa, onions and cilantro. You can choose between the original or crispy type for the wrap or both. With the combo set, you can add-on for a glass of soft drink.

Each order comes with a pack of nacho and free flow of the sauces and salsa from the counter. Both of the types of the salsa are nice.

I chose the crispy taco for a try and it turned out to be messy. I would recommend you to go for the normal or original wrap. The rice and the beans are good, cooked healthily and generous in portion. Overall taste is pleasing and interesting.

My cousin ordered the Baja Burrito. We were surprised when it was served. It was a fresh hand-made guacamole & pico de gallo wrapped in a warm flour tortilla with spicy chicken. It is nice, delicious and interesting taste of the green paste, the guacamole.

We wrapped our lunch with churros served with chocolate syrup. Sinfully dessert of the day but they are very satisfying dessert. We joked the churros are the Chinese’s yao tiao.

It gives me a chance to try eating healthily and also get to learn some Mexican words:
1. guacamole is an avocado-based dip, spread, or salad.
2. pico de gallo, also called salsa fresca, is made from chopped tomato, onion, cilantro, fresh serranos, salt, and lime juice.


Aqueen Hotel Lavender

Address: 139 Lavender Street, 338739, Singapore.

The hotel’s coffee house often do promotion for set lunch and this visit, it was a buy 4 free 1 offer. And, it has been a while we did not visit this restaurant for lunch. Their menu changed for this visit. They used to serve the coffee and tea, however, right now they serve soft drinks only.

The set lunch comes with a bowl of soup which we can self-service from the counter and a pudding dessert. They have improved their mushroom soup’s quality with additional mushrooms inside the soup. Last time, we always think it their mushroom soup is made directly from the canned soup. At least for now, it made some effort to make the soup better.

My main course for the day is the pan-fried salmon in teriyaki sauce with mashed potatoes and salad with Japanese dressing. It looked pretty well presented. The salmon itself is well-tasted, not over-cooked and if you want extra taste, teriyaki sauce goes well too.

By the way, today is Valentines’ day. Wishing everyone has a great evening on this special day!


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.