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 4,224 other subscribers

Archive for February 4th, 2014

How can you force SQL Server 2008 R2 to accept an ORDER BY on a column that is not part of a table? – Stack Overflow

Posted by jpluimers on 2014/02/04

I’m sure there are many organizations that only upgrade things until they absolutely have to (i.e. long after mainstream support has ended, often even after extended support has ended). This was from last year: upgrading away from SQL Server 2000 just before extended support ended. While migrating a bunch of applications we inherited from SQL Server 2000 to SQL Server 2008 R2, I came across an ORDER BY style that failed. The queries are generated by an kind of SQL generation layer, so not easy to change. the main questions were:

  • is it possible to force SQL Server 2008 R2 to accept this kind of queries and perform the SQL Server 2000 behaviour (so we can fix the SQL generation layer, and perform regression on it)?
  • why would SQL Server 2000 happily accept this kind of queries?

First two possible fixes, then the full stack overflow question I posted about the migration.

Aaron Bertrand very quickly posted two fixes, which I paraphrased and extended. Read the rest of this entry »

Posted in Database Development, Development, SQL Server, SQL Server 2000, SQL Server 2008 R2 | Leave a Comment »

Why the Heck is Git so Hard? | Probably Done Before

Posted by jpluimers on 2014/02/04

Why the Heck is Git so Hard? | Probably Done Before is wonderful, especially as it points to workspace • Git Cheatsheet • NDP Software.

And I really like this hacker news comment on it: Read the rest of this entry »

Posted in Development, DVCS - Distributed Version Control, git, Source Code Management | 2 Comments »

Display Windows 8.x Edition & Build Version on Your Desktop (via: Team Windows 8)

Posted by jpluimers on 2014/02/04

Display Windows 8 Edition & Build Version on Your Desktop | Team Windows 8:

Two keys needed: one HKCU one HKLM. You need to be Administrative user with a CUA token to install the second one.

Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Control Panel\Desktop]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Windows]


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

OS X menu keyboard shortcuts: Ctrl-F2 and Shift-Command-?

Posted by jpluimers on 2014/02/04

So I don’t forget:

Often, Ctrl-F2 (^-F2) fails to show the menu, but ⇧ ⌘ ? (shift+command+/) works all the time.

You can navigate the menus in the menu bar without using a mouse or trackpad. To put the focus in the menu bar, press Control-F2 (Fn-Control-F2 on portable keyboards). Then use the key combinations listed below.

Left Arrow and Right Arrow Move from menu to menu
Return Open a selected menu
Up Arrow and Down Arrow Move to menu items in the selected menu
Type the menu item’s name Jump to a menu item in the selected menu
Return Select a menu item



Posted in Apple, Keyboards and Keyboard Shortcuts, 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, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, OS X 10.8 Mountain Lion, OS X 10.9 Mavericks, Power User | Leave a Comment »

%d bloggers like this: