THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Michael Rys: Musings on XML, XQuery and more...

  • Taking SQL Server Code Name Denali Beyond Relational in CTP3

    Over the last couple of months the SQL engineering team has been busy preparing SQL Server Code Name “Denali” CTP3. As part of that effort, I have been driving the Beyond Relational scenario, that is adding some useful, cool and in some cases long awaited capabilities to SQL Server in the context of managing unstructured data and spatial data management. The video below gives you a quick overview of what we have added in “Denali:”

    In the area of providing a rich experience over unstructured data we:

    • have done lots of performance and scale work in Full-Text Search!
    • add customizable NEAR in Full-Text Search
    • add the ability to search only within document properties instead of the full document
    • provide semantic similarity search between documents. This provides you the ability to answer questions such as: "Find documents that talk about the same thing as this other document!"
    • achieved better scalability and performance for FileStream data, including the ability to store the data in multiple containers
    • offer full Win 32 application compatibility for unstructured data stored in a new table called FILETABLE. You create a Filetable and can drag and drop your documents into the database and run your favorite Windows applications on them (e.g., Office, Windows Explorer).

    In the spatial area we have added a lot of additional items including:

    • Circular arc support
    • GEOMETRY and GEOGRAPHY method parity
    • FullGlobe support for GEOGRAPHY
    • Spatial aggregation
    • Performance improvements for methods
    • Better predictable default index
    • Index support for nearest neighbor queries
    • and more

    You can also see a slightly more detailed presentation on Channel 9 and if you haven’t already, be sure to download SQL Server Code Name “Denali” CTP3 and begin exploring it today!

  • Trying to blog a bit more

    Well, after a long time not blogging, I am trying to blog a bit more... I have been tweeting in between (follow me at @SQLServerMike). And unfortunately my SQLJunkies blog seem to have disappeared in that buyout and reorg. I will have to repost some of them here again I guess ;)

    Over the last couple of years I have been working on not only XML but the whole "so-called" Beyond Relational space, that includes XML, but also unstructured data management, spatial, Service Broker, Search, sparse columns etc. That does not mean I did write all these specs but that I was driving the overall scenario value propositions and projects.

    Another cool project I was doing the program and project management for has been the componentization of the SQL Engine code base. So instead of one of the largest binary, SQL Server consists of several binaries now.

    The next post will talk a bit more about what we do in Denali with respect to Beyond Relational. Expect more blog posts on SQL Server and SQL Azure, Beyond Relational as well as NoSQL and Big Data musing and trends.

    I hope a few people still follow me here and on MSDN. :)

  • Update on SQL PASS 2007 Presentations

    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 the same presentation I gave at TechEd 2007, a bit shortened to fit into the timeslot. Focus is on SQL Server 2005 XQuery and XML optimizations, however they also will apply to SQL Server 2008.

    Thursday, September 20th, 1:30pm to 2:45pm, room 709:
    AD-312-M Building Spatial Application with Microsoft SQL Server
    (co-presenting with Isaac Kunen)
    This will be an updated presentation of the chalktalk that I gave at TechEd 2007. Main focus is that the demo runs now on the bits that will be shipping :).

    We merged the Friday 4pm presentation on managing unstructured and semistructured data (AD-313-M) with the presentation on "Beyond Relational" that Kevin and I will give on Wednesday. Primarily because the two presentations had a large overlap and neither Shan nor Srini were able to attend.

  • My first post on

    Hi all

    My name is Michael Rys. I am a program manager in the SQL Server Engine team at Microsoft and have so far been blogging at

    Starting today, I will move my main blogging activity from SQLJunkies over to here. I will continue to post there for a while, but everything you see there you will see here too ;-). The signal/noise ratio at SQLJunkies in comments is just unbearable, but I still have a readership there that won't follow me quickly.

    Please let me know if you want me to copy the old postings (at least the ones that are still relevant) over to here.

Privacy Statement