Dev Notes

RallyDev vs Visual Studio TFS

April 1, 2015 by kriztine

I have tried out some Project Management tools like Asana, Trello, VersionOne, RallyDev and watched the demos of others, but I would like to trim down to two – RallyDev and Visual Studio Team Foundation Service (TFS).

Why just the two? Because based on the requirements of the organization, only RallyDev and TFS fit the bill.

RallyDev is the most popular when it comes to Agile Project Management. Its Community Edition is free for up to 10 users and 5 projects. I have already signed up and been exploring the demo. And I like what I am seeing. I can create User Stories, Backlogs, set Estimations, track iteration/team/product status, facilitate test cases and lot more.

Visual Studio’s TFS can also do Agile project management. I have experience with TFS for version-control, task management and test plans creation. Plus, TFS is already integrated with Visual Studio.

We can use TFS for the time being. If for some reason, we would need to look for another PM tool, then we could try RallyDev.

A Quick Look on some of the Project Management / Collaboration Tools

March 24, 2015 by kriztine

Asana is next to Basecamp, but many users say that they prefer Asana more because of its simplicity. Aside from that, Asana is free for 15 members for unlimited projects. I have created an account and already trying it out. Personally, I can say that Asana specializes in task management. Yes, it is very simple and intuitive but lacks on many aspects.

RallyDev is the most popular when it comes to Agile Project Management. I have already signed up and been exploring the demo. Its Community Edition is free for up to 10 users and 5 projects. What I like about Rally is it has many features. It is really Agile. You can create User Stories, Backlogs, set Estimations, track iteration/team/product status, facilitate test cases and lot more. The learning curve might be steep, though. I am still trying to figure out how the Product Owner can create User Stories.

The Visual Studio’s TFS can also do Agile management. But, I am not sure if this is restricted only to the team (within the company) or if we can give access to the users (and if it is advisable). I have to dig deeper about that yet.

There is Trello, Insightly, Flow, Jira, VersionOne etc but I think it all boils down to what the team really needs. And since, we are starting up, maybe we can utilize the free one(s).

As for UX tool, I am hearing about Balsamiq a lot. There is no free version, though. Just trial versions. I might look at InVision. It looks promising.

Delete Rows with Duplicate Values in a Particular Column

March 4, 2015 by kriztine

WITH CTE AS(
SELECT referenceNo, RN = ROW_NUMBER()OVER(PARTITION BY referenceNo ORDER BY referenceno )
FROM dbo.[Order]
)
DELETE FROM CTE WHERE RN &gt; 1

[Solved] “Load report failed… Unsupported Operation. A document processed by the JRC engine cannot be opened in the C++ stack”

February 17, 2015 by kriztine

I was ready to bang my head on my keyboard because. I couldn’t seem to find the solution for the error I was receiving when loading Crystal Reports from my deployed Windows application.

Then, I got an idea when I read from this article that this could be the culprit –

The report location specified in the ‘Load ()’ method is invalid or report does not exist at that location.

So, I copied the rpt files to the Program Files path and voila – I got the reports loading.

Released: Sales and Loan Management System

February 2, 2015 by kriztine

SLMS Features:

User Accounts Management
- User Types – their access and restrictions
- with Password Encryption
Customer Management
Collection Management
- Collectors and their Designated Areas
Items and Services Management
- Items Released Report
- Services Rendered
Loan Management
- Apply for New Loan
- Refinance Loan
- Replace Items
- View Statement of Account
- Loans Query
- Loan Report(s)
Sales Management
- Cashiering
- Sales Report
- Void Sale(s)
Audit Trail
Backup and Restore Data

Technologies Used:

C#, Net Framework 4.5
Windows Forms
SQL Server 2012
Entity Framework 6
Crystal Reports

How To: Forward / Redirect Naked Domain Purchased from Enom to www

April 24, 2013 by kriztine

In this post, we talked about forwarding a naked domain bought from GoDaddy. What about if your registrar is eNom?

In this case, you can configure your naked domain to be forwarded to your mapped CNAME (subdomain) through the following steps:

1. Login to your Google Apps Control Panel at //www.google.com/a/yoursite.com. Let’s look at kurizutin.com as a sample.

2. Select Domain Settings > Domain Names > Advanced DNS
3. Get the provided username and password for your eNom DNS control panel.

4. Under the Host Records section, click Edit

5. Delete any existing A records
6. Add a new Host Record with the following configuration (see sample image below):
7. Host Name: @
8. Address: //www.yoursite.com
9. Record Type: URL Redirect
10. Save your changes