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

Archive for February, 2016

Just discovered Vysor now has mouse shortcuts too – via: Cool: Vysor screen sharing by Koush

Posted by jpluimers on 2016/02/19

Just updated Cool: Vysor screen sharing by Koush with this:

Edit 20160217: new keyboard/mouse shortcuts

  • Old: keyboard shortcuts
    • Escape -> Back Button;
    • F1 -> Menu Button;
    • Home -> Home Button;
  • New: mouse shortcuts
    • Middle Click -> Home;
    • Right Click -> Back

"Escape

Now hopefully the screen resolution thing will be fixed: [Wayback/Archive] github.com/koush/vysor.io/issues/68

–jeroen

Posted in Android, Android Devices, Chrome, Development, Google, Keyboards and Keyboard Shortcuts, KVM keyboard/video/mouse, Mobile Development, Power User, Vysor | Leave a Comment »

Parts for #Alulux and Benny 4.0 garage doors

Posted by jpluimers on 2016/02/19

Because of Repair of  #Alulux  AKS 2.0 (201237):

  • [WayBack] BENNY 4.0 (201250): Torsteuerung Benny 4.0; 230V, max Motorleistung 600 VA. Inklusive Anschlusskabel mit Schukostecker und Kabelverschraubungen, mit Totmannfreigabe über Schlüsselfunktion
  • HS2-M/868 (204052): Mini-Handsender; 868,5 MHz. 2-Befehl, für 868 MHz-Steuerungen (Benny 4.0), Detolux, Vertico
  • LSB/M (201467): Einweg-Lichtschranke; 2-Drahttechnik mit 10 m Kabel. Für Steuerung Benny 4.0, Detolux, Vertico. Als Durchfahrtsicherung.
  • EKL 2.0 (201230): Elektromechanisches Kontaktprofil, EKL, Widerstand 8,2 KOhm
  • AKS 2.0 (201237): Anschlußteile für elektromechanisches Kontaktprofil EKL, für Steuerungen mit Auswertung 8,2 KOhm (Benny 4.0, Logico 2.0), kabelgebunden
    • ANE 1: Anschlußstopfen
    • AB 82: Abschlußstopfen
    • KEM 206: Klemmkasten
    • KE: Spiralkabel
  • EKL/W: Bauteile für kabellose Wireless-Schießkantensicherung, in Anwendung mit dem elektromechanischen Kontaktprofil EKL, für Steuerungen mit Auswertung 8,2 KOhm (Benny 4.0)

All of the parts can be found in [locally archived: Planer_Garagentore.pdf] http://www.fricksonnenschutz.de/uploads/media/Planer_Garagentore.pdf

[WayBack] Benny 4.0 Anleitung

Alternatives via “Funk, Zubehör und Steuerungen für Rollltore: Handender, Empfangsteile und Steuerungen für Rollltore

Images below.

In 2019, I found a related repair at these links:

–jeroen

via:

Read the rest of this entry »

Posted in LifeHacker, Power User | Leave a Comment »

Oracle alter table drop column tips: unused columns

Posted by jpluimers on 2016/02/18

An interesting tip at alter table drop column tips for Oracle: unused columns.

I knew about the multi-column syntax for drop column, but the unused columns:

You can also drop a table column by marking it unused and then dropping the column, thusly:

alter table
    table_name
set unused column
    column_name
;

They will appear in the DBA_UNUSED_COL_TABS view.

After that:

alter table
    table_name
drop unused columns
;

You can perform the first statement for a few columns over time, then the last statement will delete them all.

Together with some other views like described in places like oracle – How to check if a column exists before adding it to an existing table in PL/SQL?, you can create nifty scripts for your meta-data maintenance.

–jeroen

via: alter table drop column tips.

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

A script to check the frequency of Oracle log switches | Oracle DBA tips

Posted by jpluimers on 2016/02/17

A wile ago, I had a this error when trying to get the TIME portion of a DATE column:

ORA-00904: "TIME": invalid identifier

This doesn’t work in Oracle, even though when you search for Oracle convert DATE to TIME you end up at this page listing TIME as a function: 12.7 Date and Time Functions. Alas, that page is for MySQL which is owned by Oracle for a while now.

Back to the query which was like this where date_column was of type DATE.

SELECT 
    id,
    date_column, 
    TIME (date_column)
FROM some_table

That DATE type actually stores date+time, and since it was filled with Delphi TTime values, the date parts would always be “1899-12-30” (yes, I like ANSI DATE and TIMESTAMP formats). Oracle doesn’t get that, so I wanted to get the time portion.

Solutions:

Read the rest of this entry »

Posted in Database Development, Delphi, Delphi 10 Seattle, Delphi 2005, Delphi 2006, Delphi 2007, Delphi 2009, Delphi 2010, Delphi 7, Delphi XE, Delphi XE2, Delphi XE3, Delphi XE4, Delphi XE5, Delphi XE6, Delphi XE7, Delphi XE8, Development, OracleDB, Software Development | Leave a Comment »

