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

SQL Server 2005 script to restore .BAK file to a database in a specific directory

Posted by jpluimers on 2010/07/13

Recently I needed a way to automate some testing on SQL Server 2005.
The easiest way was to start with restoring some predetermined database state from a .BAK file.
Hence I wrote the script below.

Next to SQLCMD, this script uses SubInACL, which you can download here (don’t worry that version seems to be only for Windows 2000..2003: it still works in Windows 7).

Microsoft does not have much documentation (except the built-in by calling “SubInACL /help /full”.
But this SubInACL page has some more insight on how to use it. Read the rest of this entry »

Posted in Database Development, Development, SQL Server | Leave a Comment »

RT: JQuery: Novice To Ninja ebook free for 24 hours (or less now, I guess) – DelphiFeeds.com

Posted by jpluimers on 2010/07/12

If you want JQuery: Novice To Ninja ebook for free, then hurry :)

–jeroen

via: JQuery: Novice To Ninja ebook free for 24 hours (or less now, I guess) – DelphiFeeds.com.

Posted in Development, JavaScript/ECMAScript, jQuery, Scripting, Software Development, Web Development | Leave a Comment »

7 screens; 3 computers; 1 keyboard/mouse to direct them all: Input Director

Posted by jpluimers on 2010/07/12

At home, I have 7 screens on 3 computers on the same desk.

That sounds like a clutter, but all these keyboards and mice hooked up to them add even more clutter.

Until I found out about [Wayback] Input Director a while ago: a (virtual)  Software KVM to Control Multiple Computers.
It took only a few minutes to setup, and works like a breeze.

I have played around with it for about 2 months now, and it is great: I did not have to change any settings since the initial – and easy – setup.

Now I just use the keyboard/mouse that are most convenient to my situation: all keyboard/mice can control all computers and monitors.

A breeze indeed!

–jeroen

Posted in Keyboards and Keyboard Shortcuts, Power User | Leave a Comment »

Windows 7 shortcuts in Vista or XP

Posted by jpluimers on 2010/07/09

A while ago, I posted about Windows 7: new shortcut keys (windows hotkeys and more).

When you are in Vista or XP, you can feel a bit ‘lost’ missing those new keyboard shortcuts.

I just learned there is a tool that supplies the new Windows 7 keyboard shortcuts in Vista and XP :-)

–jeroen

Posted in Keyboards and Keyboard Shortcuts, Power User | Leave a Comment »

Date Time SQL Queries: Formatting Date Time Values for Access SQL in Delphi

Posted by jpluimers on 2010/07/08

Five words:

use parameters instead of literals.

via: Date Time SQL Queries: Formatting Date Time Values for Access SQL in Delphi.

Edit: Fixed “in stead of” into “instead of”: learned something new today :-)

–jeroen

Posted in Delphi, Development, Software Development | 9 Comments »

Hardening WordPress: when 10 Useful WordPress Security Tweaks are not enough

Posted by jpluimers on 2010/07/07

Last week, Jean-Baptiste Jung started a bit of a stir when posting on Smashing Magazine about 10 Useful WordPress Security Tweaks.

He totally missed the official Hardening WordPress page and generated a lot of comment traffic.
All of his tweaks were rebutted by commenter Vid Luther (Mobile Commerce and Technology Evangelist and ZippyKid owner) in a separate How to Secure a WordPress Site.

This once again shows that for serious work you really need to know what you are doing.
If you don’t, then leave the work to people who do: Vid is one of those guys.

–jeroen

via: 10 Useful WordPress Security Tweaks – Smashing Magazine.

Posted in Development, Software Development, Web Development, WordPress | Leave a Comment »

Chrome – report New Issue – chromium

Posted by jpluimers on 2010/07/06

For my reference: Report a New Issue – chromium.

Posted in Power User | Leave a Comment »

Delphi interfaces on binary level « The Programming Works

Posted by jpluimers on 2010/07/06

This interesting post by Serg Kas on Delphi interfaces on binary level didn’t make it on DelphiFeeds, hence my reference to it.

It is a nice post about the inner workings of interfaces in Delphi.

Recommended reading!

–jeroen

via: Delphi interfaces on binary level « The Programming Works.

Posted in Delphi, Development, Software Development | Leave a Comment »

Alternative PDF viewers

Posted by jpluimers on 2010/07/06

Some alternatives to Adobe Reader for the Windows platform:

The development channel of Google Chrome now has a rudimentary built-in PDF viewer.

–jeroen

Posted in Power User | 2 Comments »

Bleeding Edge: Vodafone UMTS caused WordPress.com “edit link” to be broken in Google Chrome. #fail

Posted by jpluimers on 2010/07/05

Last week I wrote about Bleeding Edge: version WordPress.com “edit link” broken in latest Google Chrome stable build – or is Vodafone causing this? #fail.

Since then I have researched this further: I verified that the http://1.2.3.4/bmi-int-js/bmi.js link indeed was caused by Vodafone.

They use a mechanism of directing all HTTP traffic through a transparent proxy and rewriting both the HTML and images in compressed form in order to save bandwidth.

There are a few problems with this:

Read the rest of this entry »

Posted in Bookmarklet, Power User, Web Browsers | Leave a Comment »