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

Archive for the ‘Development’ Category

Linking to part of the same document in Markdown (via: Stack Overflow)

Posted by jpluimers on 2016/02/22

I love markdown, but it lacks the ability to directly create destination anchors (but MarkDownExtra however does for headers)

Anchors can be used to link within and between documents, the foundation of web navigation, and also very important inside documentation.

Luckily, Markdown allows inline HTML, so you can add an HTML destination anchor: an a element with either a name or id attribute.

XHTML deprecated the name attribute, but you should actually use it. The reason is that in HTML5, most browsers create a global JavaScript variable for each id id anchor.

In addition, you should not use a self closing a element: only XHTML supports that.

So the Markdown then becomes something like this:


## <a name='possiblePlatforms'>Possible platforms</a>
Link to [possible platforms](#possiblePlatforms).

view raw

anchors.md.txt

hosted with ❤ by GitHub

In the heading, you will see the html for the destination anchor, in the link you will see the MarkDown for the internal source anchor..

The above example will render like this:

–jeroen

via: How to link to part of the same document in Markdown? – Stack Overflow.

Posted in MarkDown, Power User | Leave a Comment »

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 »

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 »

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 »

BLDN: December 2015 XE7/XE8 Update Subscription Update got released 20160211 with backported 10 Seattle fixes

Posted by jpluimers on 2016/02/13

Seems they got only released just yesterday because of the QA effort taking a long time. But it’s good news for Delphi/Rad Studio/C++-Builder Update Subscription members: some fixes are now back-ported to 2 Delphi versions. Which is a new milestone in support from Embarcadero.

Anyway: BLDN.

Note that the list of fixes is at the bottom of these pages:

Source: RAD Studio Hotfixes for XE8 and XE7 with 10 Seattle fixes

I also found out that I never updated the links for XE8 update 1 downloads (I did the original XE8 links Delphi XE8 is out with version 22.0.19027.8951; Spring4D is almost ready. « The Wiert Corner – irregular stream of stuff) so there they are:

–jeroen

Posted in Delphi, Delphi 10 Seattle, Delphi XE7, Delphi XE8, Development, Software Development | 2 Comments »

Blast from the past Windows 2003 Service Pack 1..2 era hotpatching

Posted by jpluimers on 2016/02/12

For a short while (from Windows 2003 Service Pack 1 till Windows 2003 service pack 2) some updates used Windows Hotpatching.

Some links on the how/why and how to abuse it:

All because of this little post:

Hier ein Einblick in die Denkweise von Leuten, die Software auf CD-ROM verteilen und bei denen Release Zyklen in Monaten und nicht Minuten gemessen werd… – Kristian Köhntopp – Google+

–jeroen

 

Posted in C, Development, History, Software Development, The Old New Thing, Windows Development | Leave a Comment »

Translation Memory Tools Tried and Found Wanting – Oli’s Blog

Posted by jpluimers on 2016/02/11

Thanks Oliver for sumarising this: Translation Memory Tools Tried and Found Wanting – Oli’s Blog

His conclusion support why I see all my clients building their own translation tooling: no 3rd party tool really supports the full process well, especially not the translation memory parts.

–jeroen

Posted in Development, internatiolanization (i18n) and localization (l10), Software Development | Leave a Comment »