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,595 other followers

Archive for December 24th, 2013

Meeting Ticker: the estimated cost of a meeting in real time.

Posted by jpluimers on 2013/12/24

Fun: Meeting Ticker.

Posted in LifeHacker, Power User | Leave a Comment »

iTerm2 – Mac OS Terminal Replacement

Posted by jpluimers on 2013/12/24

In my research list: iTerm2 – Mac OS Terminal Replacement.

–jeroen

Posted in Apple, Mac, Mac OS X / OS X / MacOS, Mac OS X 10.7 Lion, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, OS X 10.8 Mountain Lion, Power User | Leave a Comment »

X-mas present: Beyond Compare v4 beta for Mac OS X, Windows and Linux

Posted by jpluimers on 2013/12/24

I’ve been wanting this a very long time, so I’m going to install it Right Now ™ (:

Right before X-Mas, Scooter Software did the ANN: Beyond Compare 4.0 beta available on Windows, Linux, and OS X:

Posted: Dec 23, 2013 4:17 PM

Beyond Compare 4.0 beta is now available for testing on Windows, Linux, and OS X.

http://www.scootersoftware.com/beta

This version adds a number of new features: Read the rest of this entry »

Posted in *nix, Apple, Beyond Compare, Delphi, Development, Linux, Mac, Mac OS X / OS X / MacOS, Mac OS X 10.7 Lion, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, OS X 10.8 Mountain Lion, Power User, Software Development, Source Code Management, SuSE Linux, Windows | Leave a Comment »

Top 10: Windows Firewall Netsh Commands (via: Windows Server content from Windows IT Pro)

Posted by jpluimers on 2013/12/24

For my own reference, especially since setting the network profile in Windows 8 from the UI got much more difficult.

It is doable though, but not in logic places; I like the secpol.msc way most: windows 8 – How do I set my wireless network to be private instead of public? – Super User.
Same for renaming the network, which also has a secpol.msc way that is easy:

  1. Press Win+R, then type secpol.msc
  2. Click on “Network List Manager Policies”
  3. Double-click on your network
  4. Optionally give your network another name
  5. Click on “Tab Network Location”
  6. Set “Location Type” to “Private”

Go back to Network and Sharing Center to check the result.

To start the Network and Sharing Center:

control.exe /name Microsoft.NetworkAndSharingCenter

Top 10: Windows Firewall Netsh Commands | Windows Server content from Windows IT Pro.

including:

  • Checking if the current profile is set to private/public/domain:

netsh advfirewall show currentprofile

Posted in Network-and-equipment, Power User, Windows, Windows 7, Windows 8 | Leave a Comment »

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 »

 
%d bloggers like this: