« Previous Entries

Changing Max File Size for Attachments in Team Foundation Server

Monday, November 21st, 2016

At the office, we needed to add some larger attachments to our workitems in Team Foundation Server. It’s pretty simple to change the maximum file size allowed. According to MSDN: You’ll need to be a member of the TFS Administrators group. Login to the Team Foundation Server Open the following URL: http://localhost:8080/tfs/DefaultCollection/WorkItemTracking/v1.0/ConfigurationSettingsService.asmx?op=SetMaxAttachmentSize Note: Replace “DefaultCollection” […]

Microsoft TFS 2015 Update 2 – Release Management – TF50309 – Insufficient Privileges

Tuesday, July 26th, 2016

We have recently upgraded to Microsoft Team Foundation Server 2015 Update 2, which includes the new Release Management feature. In testing this new feature, we encountered the following error: TF50309: The following account does not have sufficient permissions to complete the operation:[*****]\Project Collection Service Accounts. The following permission is needed to perform this operation:View Project-level […]

Dynamically Selecting a Value in a C# DropdownList Control

Thursday, October 10th, 2013

In a recent internal C# web project, I needed to accept a URL parameter and use that value to select an item value, if it exists, within a DropDownList control. I have provided the code, along with some commentary, to use as a refresher for myself and a base for others. This code was implemented […]

AxoSoft OnTime – Metrics – Defects by Severity

Thursday, July 18th, 2013

I have recently been introduced to a new tool, Axosoft’s OnTime. For what it is, it works well as an Agile project management tool, complte with defect and incident tracking. From a quality assurance perspective, it’s nice to have flexibility of workflow management, custome fields and such. What I have found a bit lacking, however, is consistent metrics. I’m prone to create my own metrics reporting, so I have a tendency of querying databases directly.

In OnTime, the data structure is fairly straightforward. However, our organizational structure within the tool’s concepts of Releases and Projects is hierarchal in nature and makes my queries a tad more complex.

Upgrading Concrete5 to using SimpleScripts

Wednesday, September 26th, 2012

I currently run several Concrete5 web sites from my host, Typically, I use the SimpleScripts tool to do the typical upgrade maintenance for all of my apps. It’s simple, easy to use, and rarely causes concern. However, this upgrade was a little different. I clicked the upgrade icon and away it went. upon review […]

Fixing Magento Connect on Magento v1.7

Monday, September 10th, 2012

I recently upgraded a Magento store from v1.4 to v1.7. In doing so, the administration link to Magento Connect started throwing a weird error. Once I logged in, it brought me to a page that looked like this: Mac OS X  2??ATTR??X?;4fabe10e;Google\x20Chrome;D30B167B-7520-4A4B-BB90-173681AAF80E| OS X  2??ATTR??X?;4fabe10e;Google\x20Chrome;D30B167B-7520-4A4B-BB90-173681AAF80E| OS X  2??ATTR??X?;4fabe10e;Google\x20Chrome;D30B167B-7520-4A4B-BB90-173681AAF80E| OS X  2??ATTR??X?;4fabe10e;Google\x20Chrome;D30B167B-7520-4A4B-BB90-173681AAF80E| […]

HP ALM – Determining when a Test Case Instance is added to a Test Set

Thursday, August 23rd, 2012

As mentioned in a previous post, my team has been attempting to generate reporting metrics directly out of the ALM database. One of the issues we were running into was determining when a Test Case Instance (TESTCYCL) has been added to a Test Set (CYCLE). There were many queries put together and tables examined and […]

HP ALM Database metrics

Tuesday, August 14th, 2012

The past week has seen me and my team attempting to create several SQL Queries to pull specific information out of our HP ALM Project databases. Basically, we are looking to pull test case execution and status updates per day and report on our local Confluence installation. The TESTCYCL table stores data pertaining to each […]

Converting SQL DateTime to a Simple Date

Friday, April 29th, 2011

Just to remind myself at a later date, this is a SQL Query that shows how to strip the timestamp from a datetime value. Declare @fulldate datetime Set @fulldate = getdate() Declare @shortdate smalldatetime Set @shortdate = convert(datetime,convert(char(10),getdate(),101)) Select @fulldate, @shortdate

Using Recaptcha in the C# CreateUserWizard

Saturday, April 16th, 2011

I have been playing around with a new .NET website for a while now. One of the great features of .NET is the concept of the CreateUserWizard. It helps take some of the tedium out of user registration and membership. However, out of the box, it is very basic. In my solution, I wanted to […]

« Previous Entries