Browse by Tags

SQL Azure Federations and Semantic Search by the SQL product team in London tonight (Monday)
Mon, Jun 13 2011 6:40
Don’t forget that tonight we have Michael Rys from the SQL Server Product Team presenting on the Federation support coming to SQL Azure and the Semantic search coming in SQL Server Denali. This is a must attend evening for anyone that is serious about... Read More...
Working with large XML files in Management Studio
Wed, May 4 2011 18:14
Have you ever tried to generate a large XML file using FOR XML and then found Management Studio die when you try and look at the whole XML document (probably so you can save it). Well the issue is that normally ALL elements and attributes are generated... Read More...
Generating surrogate keys with xquery
Thu, Feb 25 2010 9:58
Saving a hierarchy of data from an XML document into a set of tables is a problem when the only relationship between nodes in the hierarchy is the position of the node. SQL doesn't like implied things like this. It likes things to be explicit. This... Read More...
XML Schema Collection in Database Professional Project
Thu, Jan 14 2010 13:05
If you are wanting to use schemas in your database using database professional then it is not that obvious. You can add XML SCHEMA COLLECTIONs but where do they do to. They are tuck away in the programability node under types, not the most obvious location... Read More...
"unable to switch the encoding" when deploying XML Schemas using Database Professional
Thu, Jan 14 2010 11:14
I've just blogeed about how to use XML Schema Collections in Visual Studio Database Professional Project I mentioned there is one gotcha about. The gotcha is if you have UTF-8 encoded schemas then they fail to be deployed. This is because they get... Read More...