ASKCTS Blogs

  • PowerPivot for SharePoint

    Tags: PowerPivot, sharepoint, bi

    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

    Tags: qa, mobileapp

    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

    Tags: sharepoint, dev

    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

  • Sounds Risky!

    Tags: qa

    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

    Tags: qa

    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

    Tags: C#, VB.NET, dev

    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

    Tags: dev, sql

    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

    Tags: qa, qc

    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

    Tags: dev, visualstudio

    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

    Tags: dev, sql

    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

    Tags: qa

    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

  • SQL Server 2005 SP3

    Tags: sql, dev

    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

    Tags: visualstudio, dev

    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

    Tags: qa

    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

    Tags: dev

    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