Posted by jpluimers on 2012/11/30
In Excel I always got confused with named ranges, as I thought they were hard to track.
The F3 keyboard shortcut gives you a list of named ranges including name and location. Which makes it way easier to work with named ranges.
See the excellent post Show all named ranges in Excel: It even has an animated gif image that shows you F3 in action.
via: Show all named ranges in Excel – Spreadsheet Audit & Maintenance Tip | Chandoo.org – Learn Microsoft Excel Online.
Posted in Excel, Keyboards and Keyboard Shortcuts, Office, Power User | Leave a Comment »
Posted by jpluimers on 2012/11/29
Great post: SQL Server: JOIN vs IN vs EXISTS – the logical difference.
Be aware of the three valued logic when NULL gets involved.
EXIST comes closes to what you expect.
And be aware that with IN, you cannod pass one parameter containing more than 1 IN value: sql server 2005 – Passing multiple values for one SQL parameter – Stack Overflow..
Posted in Database Development, Development, SQL, 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/11/28
I was involved in porting a Visual Studio 2003 VB.NET solution to the latest Visual Studio.
One of the things present was a binary (don’t ask) version of the VBPowerPack, which used to be available on GotDotNet.
Though you can link against .NET 1.1 assemblies from .NET 2.0 and up, I’d rather have source.
That allows me to fix things whenever something comes up (it probably does, as VBPowerPack was pre-Aero, so the controls in it might need some adjustments).
GotDotNet was hated by many people, and finally closed in 2007 by Microsoft in favour of CodePlex (don’t you just love the cloud?).
Luckily, people do archive stuff, so VB Helper has VBPowerPack.
The download is a simple MSI installer, that you can extract using something like this:
msiexec /a PathToMSIFile /qb TARGETDIR=DirectoryToExtractTo
Posted in .NET, Development, Software Development, VB.NET, Visual Studio 11, Visual Studio 2002, Visual Studio 2003, Visual Studio 2005, Visual Studio 2008, Visual Studio 2010, Visual Studio and tools | 1 Comment »
Posted by jpluimers on 2012/11/27
I could only find the System Error Messages overview for:
Are there any such links for SQL Server 2005 and up?
The odd thing is online lists of Database Engine Error Severities are available for multiple versions of SQL Server: 2005, 2008 and 2008 R2.
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 | 1 Comment »
Posted by jpluimers on 2012/11/26
So I won’t forget: below are IPv4 private network ranges that you can use behind your router.
Network you should not configure yourself:
I tried finding statistics on the actual use of private networks, but couldn’t.
This is from my own experience:
- Link-local is used when DHCP is not available.
- Lot’s of routers use 10.0.0.x, 192.168.0.0, 192.168.1.0.
- VMWare Workstation and VMWare Fusnion use 192.168.x.y.
via: Private network – Wikipedia, the free encyclopedia.
Posted in Internet, Power User | Leave a Comment »