Get a Windows 10 development environment – Windows app development

Posted by jpluimers on 2016/02/16

When you own the full stack:

virtual machine (Build 201602)

These installs contain:

  • Windows 10 Enterprise Evaluation, Version 1511
  • Visual Studio 2015 Community Update 1
  • Windows developer SDK and tools (Build 10586)
  • Windows IoT Core SDK and Raspberry Pi 2 (Build 10586.0.151029-1700)
  • Windows IoT Core project templates (Version 1.0)
  • Microsoft Azure SDK for .NET (Build 2.8.2)
  • Windows Bridge for iOS (Build 0.1.0.160114)
  • Windows UWP samples (Build 2.0.4)Windows Bridge for iOS samples

The VMware VM link redirects to https://windowsdeveloper.azureedge.net/vm-1602/Win10Eval_1602_VMware.zip

Also available for Hyper-V, VirtualBox, Parallels

–jeroen

Source: Get a Windows 10 development environment – Windows app development

Posted in .NET, .NET 4.5, C#, C# 5.0, C# 6 (Roslyn), Cloud Development, Development, Hardware Development, Raspberry Pi, Software Development, VB.NET, VB.NET 14.0, Visual Studio 2015, Visual Studio and tools, Windows Azure | Leave a Comment »

NTLM and Kerberos Authentication for a WebRequest and a WebProxy

Posted by jpluimers on 2016/02/16

This was very useful to get a WebClient with a WebProxy configured to use a proxy server that is based on NTLM authentication.

The note in the MSDN NTLM and Kerberos Authentication. documentation however was totally wrong.

String MyURI = "http://www.contoso.com/";
WebRequest WReq = WebRequest.Create MyURI;
WReq.Credentials = CredentialCache.DefaultCredentials;

Note NTLM authentication does not work through a proxy server.

This code works perfectly fine as the CredentialsCache.DefaultCredentials contains your NTLM or Kerberos credentials.
It even works when you have a local Fiddler http proxy as a facade in front of your NTLM proxy.

Read the rest of this entry »

Posted in .NET, .NET 2.0, .NET 3.0, .NET 3.5, .NET 4.0, .NET 4.5, C#, C# 2.0, C# 3.0, C# 4.0, C# 5.0, C# 6 (Roslyn), Development, Fiddler, Software Development, Web Development | Leave a Comment »

Windows 7: you can only change the language for Ultimate and Enterprise editions – not Professional (or home)

Posted by jpluimers on 2016/02/15

It is hard to find in the Windows MUI Knowledge Center for which Windows 7 editions you can change the language. Only when you carefully read Language Packs in Windows 7, you see a table with “Availability and usage” indicating how you can get language packs. To summarize, Complete language packs are only available for:

  • Ultimate Edition
  • MSDN subscribers
  • Registered OEMs
  • Enterprises
  • Server

Virtually all UI languages are complete language packs as shown in the table under Available Language Packs.

In other words: you cannot change the UI language in Windows 7 professional as this post phrases in a much simpler way:

Unfortunately, the Multilingual User Interface (MUI) Language Packs will only work in Windows 7 Ultimate or Enterprise editions.

So of all Windows 7 Editions, only Ultimate and Enterprise allow you to change the language.

Bummer, as for all Windows 8 editions (same for 8.1 and up) allow you to change the UI language.

–jeroen

via:

Posted in Power User, Windows, Windows 7 | Leave a Comment »

Douglas Rushkoff: ‘I’m thinking it may be good to be off social media altogether’ | Technology | The Guardian

Posted by jpluimers on 2016/02/15

The media critic on the malfunctioning tech economy, digital detoxes and why Facebook is unhygenic

Source: Douglas Rushkoff: ‘I’m thinking it may be good to be off social media altogether’ | Technology | The Guardian

via Jan Wildeboer.

 

–jeroen

Posted in Uncategorized | Leave a Comment »

Nein? Doch! Oh!

Posted by jpluimers on 2016/02/14

It has a Web site! http://neindochoh.de/

Posted in Uncategorized | Leave a Comment »

Happy birthday Delphi, have some wine

Posted by jpluimers on 2016/02/14

Now that you’re 21, have a glass of wine and watch this great presentation by Warren Postma which he made for last years birthday:

–jeroen

Posted in Delphi, Delphi 1, Delphi 2, Delphi 2005, Delphi 2006, Delphi 2007, Delphi 2009, Delphi 2010, Delphi 3, Delphi 4, Delphi 5, Delphi 6, Delphi 7, Delphi 8, Delphi x64, Delphi XE, Delphi XE2, Delphi XE3, Delphi XE4, Delphi XE5, Delphi XE6, Delphi XE7, Delphi XE8, Development, Software Development | Leave a Comment »