Quite a few web sites have fields where you cannot paste with Ctrl-V.
I don’t know why: pasting text input is a great way to speed up your work.
A solution for most of them: Read the rest of this entry »
Posted by jpluimers on 2010/07/16
Quite a few web sites have fields where you cannot paste with Ctrl-V.
I don’t know why: pasting text input is a great way to speed up your work.
A solution for most of them: Read the rest of this entry »
Posted in Chrome, Firefox, Internet Explorer, Keyboards and Keyboard Shortcuts, Power User, Web Browsers, Windows | 1 Comment »
Posted by jpluimers on 2010/07/15
Thanks to Kilian Croese, I updated the Google Calendar – printing multiple months or weeks to PDF posting with this info:
The original post is now both far easier to use, and much more complete.
Posted in Font, Google, Google Apps, PDF, Power User | Leave a Comment »
Posted by jpluimers on 2010/07/14
Declared @local_variables and parameters in stored procedures are a very handy feature of SQL Server.
They allow for local storage, and for passing information around without storing them in your database first.
You can assign values by using both SET @local_variable, and SELECT @local_variable.
Note that these are different than a regular SET or regular SELECT.
In addition, SET @local_variable and SELECT @local_variable are different too.
Though Microsoft recommends using SET, there are a differences between SET and SELECT, which can make SELECT a lot faster in loops.
There seem to be no examples (or very few: as I could not find them) about using the SELECT @local_variable to select values into multiple @local_variables from a query.
This can be very useful, so here is a small example: Read the rest of this entry »
Posted in Database Development, Development, SQL Server | Leave a Comment »
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 »
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 »
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 »
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 »
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 »
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 »
Posted by jpluimers on 2010/07/06
For my reference: Report a New Issue – chromium.
Posted in Power User | Leave a Comment »