Nachdem “Growing Object-Oriented Software, Guided by Tests” von Steve Freeman und Nat Pryce bei den Ruby Rogues besprochen wurde (siehe 068 RR Book Club: Growing Object Oriented Software Guided by Tests), war mir klar, dass ich es auch lesen musste. Und ich muss sagen: es hat sich definitiv gelohnt. Es…
Java has had quite a few security issues recently. Therefore, it definitely makes sense to enable the Java Updater and to install every Java update right after Oracle releases it. However, on my different Windows (64bit) boxes I could not configure the Java Updater. There was simply no “Update” tab…
I added a new Subversion repository on our Debian webserver today and got the following error messages when committing to it: [Wed Oct 10 …] [error] [client …] mod_dav_svn close_stream: error closing write stream [500, #200029] [Wed Oct 10 …] [error] [client …] Couldn’t perform atomic initialization [500, #200029] [Wed…
This is just a simple SQL statement that lists your 10 most commented WordPress articles: SELECT p.ID, p.post_title, count(comment_ID) AS num_comments FROM wp_posts p, wp_comments c WHERE p.ID=c.comment_post_ID GROUP BY p.ID, p.post_title ORDER BY num_comments DESC LIMIT 0,10;
When I tried to access a network share on a Windows 2008 server locally (!) today using a DNS alias I configured, I got System error 5 has occurred. Access is denied (Systemfehler 5 aufgetreten. Zugriff verweigert in German): As you see in the screenshot, the shares are enumerated correctly…
I’ve migrated my existing bookmark collection from Scuttle to SemanticScuttle. All it took was these three lines of SQL: insert into semanticscuttle.sc_users (uId,username,password,uDatetime,uModified,name,email,homepage,uContent) (select * from scuttle.sc_users); insert into semanticscuttle.sc_bookmarks (bId,uId,bIp,bStatus,bDatetime,bModified,bTitle,bAddress,bDescription,bHash) (select * from scuttle.sc_bookmarks); insert into semanticscuttle.sc_bookmarks2tags (select * from scuttle.sc_tags);
After installing Windows I always started configuring the same old basic settings: move Desktop, Documents, Music, Videos, Pictures folders to D:\ configure some basic settings in Windows Explorer folder options (e.g. show hidden files, show file extensions) remove Internet Explorer from taskbar and add PowerShell to it Today I set…
Apparently, it is not possible to use Oracle’s pseudo column rownum to select rows after a given number of rows, e.g. like SELECT * FROM tab WHERE rownum > 100; or in MySQL SELECT * FROM tab LIMIT 100,50; Oracle’s explanation for this (from the DB reference: ROWNUM): The first…
Today, a Git problem drove me nuts: I added files to the .gitignore file to make sure Git does not track and commit them to the repository. However, Git stubbornly ignored the file and kept adding all the files in my directory to the index. As it turned out, PowerShell…
In one of my recent PowerShell scripts I needed to find out if certain commands (in my case “svn”, “git”, “ant” and “mvn”) were available or not. I wrote this small function that tries to call the given command and returns whether it is callable. function commandAvailable($cmd, $options) { $error.clear();…