Welcome to MSDN Blogs Sign in | Join | Help

July 2005 - Posts

See you at TechReady...

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 Read More...
Posted Friday, July 29, 2005 2:18 PM by jgalla | 0 Comments

More Virtual Earth...

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 Read More...
Posted Monday, July 25, 2005 5:12 PM by jgalla | 1 Comments

MSN Launches Virtual Earth

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 name/aerial Read More...
Posted Monday, July 25, 2005 10:19 AM by jgalla | 4 Comments

Stuart blogs about loading XML data into SQL Server using the CLR

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. Read More...
Posted Thursday, July 21, 2005 11:22 AM by jgalla | 0 Comments

Consequences of redefining the default element namespace

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 Read More...
Posted Tuesday, July 12, 2005 10:09 AM by jgalla | 0 Comments
Filed under: ,

Answer: Comparisons in XQuery vs T-SQL

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" Read More...
Posted Monday, July 11, 2005 11:03 AM by jgalla | 0 Comments
Filed under: ,

Interview with Jeff Minter about XBox 360 music visualizations

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 for Read More...
Posted Tuesday, July 05, 2005 9:52 PM by jgalla | 0 Comments
Filed under:

Quiz: Comparisons in XQuery vs T-SQL

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 1 where Read More...
Posted Tuesday, July 05, 2005 6:05 PM by jgalla | 2 Comments
Filed under: ,
 
Page view tracker