Warm start-up and Cold start-up

Warm start up
-time taken to start application that launched in the recent past (no reboot in between)
(just like the time taken to do something after woke up from long sleep)

Cold start up
-the time taken to start application after machine reboot, i.e. the first launch after reboot.
-depends on the number of pager need to be fetched from disk.
(just like the time taken to do something after reborn)

what is JIT( just in time ) ?

If you are doing some reading regarding to the compilation of codes, you will of cause or should come across this word, "JIT".


As mentioned by itself, just in time compilation happen just at the time when it is needed.
I did some searching and finally landed on a MSDN article to understand more about JIT.

Why JIT is 'born'?
- to improve the first access performance.
When the loader only load and compile during runtime for the needed assemblies, it allows the application to start up quicker compare to those application that is use interpreter or native compiler. But is it always improve for both cold and warm start up? Read further on the blog to get more insight.

How does JIT works?
- use late binding to load only when it is needed.

Publish SSRS report

1. You can publish the SSRS report to a server to allow you to view the report in the server and not the visual studio management windows.
2. Click on the properties of the project.

3. Fill in the target server url , click ok.

4. Build the project. Then click Deploy.

How to create SSRS Report.

Add total count for SSRS report.

1. This is how you can add total count for the SSRS report. For my table, I don’t have a count field. Also since I am new to SSRS, I put some creative by playing with the columns just to get the total do able and to experience how can we use the totalize functionality. I found that we can only use the ‘add total’ on certain field / column. Let’s put that into another discussion, I will first create an aggregate column to make it works.

2. I added a calculated field with name ‘count’. Click on the ‘fx’ and fill in the value ‘1’.

3. Drag and drop the count column to the table. Right click on the count and select ‘Add total’.

4. You can check your report in the preview. In this sample, the way this report is being display doesn’t make sense. So, I move the sum to another column, remove all the other columns except the employeeId.

5. Add grand total.

6. You will now have subtotal per employee, and a total of all training request for all employee.

How to create SSRS Report.

Add filter on SSRS report

1. Add parameters.

2. I have the following properties.

3. Right click and select properties.

4. Select the filter tab, then, add. Key in the filter that you will like to have. You can make use of the drop down list or you can set your own expression.

5. In the value column.. click on fx

6. Then click ok.

7. View at the preview.

8. Test it. Uncheck the null check box, key in ‘1’ and click view report.

9. Done.


How to create SSRS Report.

Error in the query designer

The system cannot find the file specified

----------------------------

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

                               

Reason: Query string’s error. Is either the user id and password incorrect or the connection string is not correct.

I changed to use this connection string instead of the one suggested in the Microsoft tutorial. I used this : Server=MSSQL2008;database=Training;

Then, I am able to see this:

How to create SSRS Report.

Prompt to key in credential upon preview data

The key thing is way you set up during data source.

How to create SSRS Report.

How to create SSRS project in Visual Studio

1. Create new SSRS project.

2. Right click on report to add new item.

3. Select the report project template and click Add.

How to record coded UI

1. Create coded UI project.

2. Let’s select the option “Record actions, edit UI map or add assertions”, and click “Ok”.

How to create automated testing tool

As usual, I always cited my reference. :) As an appreciation of others' hardwork.

With the previous post about create test project and  record coded UI, I found that it is hassle to create. Also, transferring or sharing the testing methods among testers is not convenient. If you faced the same issue, maybe it is time to look for , or build testing tool on your own.

A very super duper simple testing tool can look like this.

The concept is basically:

First, load the application,
Second, browser for the test data ( saved in some file format, able to share and reuse in any machine)
Third, look at the screen for the test result, i.e. test passed or failed.

Read more if you want to know how to load from excel and loop each of them.

How to create a test project in visual studio 2013

1. Right click on the solution. Add new project.

2. Make good use of the search function! Look for “test”. You can now select the test project type that you want to work on. 

3.Done. :)

How to install ssdt

When I want to start create a SSRS report, I found that Business inteligent template is missing in my visual studio new project's selection.
After some searching, i do found that the reason is because I haven't install the ssdt. Here is how I install it.

First download the ssdt from the msdn offical website via this link ==> http://msdn.microsoft.com/en-us/library/jj856966.aspx

After that: