CTS – Your Technology Partner

Creating custom columns in Quality Center

Written by Craig Butler on December 6, 2012

Sometimes the default fields in QC just don’t cut it. How many times have you been dealing with QC and wished you could filter by a particular something? Turns out, you can! You can set up a custom column and now you can filter even better than before. Only catch is that you must have…

Continue Reading


Adding Photos into Active Directory for use in Exchange and Outlook 2010

Written by Craig Butler on December 6, 2012

If you are e-mailing an internal network user, Outlook can be set to display their photo in the Outlook Social Connector window. To accomplish this, import the user photo into Active Directory, which has a built in LDAP attribute called thumbnailPhoto. This can be used to store thumbnail photos that are less than 10kb in…

Continue Reading


Visual Studio – Default Browser Switcher

Written by Craig Butler on December 6, 2012

There is a great Visual Studio extension that allows you to set the default system browser. You can find the plugin information here. This comes from http://www.wovs.com/ a site for Visual Studio plugins by Clarius Consulting. I have used the Clarius T4 editorfor several years and love it too. To install in Visual Studio 2010,…

Continue Reading


How to pull test cases from Test Manager 2010

Written by Craig Butler on December 6, 2012

Ever had a client or project manager ask for test cases from Test Manager? I have spent hours looking, for a way to do just that. There is a solution! The cure to this ailment starts by clicking here and downloading the Test Scribe for Test Manager (Test Professional 2010). Once Test Scribe finishes installing and…

Continue Reading


Cognos Reporting Gotchas

Written by Craig Butler on December 6, 2012

If you are familiar with Reporting Services, or the Visual Studio IDE, then you can discover a lot of the functionality of Cognos Reporting simply by pulling up samples in the IDE, and exploring properties of the objects on the screen to see what you are allowed to change. However, a lot of things are…

Continue Reading


SSIS Package: Moving XML source from inline schema to external definition

Written by Craig Butler on December 6, 2012

Microsoft’s SQL Server Integration Services (SSIS) is an extremely useful tool for extracting, transforming and loading data from one data source to another. SSIS can support many different data sources: database, Excel, XML, etc. XML in particular is a very popular methods for transmitting data between organizations that may have different database architectures. I was…

Continue Reading


SharePoint Cleanup – Easy Garbage Collection

Written by Craig Butler on December 6, 2012

This one might seem obvious, but “you should always keep your code clean, and your memory cleaner”. In SharePoint, we sometimes work with objects from the Object Model which were developed by Microsoft, and we have no idea what kind of overhead that they entail. SPSite and SPWeb are two such objects. When you really…

Continue Reading


SharePoint 2013

Written by Craig Butler on December 6, 2012

On Monday July 16, Microsoft released a public preview of SharePoint 2013. Our team created a Virtual Machine and installed the newest version of SharePoint to experiment with the new and updated features included in the product. These exciting features will allow CTS to offer a wider and more expansive solution to our customers. In…

Continue Reading


Parameter Sniffing using SQL Server 2008 R2

Written by Craig Butler on December 5, 2012

Parmeter Sniffing There was an interesting error that I had experienced recently while executing a stored procedure in SQL Server. I kept getting incorrect results when running the stored procedure, even though the statements in my stored procedure were correct. The set of results I got when running the stored procedure with parameters passed to…

Continue Reading


Using the Web API to Retrieve JSON or XML Via JQuery

Written by Craig Butler on December 3, 2012

The newest version of Asp.net MVC (version 4) supports a new set of functionality called “Web APIs.”  Web APIs are controllers similar in many ways to MVC 3 controllers that return JSON.  However the API controller methods extend them to better handle HTTP requests including support for HTTP action verbs such as GET, POST, and…

Continue Reading