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

Archive for December, 2013

« Previous Entries
Next Entries »

floating point – SQL Server: Calculation with numeric literals requires to cast to obtain the right precision (via: Stack Overflow)

Posted by jpluimers on 2013/12/24

This has bitten me so many times, so I’m glad I found the below question/answers on StackOverflow.

When you perform calculations in SQL Server involving numeric literals, you have to take into account which precision you want your result to be, and CAST/CONVERT  the literals accordingly.

The reason is condensed to this statement by Lieven Keersmaekers:

SQL Server uses the smallest possible datatype.

He follows with examples to view the actual representation of a literal/expression using SQL_VARIANT_PROPERTY (which has been there since at least SQL Server 2000).

SELECT SQL_VARIANT_PROPERTY(1.0, 'BaseType')
SELECT SQL_VARIANT_PROPERTY(1.0, 'Precision')
SELECT SQL_VARIANT_PROPERTY(1.0, 'Scale')
SELECT SQL_VARIANT_PROPERTY(1.0, 'TotalBytes')

Read the rest of this entry »

Posted in Algorithms, Database Development, Development, Floating point handling, Software Development, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 7 | Leave a Comment »

Spam in template format

Posted by jpluimers on 2013/12/23

The SPAM that someone tried to post to my blog this night contained the full script text.

Probably something companies akismet.com can use it to filter SPAM…

–jeroen Read the rest of this entry »

Posted in Blogging, Power User, SocialMedia, WordPress | Tagged: | Leave a Comment »

▶ Characters, Symbols and the Unicode Miracle – Computerphile – YouTube

Posted by jpluimers on 2013/12/23

Brilliant:

UTF-8 explained in less than 9 minutes.

The diagram fits almost on the back of a napkin, so he explained it with a big marker on classic 132-column fan fold green-bar continuous form  paper (we used to call it zebra-paper).

I’m definitely going to follow the Compuerphile videos and watch more of them.

Definitely a great addition to my UTF-8 posting category.

Thanks for everyone that pointed me to this video!

–jeroen 

via: ▶ Characters, Symbols and the Unicode Miracle – Computerphile – YouTube.

Posted in Development, Encoding, Software Development, Unicode, UTF-8, UTF8 | Leave a Comment »

Understanding ARM Assembly Part 1 – Ntdebugging Blog – Site Home – MSDN Blogs

Posted by jpluimers on 2013/12/23

Another interesting series that just started: Understanding ARM Assembly Part 1 – Ntdebugging Blog – Site Home – MSDN Blogs.

–jeroen

Posted in ARM, Assembly Language, Development, Software Development | Leave a Comment »

Thanks OSXDaily: Install wget in Mac OS X Without Homebrew or MacPorts

Posted by jpluimers on 2013/12/23

wget is immensely useful tool to download files using ftp, http and https, especially as it allows recursive downloads and mirroring with some very nice options.

Mac OS X doesn’t come with wget, and curl – the alternative for wget – cannot do recursion, so you need wrapper scripts for that.

Basically there are two ways to get wget installed on Mac OS X:

  1. Compile it from the source, then install it like Install wget in Mac OS X Without Homebrew or MacPorts.
  2. Download a prebuilt version like wget – Prebuilt binary for Mac OSX Lion, Snow Leopard and Mountain Lion | Tech Tach.

For both ways you need to remember that they won’t automatically update. So: keep an eye on wget security vulnerabilities, and update as soon as new ones have been found.

The first way (build from source) needs you to download and install Xcode first. Since I’m a Mac OS X developer, I already have that.

Luckily Install wget in Mac OS X Without Homebrew or MacPorts had instructions for the most current version when writing this blog entry. The binary from Tech Tach was outdated.

That, and the my feel for greater influence on the built proces makes me like the first way more.

Below are the commands I used (thanks OSXDaily!).

Check http://ftp.gnu.org/gnu/wget/ to make sure you downloaded the most current wget sourcecode. Read the rest of this entry »

Posted in *nix, Apple, Mac, Mac OS X / OS X / MacOS, Mac OS X 10.4 Tiger, Mac OS X 10.5 Leopard, Mac OS X 10.6 Snow Leopard, Mac OS X 10.7 Lion, OpenSSL, OS X 10.8 Mountain Lion, Power User, Security, wget | Leave a Comment »

DelphiSpec Library Announce « Роман.Янковский.me

Posted by jpluimers on 2013/12/22

Cool stuff: DelphiSpec library, inspired by Cucumber. It runs on top of DUnit.

via DelphiSpec Library Announce « Роман.Янковский.me.

A similar one in the .NET realm: SpecFlow – Pragmatic BDD for .NET.

–jeroen

Posted in .NET, .NET 3.5, .NET 4.0, .NET 4.5, C#, C# 3.0, C# 4.0, C# 5.0, Delphi, Delphi 2005, Delphi 2006, Delphi 2007, Delphi 2009, Delphi 2010, Delphi XE, Delphi XE2, Delphi XE3, Delphi XE4, Delphi XE5, Development, Software Development | Leave a Comment »

▶ Near to the Metal – Computerphile – YouTube

Posted by jpluimers on 2013/12/22

Funny: he started with a Chemistry study too (:

▶ Near to the Metal – Computerphile – YouTube.

Posted in About, Personal | Leave a Comment »

Scott Hanselman’s 2014 Ultimate Developer and Power Users Tool List for Windows – Scott Hanselman

Posted by jpluimers on 2013/12/22

After a couple of years break, there is the new Scott Hanselman’s 2014 Ultimate Developer and Power Users Tool List for Windows – Scott Hanselman.

A must read!

–jeroen

Posted in .NET, Development, Power User, Software Development, Visual Studio and tools, Windows | Leave a Comment »

Interesting start of a new bi-weekly “Wahl Network’s Tech Blast” series: Tech Blast #01

Posted by jpluimers on 2013/12/22

The new bi-weekly “Wahl Network’s Tech Blast” seems to be centered around virtualization with lots of information about vSphere, ESXi and integrating cloud stuff like the *aaS acronyms.

But it also has an interesting link to Fasting to Mitigate Jet Lag: Surprise! It Works!.

And I’m surely going to read these two links as well:

I’m going to watch this for a while to see if it stays this good.

–jeroen

via: Tech Blast #01.

Posted in Power User, VMware, VMware ESXi | Tagged: , | Leave a Comment »

Link Shell Extension: for hardlinks, junctions, volume mount points, etc.

Posted by jpluimers on 2013/12/20

Interesting as a complement to fsutil and mklink and FindLinks and Junction: Link Shell Extension and ln.exe.

It allows you to create and maintain “Hardlinks, Junctions , Volume Mountpoints , and Windows7/8’s Symbolic Links, (herein referred to collectively as Links) a folder cloning process” and more.

Note that Link Shell Extensions require NTFS5 or higher (NTFS.sys version 5, which corresponds with NTFS v3.1)

–jeroen

via: Link Shell Extension.

Posted in Power User, Windows, Windows 7, Windows 8, Windows Server 2000, Windows Server 2003, Windows Server 2003 R2, Windows Server 2008, Windows Server 2008 R2, Windows Vista, Windows XP | Leave a Comment »

« Previous Entries
Next Entries »