Posted by jpluimers on 2012/12/30
Just noticed that in openSUSE 12.x, A plain halt will not shutdown the system properly.
On my system, it would leave the screen as shown on the right:
Only halt -p works, none of the other hints in the shutdown does not power off thread work, nor the acpi=off or acpi=oldboot settings.
The odd thing: a plain reboot still works properly.
If someone knows a better workaround: please let me know in the comments.
I hope they will fix this in a future openSUSE version; at least for 12.1 they have a “CHECKIT” marker in the documentation, but it has disappeared as of the 2.3 docs, but still fails:
5.4. systemd: System Shutdown
CHECKIT for 12.3. Is this entry still required?
To halt and poweroff the system when using systemd, issue halt -p or shutdown -h now on the command-line or use the shutdown button provided by your desktop environment.
Note: A plain halt will not shutdown the system properly.
Luckily, my openSUSE is a VM, which I can reboot from the ESXi host.
On a physical system, you will end up without any option to resurrect the system.
Later
After installing antivir, a plain halt works sort of: it says it is halted, but ESXi still thinks it is not:

After installing antivir, a plain halt appears to work, but it doesn’t.

ESXi is sure the system didn’t actually power down.
–jeroen
Posted in *nix, Linux, openSuSE, Power User, SuSE Linux | Tagged: acpi, computer, desktop environment, documentation, odd, openSUSE, reboot, shutdown button, software, SUSE, system shutdown, technology, thread work, vm | 4 Comments »
Posted by jpluimers on 2012/12/30
I see a lot of people throwing Tyvek envelopes and sheets in the recycled paper bins.
Don’t do that!
Since Tyvek is a plastic, you should recycle it as such: Read the rest of this entry »
Posted in LifeHacker, Power User | Tagged: climate, environment, hdpe, paper bins, tyvek envelopes | Leave a Comment »
Posted by jpluimers on 2012/12/29
WordPress.com silently restored the Please restore the tab order the way it worked 2 weeks ago problem.
I wished they’d send update notifications on those fixes (it seems the underlying ticket 21340 was fixed about 2 months ago in changeset 22250 when I was on a long holiday), so I’m glad to announce it works again.
Even better: you don’t need the tab key to go from “Edit” next to “Publish immediately” into the Month field:
When you press “Edit” the focus automagically shifts to the Month field.
Thanks!
–jeroen
Posted in SocialMedia, WordPress | Tagged: computer, focus, notifications, software, technology, wordpress | Leave a Comment »
Posted by jpluimers on 2012/12/29
Just got my free Flickr holiday gift: 3 months of Pro membership.
If you have a free Flickr account, it will give you three months of Pro to try it.

