16 posts from: Michael Rys
Update on SQL PASS 2007 Presentations
(Indexed 2007-09-19):
I am giving 3 presentations at SQL PASS 2007 in Denver: Wednesday, September 19th, 9:45am to 11am, room 709:DBA-317-M The Next Release of Microsoft SQL Server: Beyond Relational(co-presenting with Kevin Farlee) Main focus will be the new features in the areas of unstructured and semistructured data management in SQL Server 2008. Wednesday, September 19th, 1:30pm to 2:45pm, room 709:AD-407-M Deep Dive into XQuery and XML in Microsoft SQL Server: Common Problems & Best Practice Solutions This is t...(truncated)...
SQL Server 2008 June CTP has been annouced at TechEd 2007
(Indexed 2007-06-04):
At today's TechEd 2007 in Orlando, we have annouced SQL Server 2008's, formerly known as Katmai, first community tech preview (CTP). Unlike SQL Server 2005, where we took over 5 years, SQL Server 2008 will be delivered in less than 3! See here for the official scoop and register here!What does this bring for XML Support and other interesting programmability support, you may ask. Well, we are doing a bit of XML (not quiet as much as you may would have liked, but we need to also invest in other ar...(truncated)...
What do you want to see regarding XML support in the next version of SQL Server?
(Indexed 2005-11-26):
Now that we have shipped SQL Server 2005, I would really like to hear from you what you want us to do regarding XML support in SQL Server 2005. Feel free to either contact me directly or leave your wish in the comment section.[Image]
Watch out Europe - Here I come...
(Indexed 2005-11-26):
Tomorrow I will be on my way to Europe for the SQL Server Launch Events in Zurich and Lausanne (Switzerland) and Athens (Greece). In Switzerland I will be presenting a specially made presentation on "What's new in SQL Server 2005" that will be more technical than the general launch presentation that I am giving in Athens.In addition, I will be visiting family, speak at the .Net User Group in Kuesnacht on XQuery and XML in SQL Server 2005, and will give two presentations on SQL Server in general ...(truncated)...
SQL Server 2005, MySpace.com and Quiznos: What do they have in common?
(Indexed 2005-11-16):
Now that we have shipped SQL Server 2005, I am happy to see that people are interested in using it. Today, I ask you the following riddle:What does SQL Server 2005, MySpace.com and Quiznos have in common?Well, here is the answer:Here is a link to Rick Penwell's blog on the MySpace next generation project. Why is that interesting you ask? Because MySpace.com is among the top 10 most visited websites in the world and because he will be using SQL Server 2005 and the XML datatype for the next genera...(truncated)...
International SQL Server Survey: Win a portable music player!
(Indexed 2005-11-14):
The Windows Server System team is doing a Learning and Help survey and need more SQL Server specific feedback.If you live outside of the United States or Canada, we want to know more about your experience with SQL Server!How did you initially learn to use SQL? What are your preferences for learning new topics? What can we do to make SQL easier to learn and use?Send e-mail to wssinfo@microsoft.com to obtain a secure code and link to the survey. Complete the survey for a chance to win a portable M...(truncated)...
SQL Server 2005 and Visual Studio 2005 Launches
(Indexed 2005-11-07):
Today is the big launch. Steve B. is giving the launch keynote in San Francisco. I am currently sitting in a meeting room at a competitor's place where I am at for a W3C XQuery meeting watching the live webcast during our lunch break :-). I already provided a list of many (but not all) of the new and improved features of SQL Server 2005. Today's launch has some additional cool tidbits:We broken through the 10$/transaction cost on the TPC-H 100GB benchmark and are also on top in terms of performa...(truncated)...
XQuery 1.0 and XSLT 2.0 are now in Candidate Recommendation
(Indexed 2005-11-03):
Finally, after 6 years of hard work, the W3C has released the Candidate Recommendation specs for XQuery 1.0, XPath 2.0 and XSLT 2.0. Does this mean that the recommendations are done? No, not yet. But it means that we reached an important milestone. Now everyone is officially invited to implement the specs, run the test suite, and provide feedback. Within the next couple of months, we will see which ones of the features will have at least two implementations with the same result and what may be u...(truncated)...
PDC 2005 Videos and Slides and demos are now online
(Indexed 2005-10-28):
The PDC 2005 videos are now online (via http://blogs.msdn.com/mswanson/archive/2005/10/24/484434.aspx). Oleg has distilled the XML and language specific presentations.And finally, from that list, here is the pointer to my presentation:DAT405: SQL Server 2005: Deep Dive on XML and XQuerySpeaker: Michael RysManaging semi-structured and markup data is becoming an increasingly important aspect of data management. Besides storing XML natively in a database such as SQL Server 2005, it is as important ...(truncated)...
The light at the end of the tunnel is bright sunshine!
(Indexed 2005-10-27):
We have RTM'ed today!Today, we have released SQL Server 2005 and VisualStudio 2005 and the .Net Framework 2.0 to manufacturing. This means the code is baked, done, shipped,... :-). It will be downloadable from MSDN within the day and available through the other channels in a couple of days.Follow the link for a teaser for all the cool things SQL Server 2005 will provide!Thanks for all the feedback and help and see you at the launch events.On my part, I am gearing up for the launch events in Swit...(truncated)...
Welcome Jinghao Liu to the Blogosphere
(Indexed 2005-10-14):
It is my pleasure to introduce you all to Jinghao's weblog. He is our test lead and so far seems to cover the SQL Server 2005 XML support in Chinese :-).Please go and take a look and say .[Image]
XML related changes to the September CTP
(Indexed 2005-10-11):
While we are less than a month away from the official launch week of SQL Server 2005, I am still providing you with the promissed change list for the XML area in SQL Server 2005's September CTP. And please accept my apology for the delay. Please continue here for the changes.[Image]
Changes to the default encoding handling of XML when passing XML from the client to the server.
(Indexed 2005-10-11):
In SQL Server 2005 versions up to the June CTP, the XML parser on the server-side defaulted to UTF-16 for documents without a leading byte-order mark and without an explicit encoding in the XML declaration. Since this was incompatible with the XML standard that defaults to UTF-8, we had reports of bugs where UTF-8 documents loaded through ADO.Net and SNCLI either got rejected - or worse - got accepted but stored wrongly since they were interpreted as UTF-16 encoded documents instead.We have fixe...(truncated)...
Why are you searching for "sp_xml_preparedocument Failed load msxmlsql"?
(Indexed 2005-10-06):
Since we got "upgraded" from .Text to Community server, we are not getting good referrer log information anymore. However, since I added some additional traffic tracking I can see a bit better again, what people are looking for(still not as good as .Text.And one of the most surprising aspects (beyond those that search my name for whatever reason...), is that quite a few queries search for something along the line of "sp_xml_preparedocument Failed load msxmlsql". Now we had some problems in the A...(truncated)...
Presentations at SQLPASS 2005 (Grapevine, Tx)
(Indexed 2005-09-28):
As many others in the SQL Server community, I have travelled to Grapevine, Texas to attend and present at this year's SQLPASS 2005 (site seems down while I write this). Since some people were unable to attend or had to leave early, I am now giving an additional presentation on Friday:Friday, September 30228: SQL Server 2005: Deep Dive Into XQuery Michael Rys, Microsoft Corporation4:00 p.m. 5:15 p.m.; Texas 1-2 Note that this presentation is basically my PDC 2005 talk, that I will slightly adjus...(truncated)...
The innards of our XQuery implementation
(Indexed 2005-09-22):
Our VLDB 2005 paper on the innards of our XQuery implementation is now available online. Shankar gave the presentation in Trondheim. As the previous conference papers, this paper gives an in-depth look into how we implement our XML and XQuery support. A must-read for anyone that wants to understand the "how we do it" and the why.From the abstract:This paper describes the experiences and the challenges in implementing XQuery in Microsofts SQL Server 2005. XQuery language constructs are compiled i...(truncated)...