The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,861 other subscribers

Archive for 2012

Research List: CruiseControl.net (ccnet) links

Posted by jpluimers on 2012/10/18

I’ve been working with some continuous integration setups using CruiseControl.net for a suite of Visual Studio 2010 projects stored on Team Foundation Server 2010.

A few links from my research list:

–jeroen

Posted in .NET, C#, Continuous Integration, CruiseControl.net, Development, Software Development, Source Code Management, TFS (Team Foundation System) | Leave a Comment »

Word Clouds and algorithms to generate them

Posted by jpluimers on 2012/10/17

While preparing for the Category Cloud series of posts, I found a lot of helpful links.

Here they are:

–jeroen

Posted in .NET, ASP.NET, C#, Development, HTML, Software Development, Web Development | Leave a Comment »

Research links: unit testing using SQL Server

Posted by jpluimers on 2012/10/16

Being used to do Unit Testing in most of my regular code, I want to do the same for SQL Server code.

Target is SQL Server 2000 and up (since I’m involved in a big migration project getting a lot of SQL Server 2000 data and code to be upgraded to SQL Server 2012 or SQL Server 2008 R2).

Here are a few links that are on my research list:

–jeroen

Posted in Database Development, Development, Software Development, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Leave a Comment »

How To Backup Bootable USB Drive

Posted by jpluimers on 2012/10/15

I needed to make backups of a couple of maintenance USB drives.

It turned out to be pretty easy: How To Backup Bootable USB Drive describes how to do that based on a small USB Image Tool developed in .NET.

One of the things you can do with this is backup bootable Windows installation media.

Note it is a simple tool, so it backups only same size to same size. For more advanced copy purposes, use something like the professional tools from Acronis.

–jeroen

Posted in .NET, Development, Hardware Interfacing, Power User, Software Development, USB, Windows, Windows 7, Windows 8, Windows Server 2000, Windows Server 2003, Windows Server 2003 R2, Windows Server 2008, Windows Server 2008 R2, Windows Vista, Windows XP | Leave a Comment »

LUSRMGR von Remote aufrufen – Windows – Administrator

Posted by jpluimers on 2012/10/12

psexec to the rescue again:

psexec \\%rsys% -u DOMAIN\%user% mmc.exe lusrmgr.msc

note: both the current and remote computer must be trusting the AD belonging to DOMAIN, otherwise you will get an access denied message.

–jeroen

via: LUSRMGR von Remote aufrufen – Windows – Administrator.

Posted in Power User, Windows, Windows 7, Windows Server 2003 | Leave a Comment »

ROT13 – text obfuscation – T-SQL versions of the algorithm

Posted by jpluimers on 2012/10/11

Never call this encryption, as ROT13 is just a kind of obfuscation for text and can be easily revealed (like the reveal button in good old Teletext).

A few T-SQL versions of this algorithm, both working for SQL Server 2000 and up:

–jeroen

Posted in Database Development, Development, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Leave a Comment »

Going through a HTTP Proxy to your TFS server using the command-line tools

Posted by jpluimers on 2012/10/10

A while ago, I wrote on Connecting Visual Studio 2010 to TFS over a Corporate Proxy and all the trouble that took.

This time, I’m going further, and use the commandline tools.

TFS Top Tip #12 – Specifying a proxy server at the command line – Martin Woodward.

If you have setup the Proxy in the Team Explorer GUI, a registry entry will be created and TF.exe should use that setting.  Alternately you could add an Environment Variable to your system or at the command line.

You can check if you have the registry setting-

HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0\TeamFoundation\SourceControl\Proxy

Should have a string value called URL and one called ENABLED

If you have not used the GUI and do not have the registry setting, try-

From your script of command line issue this before using tf.exe-

set TFSPROXY=http://ProxyServerAddress:8081

or add an Environment Variable to your system

Variable Name- TFSPROXY

Value- http://ProxyServerAddress:8081

via TFS Commandline utility.

Proxy Command.

Profile Command.

Pre-caching your TFS Proxy – Martin Woodward.

c# – How to connect to TFS via proxy programmatically? – Stack Overflow.

visual studio – Connecting to Team Foundation Server (TFS) with proxy authentication – Stack Overflow.

[ccnet-devel] Code consolidation – Ruben Willems – com.googlegroups.ccnet-devel – MarkMail.

–jeroen

via: Connecting Visual Studio 2010 to TFS over a Corporate Proxy (via: Visual studio 2010: cannot connect for any online resource – Stack Overflow) « The Wiert Corner – irregular stream of Wiert stuff.

Posted in Uncategorized | Leave a Comment »

Elfproef as T-SQL UDF

Posted by jpluimers on 2012/10/09

As a follow-up on my earlier number validation posts (Elf proef in C# and Other number verifications), I found a nice T-SQL version of the Elfproef for Dutch bank account numbers.

It works at least from SQL Server 2000 and up, most likely also in the (unsupported) SQL Server 7.

–jeroen

via: Elfproef als T-SQL UDF.

Posted in .NET, C#, Database Development, Development, Software Development, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 7 | Leave a Comment »

Twitter / alexnolannet: New utility: PDX Viewer Plus does not require drivers or an install…

Posted by jpluimers on 2012/10/08

Nice!:

New utility: PDX Viewer Plus 1.00 beta. A simple Paradox Database Viewer that does not require drivers or an install.

–jeroen

via: Twitter / alexnolannet: New utility: PDX Viewer Plus ….

Posted in Database Development, Delphi, Development, Paradox, Power User, Software Development | Leave a Comment »

Robocopy Exit Codes: 0 and 1 usually mean success

Posted by jpluimers on 2012/10/08

Most console applications return 0 (zero) as success.

But sometimes there are multiple success result codes, and the success depends on what you want to do with them.

One example is RoboCopy.

The zero result code means that nothing happened: no error occurred and nothing was copied, because there was no need to.

But for most RoboCopy scenario’s result code 1 (one) is also success. It means that no error occurred and that one ore more files were copied.

In fact the RoboCopy result codes form a bitmap explained on ss64.com.

Most RoboCopy use cases will have [0,1] as the set off success result codes.

–jeroen

via: Robocopy Exit Codes.

Posted in Batch-Files, Development, Power User, RoboCopy, Scripting, Software Development, Windows, Windows 7, Windows 8, Windows Server 2000, Windows Server 2003, Windows Server 2003 R2, Windows Server 2008, Windows Server 2008 R2, Windows Vista, Windows XP | 3 Comments »