Wednesday, December 31, 2014

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.


Monday, December 29, 2014

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.

Sunday, December 28, 2014

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.

Saturday, December 27, 2014

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.

Thursday, December 25, 2014

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”.


Monday, December 22, 2014

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.

Sunday, December 21, 2014

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

Sunday, December 14, 2014

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:

Sunday, November 30, 2014

cannot delete folder. delete folder using cmd. Error: The action can't be completed because the folder or a file in it is open in another program.

If you also encounter the stated error when you try to delete a folder, you can try to delete it using the cmd. I get the source from here.

Me error command look like this.


type " rmdir /s " follow by the direcctory name, if you are lazy to type it out ( or whatever reasons, i.e. name too long, use the tab key to help you. If your folder name contain space, do use "" to cover it up. e.g " rmdir /S "Assignment 1 ".
navigate to your directory, by using cd, then

Note: make sure you use the capital S..

to move a folder,type " move oldDirectory newDirectory".

Cheers!

Saturday, November 22, 2014

Binding List to GridView

I encounter this error when I try to write a simple gridView. If you face the same issue, hope this help you. I found the solution here . The one that I underlined is where I missed out. :)

The data source for GridView with id 'GridView1' did not have any properties or attributes from which to generate columns. Ensure that your data source has content.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace WebApplication2
{
public class Item
{
        public int Id {get; set;}

        public string Name { get; set; }
}
public partial class WebForm1 : System.Web.UI.Page
{
       protected void Page_Load(object sender, EventArgs e)

   {
        List<Item> ar = new List<Item>{};

        Item item = new Item(){Id = 1 , Name = "User1"};
        ar.Add(item);
        item.Id = 2;
        item.Name= "User2";

        ar.Add(item);

        GridView1.DataSource = ar;
        GridView1.DataBind(); 

   }
}


}

wondering why you now see 2 User2 in the gridView? Then, you have to take a look on how to fill in the list .

Filled in List - From Class

Be very careful when you filling up the List. The output and how it behave.
I made a mistake that I hope will not made it again.
The part in purple colour is the outcome of the code when the debugger stop at that specific line of code.

List<Item> ar = new List<Item>{};
ar is empty. If you now access ar[0]Id, you will hit error.
           
ar.Add(new Item() { Id = 1, Name = "User1" });
If you now access: ar[0].Id = 1
           
ar.Add(new Item() { Id = 2, Name = "User2" });
If you now access: ar[0].Id = 1, ar[1].Id = 2

 
Item item = new Item(){Id = 3 , Name = "User3"};
ar.Add(item);
If you now access: ar[0].Id = 1, ar[1].Id = 2, ar[2].Id = 3

item.Id = 4;
item.Name = "User4";
ar.Add(item); 
If you now access: ar[0].Id = 1, ar[1].Id = 2, ar[2].Id = 4, ar[3].Id = 4

Wednesday, April 16, 2014

Why is time boxing so important?

Why is time box important in SCRUM?
-        If we don’t have an idea on how many time some ceremonies/activities will be taken, it is hard for the participant to plan their next activities.
-        Some people will talk/discuss endlessly while others will lose interest. When more people get bored, they become less motivated.
-        Time box is a way of managing the time as well as a motivation to keep moving because you know the next event is coming soon or this event is going to end soon and therefore will get more serious and paying extra attention just to try to gain more benefit out from this time.
-        Time box is like mapping the objective to a time frame. Not all the time related to productivity but sometimes is about how you can spend it with more meaning values.

Tuesday, February 4, 2014

what should I do as a new SCRUM master?

I once ask myself this question and search in the internet. I cannot find a list. After being a SCRUM Master, I understand that there is no list of criteria or check list to check. I list a few things that I think what a Scrum master should have or could have or good to have, based on my own experience and observation.

1. Open minded.
- take comments, observe yourself. I often make jokes to my team members saying that I or they should have a retro for themselves. Then I mention a few points, in a funny ways. For example, via the work, I found that I did not escalate certain issues on time, I will make a joke sounds like this: "I will make a retro to myself, the first point will be "must highlight person A to person B as soon as this problem is reveal. " Now, everybody will make a smile and of course, you can also point person A, saying, "so, next time please alert me ASAP when you hit impediments so that I can escalate you faster. That will be my 'what to improve' 's point. Now, you shown that you learn from mistake, also remind others to raise impediment earlier.

2. Sensitive and understanding.
- have to accept and understand that your team members and yourself are human. Just like Christina Perry's song, we are only human, and I bleed when I fall down. Be sensitive to other people's feeling. Doesn't means you have to put others at first place, but to be more considerate. Consider everyboy's feeling, when you create a happy team, everybody is working happily and productivity will increase by itself.