The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,860 other subscribers

Archive for July, 2017

« Previous Entries
Next Entries »

BorCon 97, 20 years ago, Star Wars, 40 years ago

Posted by jpluimers on 2017/07/13

Marco Cantu (right) and Jeroen Pluimers (left) in 1997

Marco Cantu (right) and Jeroen Pluimers (left) in 1997

The BorCon 97 opening – today 20 years ago – was so much fun: the a Star Wars like opening crawl about a tiny company fighting the – then regarded – Evil Empire called Microsoft.

It was back in the days when lots of new things in the Delphi world were happening: Delphi 2 – the first 32-bit version – came out half a year before and the upcoming Delphi 3 was going to be a game changer as well. New features were rock solid and sales were booming.

Personally, I was much slimmer (yes, that’s me in the Tie-Dye), and could do a pre-conference tutorial on CORBA and VisiBroker (The ORB by Visigenic which was about to be acquired by Borland – which now is owned by Micro Focus only after spinning of the CodeGear which got acquired by Embarcadero that is now owned by Idera which feels like the Inprise story all over again).

I got triggered to this after watching the Opening Night Excitation episode 194 of the Big Bang Theory:

Read the rest of this entry »

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

https://www.youtube.com/watch?v=INzECItF6ew Delphi, where are you? 

Posted by jpluimers on 2017/07/12

Edit: in the mean time, the author took his video off-line. The G+ thread however is still interesting.

From a while ago:

[WayBack] https://www.youtube.com/watch?v=INzECItF6ew
Delphi, where are you? – Jacek Laskowski – Google+

 

YouTube video C++ Cool Debugging Tips and Tricks

–jeroen

Posted in C++, Delphi, Development, Software Development | 4 Comments »

Firebird: reset statistics for all indices using `set statistics index :index_name` – via: What is index selectivity?

Posted by jpluimers on 2017/07/12

A while ago, I needed to reset the index statistics for all indices in one our databases: a Firebird database.

I hadn’t done work like this in a while, so I made the cardinal mistake of Googling and using the first matching StackOverflow answer that seemed a perfect fit.

Boy was I wrong (:

In sql – My firebird query plan does not use correct index – Stack Overflow  I found the accepted answer (no less!) has this neat block to update index statistics for all indices:

    EXECUTE BLOCK
    AS
      DECLARE VARIABLE IDX VARCHAR(31);
    BEGIN
      FOR
        SELECT rdb$index_name FROM rdb$indices
        WHERE NOT rdb$index_name LIKE 'RDB$%'
        INTO :idx
      DO BEGIN
        EXECUTE STATEMENT 'update statistics ' || :idx
        WITH AUTONOMOUS TRANSACTION; 
      END
    END

The code consistently failed with this error:

    Script Error:
    
    Dynamic SQL Error
    SQL error code = -104
    Unexpected end of command - line 1, column 19

When I removed the lines inside the do begin … end block, then the outer statements execute fine.

Incidentally, column 19 is right at the space at the end of after the 'update statistics '. Which meant that either the string concatenation was wrong, or the statement itself.

And yes, I should have Googled the Firebird documentation instead, as What is index selectivity? has the correct statement that recalculates statistics for all indexes:

set term !! ;

EXECUTE BLOCK AS
declare variable index_name VARCHAR(31);
BEGIN
for select RDB$INDEX_NAME from RDB$INDICES into :index_name do
execute statement 'SET statistics INDEX ' || :index_name || ';';
END!!

set term ; !!

–jeroen

Source: What is index selectivity?

Posted in Database Development, Development, Firebird | Leave a Comment »

Cool Google stuff: Trivia Template for the Google Assistant

Posted by jpluimers on 2017/07/11

This is soo cool: [Archive.is] Trivia Template to make Google Assistant trivia questionaires.

It reminds me of a project a few years back where we did a similar thing to create automated interviews.

The trivia template tool lets you build apps for the Google Assistant without writing a single line of code.

Source: [WayBack] Google Assistant Trivia Template – Leon Nicholls – Medium

Via: [WayBack] Trivia Template: Nandini Stocker and I just launched a template tool to create trivia games for the Google Assistant. The template turns your questions and answers from a spreadsheet into a fully functioning game without writing any code… – Leon Nicholls – Google+

–jeroen

Posted in Development, Google, Google AI, Power User, Software Development | Leave a Comment »

Droste effect… best torrent sites – Google Search

Posted by jpluimers on 2017/07/11

Likely the Droste effect won’t last long: best torrent sites – Google Search and https://www.google.com/#q=best%20torrent%20sites both give this list at the top and a recursive link about stories with the search links at the bottom.

via many, including:

–jeroen

Read the rest of this entry »

Posted in Fun, Google, GoogleSearch, Power User | Leave a Comment »

Firebird: creating indices in scripts after checking for their existence

Posted by jpluimers on 2017/07/11

A few notes when making scripts that create indexes based if they do (not) exist (yet):

–jeroen

Read the rest of this entry »

Posted in Database Development, Development, InterBase | Leave a Comment »

3.6 GIG – Public-Mikrotik-Bandwidth-Test-Server – MikroTik RouterOS

Posted by jpluimers on 2017/07/10

Don’t abuse: 3.6 GIG – Public-Mikrotik-Bandwidth-Test-Server – MikroTik RouterOS [WayBack]

Primary btest server (for short high speed bursts):

  • IP address: 207.32.195.2
  • User: btest
  • Passowrd: btest
  • Max connection time: 10 minutes
  • No winbox access, only bandwidth test

Secondary btest server (for longer less high speed traffic) [WayBack]:

  • IP address: 207.32.195.10
  • User: btest
  • Passowrd: btest
  • Local Tx Speed: 25k
  • Remote Tx Speed: 25k
  • No winbox access, only bandwidth test

–jeroen

Posted in Internet, MikroTik, Power User, routers | 6 Comments »

Why each Google+ comment should get its own Web address – CNET

Posted by jpluimers on 2017/07/10

Sure, I’d like to be able to spotlight a Google+ comment by sharing a specific Web address. But Google’s social search effort would be the real beneficiary of comment permalinks.

After 5+ years, this is still on my wish list too…

–jeroen

via: Why each Google+ comment should get its own Web address – CNET

Posted in G+: GooglePlus, SocialMedia | Leave a Comment »

Vergelijk hier alle mobiliteitskaarten (Reisbalans vs XXImo vs MobilityMixx vs NS-Buisiness Card vs Radiuz. | Comparison tables – SocialCompare

Posted by jpluimers on 2017/07/09

Vergelijking tussen alle mobiliteitskaarten in Nederland, inclusiefde traditionele tankkaarten.

Source: Vergelijk hier alle mobiliteitskaarten (Reisbalans vs XXImo vs MobilityMixx vs NS-Buisiness Card vs Radiuz. | Comparison tables – SocialCompare

Posted in Uncategorized | Leave a Comment »

Happy #NoEmailDay – The case of the 500-mile email

Posted by jpluimers on 2017/07/07

Good reading on #NoEmailDay 2017: The case of the 500-mile email [WayBack] on how a sysadmin in the mid 1990s found the cause of not being able to send email further than roughly 500 miles.

The exact mile unit doesn’t matter as it was all approximation. Read the FAQ on the 500-mile email [WayBack]

–jeroen

via:

PS: some sendmail tricks from

Read the rest of this entry »

Posted in *nix, *nix-tools, Fun, Power User, sendmail | Leave a Comment »

« Previous Entries
Next Entries »