ASKCTS Blogs
PowerPivot for SharePoint
By Tim Rooks
PowerPivot is the self-checkout aisle of business intelligence.
Install the free PowerPivot add-in for Excel 2010 and you can import, tabulate, summarize, and otherwise slice and dice … more
Mobile Application Testing
By: Matthew Seese
Twelve years ago, the world was catching it's breath after the fears of a "Y2K freak-out" subsided. A lot of people were focused on the older machines that ran the world and what … more
Informatica Developer Client File Source
By: Kaiesha Ford
In Informatica Developer client, there are two ways to read a file in a data object: direct and indirect. 1) Direct is used for loading one single file. 2) Indirect is used for … more
Document Monitoring in SharePoint 2010
By: Simon Williams
SharePoint document libraries can be used to contain related folders and documents. Recently, I was gathering information from an Access database stored in a SharePoint project … more
Code Metrics in Visual Studio
As software developers, we all know that it is imperative to review quality during all phases of the software development lifecycle. Defects, inefficiencies, and unmaintainable code can turn a simple … more
Changing Web Pages Using Google Chrome
By: Umair Kamal
Ever wonder how you can look at the source of a web page (no I am not talking about IE’s View Source!) and change the source on the fly? How many times have you … more
Sounds Risky!
Sounds Risky
We've heard it. We've thought it. We've even said it. It happens most often when we are starting or joining a project. It is a balance of concern and excitement. It is rare that we … more
Tips and Tricks with Microsoft Test Manager
Microsoft Test Manager is a powerful test management application that integrates with Visual Studio to allow for manual and automated testing. For those interested in learning more about this … more
When Nothing is Something by William King
I thought Nothing was the null of VB.NET. But did you know that in VB.NET, the Nothing object can actually be equal to String.Empty?
I was looking at code that was supposed to set an object property … more
Retrieving MAX or MIN from MOSS Lists in SSRS
I recently needed to retrieve the most recent date from a MOSS List using SSRS. SSRS has its own MOSS List connection type that uses XML to query the data, rather than SQL.
The XML query does not … more
QC Tips - Creating a custom filter
We all have our favorite filters in QC, be it just all the defects assigned to us or all fixed defects. To make us all a little more productive here are some ways to sort and save those filters.
To … more
Reflection and AmbiguousMatchException
A few days ago, I ran into this exception and, having never experienced it before, I though I would share my findings, hopefully to save someone else a little time.
I was developing against a … more
SSAS Dimensions and Measures
An OLAP Cube is composed of two different types of attributes: Dimensions and Measures. A Measure is just that – a measure of something. It can be anything numeric: hours worked, injuries … more
Creating custom columns in QC
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 … more
Adding Photos into Active Directory for use in Exchange and Outlook 2010
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, … more
SQL Server 2005 SP3
We ran into a significant problem with SQL Server 2005 SP3 during an engagement. Apparently, if you upgrade to SP3, then SSIS in Excel can no longer import Excel spreadsheets with spaces in the tab … more
Visual Studio - Default Browser Switcher
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 … more
Pulling Test Cases from Test Manager
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 … more
Cognos Reporting Gotchas
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 … more
SSIS Package: Moving XML source from inline schema to external definition
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 … more
