John Gallardo's Weblog
From Windows Phone
Why is there a 128-byte limit on the primary key for tables with a Primary XML Index?
One error that you may run into when attempting to create a Primary XML Index is the following: Msg...
Author: John Gallardo [MSFT] Date: 08/18/2005
Official XBox 360 Prices
Major Nelson has the scoop over at...
Author: John Gallardo [MSFT] Date: 08/17/2005
See you at TechReady...
I'm helping to proctor a lab session on the new XML features in SQL Server 2005 on Tuesday from...
Author: John Gallardo [MSFT] Date: 07/29/2005
More Virtual Earth...
One other thing I just now noticed... all of the menus and overlays have a cool transparency effect...
Author: John Gallardo [MSFT] Date: 07/25/2005
MSN Launches Virtual Earth
https://virtualearth.msn.com Things I like so far: Dynamic searches as you move around the map. For...
Author: John Gallardo [MSFT] Date: 07/25/2005
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...
Author: John Gallardo [MSFT] Date: 07/21/2005
Consequences of redefining the default element namespace
Check out Mike's entry regarding namespaces in XQuery. I wanted to illustrate one more point...
Author: John Gallardo [MSFT] Date: 07/12/2005
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...
Author: John Gallardo [MSFT] Date: 07/11/2005
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...
Author: John Gallardo [MSFT] Date: 07/06/2005
Quiz: Comparisons in XQuery vs T-SQL
I have the following two statements. What is the difference? What would you expect the results to...
Author: John Gallardo [MSFT] Date: 07/05/2005
Manipulating file names in command shell script
This has nothing to do with XML. I have been helping out another team here in the SQL Engine with...
Author: John Gallardo [MSFT] Date: 06/29/2005
Check out Galex's blog
https://blogs.msdn.com/galexy/ Galex has started blogging as well. He is another SDET here in the SQL...
Author: John Gallardo [MSFT] Date: 06/20/2005
Some more static typing info...
Denis talks about static typing again over in his blog. Today he is focusing on path expressions...
Author: John Gallardo [MSFT] Date: 06/14/2005
Denis talks about XQuery static typing in SQL Server 2005
Denis is one of my fellow SDETs on the SQL Server Engine team. He just started a blog about XSD in...
Author: John Gallardo [MSFT] Date: 06/13/2005
Quiz: SQL Server 2005 XML 'exist' method
Among the features introduced in SQL Server 2005 is the new XML Datatype. You can use this guy to...
Author: John Gallardo [MSFT] Date: 06/10/2005
Is this thing on...
Testing Testing... Ok I guess we are on. My name is John Gallardo (clever that, it matches the...
Author: John Gallardo [MSFT] Date: 06/10/2005