John Gallardo's Weblog

http://virtualearth.msn.com Things I like so far: Dynamic searches as you move around the map.  For example, I can search for "Starbucks", and as I move around the map it dynamically scopes the query to the area which is visible. Hybrid street...

I have the following two statements. What is the difference? What would you expect the results to be? Are you surprised by what you get? select 1 where convert(xml, '<foo>bar</foo>').value('/foo[1]', 'nvarchar(4)') = 'Bar' go select...

One other thing I just now noticed... all of the menus and overlays have a cool transparency effect where you can still see the map behind them. It is really subtle, but a nice touch! Good job guys! Oh yeah, and it looks like it might just be falling...

I'm helping to proctor a lab session on the new XML features in SQL Server 2005 on Tuesday from 12:00-4:00. This is my first time at one of these events on the "staff" side. I went to PDC when a lot of the CLR stuff was gearing up a few years ago when...

Link Strangely, one of the things I am looking forward to most for the XBox 360 is the inclusion of a real music visualizer. Frankly, since switching off WinAmp more than a few years ago I have been missing decent visualizations. The ones available...

Last week I threw out this simple little quiz . Here is the answer. The first query will return 1 or 0 rows, depending on what the default collation in your database is. On my machine, which uses the default out-of-the-box collation "SQL_Latin1_General_CP1_CI_AS...

Check out Mike's entry regarding namespaces in XQuery. I wanted to illustrate one more point regarding the consequences when namespace prefix bindings affect both query and construction. It is about the default element namespace. The real problem hits...

Stuart Padley , a Test Lead here in the SQL Server Engine team, posts about loading XML documents using a SQLCLR User Defined Function . It's good stuff and demonstrates an interesting way to overcome one shortcoming of OPENROWSET.