Knowledge++
Knowledge++ Posts with new things that I've learned
I recently developed a spatially-aware .NET application that did not use SQL Server 2008 as the backend (this enterprise was still on SS2005, but we needed the spatial support in the application today). While the application worked properly on my laptop, it was a huge failboat when deployed to the server environment.
I had previously posted that you can get the Microsoft.SqlServer.Types library from MS Downloads, but it turns out that this alone is not sufficient to allow your application to run. You also need to ensure that the SQL Server 2008 Native Client is also installed (regardless of whether you're...
When you write a query that SELECTs a SQL Server 2008 Spatial type, the returned result is a binary value. Without closely examining the bytes, I just assumed that this was WKB (Well-Known Binary).
Well, as it turns out, the bytes that are returned are simply a serialized version of the .NET object (the UDT has a Write() method that it calls internally to serialize the object in binary). This is NOT directly compatible with WKB.
My discovery source: http://social.msdn.microsoft.com/Forums/en-US/sqlspatial/thread/40ee9466-d7bf-4340-b295-53217ae5128e
During one of the many discussions at CodeMash, I brought up the fact that deep beneath the city of Detroit (some 1200 feet below the surface) exists a very large salt mine that spans some 1500 acres and contains over 100 miles of roadways connecting a series of large excavated rooms. This salt deposit, formed hundreds of millions of years ago when a great salty sea evaporated, actually extends under most of Michigan and lower Ontario, as well as parts of Ohio and New York. A large operation in Cleveland, for instance, mines salt from equal depths below Lake Erie.
My...
The other day, my Zune refused to pause the music. The icon in the lower right would toggle between Play and Pause, but the music kept playing. Holding the Pause button for about a second would cause the Zune to go to sleep, but upon waking up (pressing Pause again), the symptom persisted.
I needed to reboot my Zune, but didn't know how.
The solution is to hold the "Back" button and "Up" at the same time for about a second. The screen will blank, and then the device will reboot. Problem solved.
My discovery source: http://www.cliczune.com/2006/12/zune_tricks_reb.html
I'm constantly learning new things. I think it is human nature to do so. The sad thing is that a lot of what I learn either becomes trivialized or forgotten, so I don't appreciate that a discovery was made after the fact.
I'd like to change that. I'd like to share my little eye-opening discoveries with whoever has the time to read about them. Thus, I've started a new category on this blog that I call "Knowledge++".
Today's discovery involves ORACLE... you know, the other RDBMS out there in the wild. :-)
My current project uses an Oracle 10g backend. The other...