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,862 other subscribers

Archive for October, 2012

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 »

Some notes on multi-touch and Windows

Posted by jpluimers on 2012/10/06

While fooling around with Microsoft Surface, you are astonished with the number of fingers it supports: 10 is no problem on the Samsung SUR40 which can also do full HD resolution (more specs here).

Not so with the standard Windows 7 touch support: that has only 2.

As I want to increase that to better mimic the development environment to the actual environment a few notes:

–jeroen

Posted in .NET, Development, Microsoft Surface, Microsoft Surface on Windows 7, Software Development, Windows 7, Windows 8 | Tagged: , , , , , , , , , , , , | 1 Comment »

Studentenbestand nu fors gegroeid; ook in de toekomst?

Posted by jpluimers on 2012/10/06

Naar aanleiding van het nieuwsartikel  Studentenbestand groeit fors was mijn vraag: en hoe is dat in de toekomst? Hangt dat niet heel sterk af van de geboortegolven en dalen van de afgelopen decennia?

Een antwoord op die vraag blijkt met een korte online research vrij lastig te staven.

Aan de ene kant is er een mooie grafiek van de geboorte golven en dalen van de afgelopen decennia in het stuk Demografie van de Vergrijzing uit 2011 van het CBS die zou hinten op een vrij grillig verloop. Aan de andere kant Bevolking: Wat zijn de belangrijkste verwachtingen voor de toekomst? op de site van het Nationaal Kompas die een veel gelijkmatiger ontwikkeling van deze leeftijdsgroep aangeeft.

Kennelijk zijn er dus meer krachten in het speelveld. Uiteraard het stijgende opleidingsniveau. Maar kennelijk moet er meer zijn.

Ik ben benieuwd of er iemand betere bronnen heeft kunnen vinden om hier wel een antwoord op te geven.

–jeroen

via: Studentenbestand groeit fors | nu.nl/binnenland | Het laatste nieuws het eerst op nu.nl.

Posted in Opinions | Leave a Comment »

What a laugh: Apple restricted all 3rd party web browsers on the App Store as 17+

Posted by jpluimers on 2012/10/05

Chrome, Opera, etc are all rated as 17+ for “mature content” ans such by Apple.

So they think nobody with Safari will see any mature content?

What a laugh!

–jeroen

via: Is Apple Restricting Google Chrome For iOS Out Of Spite? | WebProNews.

Posted in iOS, iPad, iPhone, iPod touch, Opinions, Power User | Leave a Comment »

SvnBridge – Use TortoiseSVN with Team Foundation Server: issues with accented characters and escapes

Posted by jpluimers on 2012/10/05

Until bugs in the link below get fixed, when using SvnBridge to talk SVN to TFS:

  • don’t use non ASCII characters in your path names
  • don’t use escapes

This include SVN usage on codeplex.

–jeroen

via: SvnBridge – Use TortoiseSVN with Team Foundation Server – View Discussion.

Posted in CodePlex, Development, Source Code Management, Subversion/SVN, TFS (Team Foundation System) | Leave a Comment »

Happy 20th anniversary ThinkPad

Posted by jpluimers on 2012/10/05

Wow, it feels like yesterday, but on the 5th of October 1992, the ThinkPad 700C saw the light.

My ThinkPad start was in 2000 with a ThinkPad A20p. After that, I almost exclusively used ThinkPad laptops ever since (with the exception of Apple specific equipment: I have been using MacBook Airs):

–jeroen

via ThinkPad – Wikipedia, the free encyclopedia.

Posted in About, Personal, Power User | 2 Comments »