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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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: 3m, computing hardware, development environment, fingers, gadgets, hd, microsoft, microsoft surface, pc hardware, real world, samsung, stack overflow, technology | 1 Comment »
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 »
The Wiert Corner - irregular stream of stuff 