Yay!
You have now activated your Flickr Holiday Gift.
We’ve extended your Flickr Pro subscription for an additional 3 months at no charge.
Your Pro Account expires on 16th December, 2013
–jeroen
Posted in About, Flickr, Personal, Power User, SocialMedia | Tagged: flickr, gadgets, technology | Leave a Comment »
Posted by jpluimers on 2012/12/28
One thing I always forget (especially since the UI in Office 2007 changed quite a bit, but the idea below gets me going).
I’m assuming you want to print the grid…
- File > Page Setup,
- then go to the Sheet tab.
- On that page, under Print, there’s a checkbox called “Gridlines”.
–jeroen
via How do you make Excel print those cell lines? – AfterDawn: Forums.
Posted in Excel, Office, Power User | Leave a Comment »
Posted by jpluimers on 2012/12/26
If recent comments like below are flagged automagically as SPAM, then any political info will get auto-flagged as SPAM too (:
There are actually loads of details like that
to take into consideration. That may be a nice point to convey up.
I offer the thoughts above as common inspiration but clearly
there are questions just like the one you deliver up where an important factor will likely be
working in sincere good faith. I don?t know if finest practices have
emerged around issues like that, but I am sure that your job is
clearly identified as a good game. Both boys and girls really feel the impact of
just a second’s pleasure, for the remainder of their lives.
–jeroen
Posted in Opinions | Tagged: blogging | Leave a Comment »
Posted by jpluimers on 2012/12/26
There is a lot of information in Assembly that is either internal or private. Luckily you van get an AssemblyName instance through Assembly.GetName() or Assembly.GetName(Boolean) which has quite a few public members that get initialized while calling the internal AssemblyName.Init method.
This is the member mapping of AssemblyName members to Assembly members:
–jeroen
via: Assembly.GetName Method (Boolean) (System.Reflection).
Posted in .NET, .NET 3.5, .NET 4.5, ASP.NET, C#, C# 1.0, C# 2.0, C# 3.0, C# 4.0, C# 5.0, Development, Software Development | Leave a Comment »
Posted by jpluimers on 2012/12/25
In SQL Server 2000 and up, the easiest way to re-add a user that got orphaned is with a script like below.
The script does not correct the SID, but in stead sets new permissions (in this case, db_datareader and db_datawriter). Most of the times that is not a problem.
The script uses these stored procedures:
- sp_dropuser – drops a user from the current database
- sp_droplogin – drops a login from the current server
- sp_addlogin – adds a login to the database server
- sp_adduser – adds a user to the current database (you can add both a SQL user – with name and password – and a Windows user)
- sp_addrolemember – adds a member to a certain role
More modern versions have alternatives to these stored procedures, but the stored procedures work with the widest ranges of SQL Server versions.
-- Execute this script as SA or DB Administrator
use MyDatabase -- the databae where you want the user to be re-added to
-- you cannot perform a 'use [MyDatabase]' without destroying the context (and declared variables)
-- http://stackoverflow.com/questions/9165513/sql-server-change-current-database-via-variable
-- it is possible with exec (@exec_stmt) (as sp_droplogin does it), but it is a bit cumbersome for a relatively simple script
declare @loginname sysname
declare @passwd sysname
set @loginname = 'MyUser'
set @passwd = 'MyPassword'
-- from current database
exec sp_dropuser @loginname
-- from server
exec sp_droplogin @loginname
-- to current server
exec sp_addlogin @loginname, @passwd
-- to current database
exec sp_adduser @loginname
-- roles to add the user to
exec sp_addrolemember db_datareader, @loginname
exec sp_addrolemember db_datawriter, @loginname
If the user didn’t exist in the database, or didn’t exist as a login on the server, you can get two errors like these: Read the rest of this entry »
Posted in Database Development, 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 »
Posted by jpluimers on 2012/12/24
Just saw that Google Flights was introduce: for searching and booking flights online.
It needs some more work (see below), but it is a great start for a couple of reasons as compared to any of the competition I have seen:
- A much more intuitive and clutter-free user interface
- A blazingly fast response (SFO – AMS: response in about a second, all others took at least 10 seconds)
Try the user experience for yourself. A few things I liked:
- In addition to selecting preferred airlines, you can select preferred Airline Alliances
(they share miles anyway).
- Shows flight duration and allows you to sort on it
(ideal for business passengers)
- Shows if you can have WiFi
(for geeks like me)
- Uses hint-panes when you hoover the mouse over certain areas to fill in more detailed information
(like the airline that operates the flight, or the stops you make).
- Shows a graph with fare-rate over time
(so you can pick days with lowest fare more easily; the sweet spot for SFO-AMS seems to be 2-5 day trips that include a saturday/sunday night).
Some things they need to work on:
- You can search from USA to destinations outside USA, but not vice versa
(for instance, it finds SFO – AMS, but you are not allowed to enter AMS – SFO).
- You can enter IATA airport codes, but not ICAO ones (like EHAM)
- It is not included in the Google – Products list
(right now you can go from Flights to Web search, but not the other way around).
- It always starts with a departure in SFO
(it would make sense if you can select your faviourite departure airport; I live about 10 minutes from AMS / EHAM).
- It always starts with a departure date 16 days from now
(The last link is pun intended: it tests the Google search cache for refreshing pages that calculate information).
–jeroen
via: Flights from San Francisco – Google Search.
Posted in Google, GoogleFlights, Power User | Tagged: airline alliances, aviation, booking flights, business passengers, day trips, departure airport, departure date, eham, flight duration, google, google search, iata airport codes, lowest fare, preferred airline, preferred airlines, sweet spot, transportation, user interface | Leave a Comment »
Posted by jpluimers on 2012/12/24
For people that don’t want to run the wget on the URLs http://live.sysinternals.com and http://www.nirsoft.net, there is WSCC:
This edition of WSCC supports the following utility suites:
- Windows Sysinternals Suite (including support for Sysinternals Live service)
- NirSoft Utilities
–jeroen
via: KLS SOFT – WSCC – Windows System Control Center.
Posted in Power User, Windows | Leave a Comment »