Microsoft Releases Visual Studio 2011 Beta and Windows 8 Consumer Preview

Double the fun for developers and consumers today, as Microsoft launched the consumer preview of their new tablet-friendly Windows 8 OS, alongside the first beta of Visual Studio 2011, which will provide all the necessary tools for developers to get to grips with Win 8’s new “Metro” styling.

Continue reading “Microsoft Releases Visual Studio 2011 Beta and Windows 8 Consumer Preview” »

SQL Server Job Agent fails SSIS package with error: Option “/CALLERINFO” is not valid

I was editing some pre-existing SQL Server Agent jobs the other day, adding some interconnectivity and changing steps around as I’ve done hundreds of times before.  These job steps are used to execute SSIS packages (SQL Server Integration Services) on the server and have been running for months (years?) without fail.  However, after I made my changes they started failing on the steps I had edited, throwing the bizarre error:

Option “/CALLERINFO” is not valid.  The command line parameters are invalid.

Continue reading “SQL Server Job Agent fails SSIS package with error: Option “/CALLERINFO” is not valid” »

Reverse the order of words in a string in SQL Server

I recently found myself with a situation in SQL Server where I had a string consisting of a series of values (constructed using the CLR function for concatenating values that I wrote about last week) that I needed to reverse.  Unfortunately, it’s not as simple as using SQL Server’s built-in REVERSE function.  That actually reverses each individual character in a string, rather than switching the order of words. Continue reading “Reverse the order of words in a string in SQL Server” »

Now I've added my sub report control to both of the 2 tables

How To Create Multi-Column Lists in SQL Server Reporting Services (SSRS)

I recently encountered a scenario where I wanted to display my report content in the form of a multi-column list.  In essence, I was looking to create the SQL Server Reporting Services (SSRS) equivalent of an ASP.NET Repeater, to render my report content both horizontally and vertically (in this case a dynamically repeated SubReport) a number of times dictated by my source dataset.  I spent a little bit of time investigating some more complicated possibilities such as building a matrix of row and column groupings when the solution finally hit me.  It is simply brilliant in its simplicity.  Here’s how to do it. Continue reading “How To Create Multi-Column Lists in SQL Server Reporting Services (SSRS)” »