MyTechFinds : Software Development And Testing Portal

Deploy to Azure from Visual Studio

Thu, 23 Feb 2012 14:30:44 +0000

If you are working on Windows Azure Cloud Project, it makes a lot of sense to test code out in the real cloud. Visual Studio offers great help to enable you to "publish" or deploy a cloud project to your cloud environment right from Visual Studio.

Here is what you need to do –

Database Deployment through MSBuild and TFS build

Mon, 27 Dec 2010 23:35:11 +0000

I recently came across a problem where I had to deploy a database as part of the TFS (Team Foundation Server) build process. The default build process templates you get out of the box does not have a way to deploy database as part of a build process. There are 2 ways to do this depending on which build definition you use -

If you are using TFS 2010 build definition, add custom steps/actions in build process template to deploy database,
If you are using old MSBuild 2008 – TFSBuild.proj file, you can call external batch file or command(s) to deploy database.

Microsoft Test Manager 2010 - Tips and Tricks

Fri, 16 Jul 2010 11:57:38 +0000

Editing Manual tests in TFS 2010 from MS Excel 2010

Thu, 20 May 2010 14:52:08 +0000

Manual test cases created in Team Foundation Server 2010 can be easily edited from MS Excel. The TFS 2010 and Excel 2010 integration is native. I really liked this feature, though it comes with some shortfalls. Lets see what you can do and what you can not in more detail.

Manual test case authoring in Microsoft Test Manager 2010

Mon, 17 May 2010 20:15:28 +0000

Team Foundation Server 2010 along with Visual Studio 2010 and a new tool called Test Manager 2010 has done Manual Test case authoring and management really easy. There are no more .mht files to manage and no more test lists to be created for execution. Manual test case creation and management does not even need a test project to be created.

Test Planning in TFS 2010 Test Manager

Fri, 14 May 2010 22:59:15 +0000

There is a new and better way for planning and managing manual test passes/runs with TFS (Team Foundation Server) 2010. The first most important change is that, there is no more a need to maintain thousands of .mht files in test projects for manual tests like in version 2008. You also don’t have to maintain your manual tests in via Test list editor (.vsmdi). Now, all the manual test cases reside in TFS database and are maintained there. A manual test case is just like any other workitem. The Test Edition or Visual Studio 2010 Ultimate comes with a new tool called Microsoft Test Manager 2010. Lets see some of the basic test planning features.

TRX to HTML generator

Tue, 20 Apr 2010 18:48:39 +0000

Its been long that I wanted to document about this command line utility developed in C# to generate html report file from Visual Studio 2008 or 2010 report file (trx). It is compatible with TRX merger utility, which means it can consume the output file of the merger to produce html files for reporting.

LINQ to XML

Tue, 20 Apr 2010 01:31:35 +0000

After I built the TRX to html report generator, there was a little obvious need to have it centrally available so that team members can upload the results to a central place and manager(s) and PMs can view them. The requirement was a web-based report viewer. I could have built it using the same old tool with some web-pages to give links to the reports, but I also wanted to take out the tester's dependency to have the html generator tool. I turned to develop a simple web-app to do the job.

Sample of Pivot SQL

Tue, 06 Apr 2010 22:16:26 +0000

As a part of reporting, my friend faced a simple looking problem. He was struggling for almost half a day to solve this by a SQL query. When he showed me the problem, I just realized that it is something that we usually do in excel called pivot tables and I asked him to look over the internet if there is something called "pivot query" and to our surprise there is something called as that...we just didn't know, so I am going to document it.

Some useful Xpath expressions

Thu, 28 Jan 2010 19:43:53 +0000

Here are some useful Xpath expression which were a little hard to figure out for a newbie like me so I am making an attempt to document them. Here are 2 of them,

Get unique values using xpath
Get leaf node only using xpath