All posts by : Irwin Dolobowskys Blog

1 of 24 | Bulkload Sample Code - As promised, the sample code for my presentation.  The Object Demo was from Andy Conrad's article “Death, Taxes, and Relational Databases, Part 2”.  The other demo was mine, and here's the code.  Again, the point of this demo was to show how two parties can exchange data from their databases using SqlXml.  Each database has a different schema and XML is used to transfer the data.  Both parties agree on a common XML schema for the data to to be transfered, and then each create a mapping to that XML schema for their database.  An XPath is issued against mapping one to retrieve data and bulkload is then used with the data and mapping two to load t......

2 of 24 | Chat with us now! - Sorry, got this rather late, but for anyone interested, the System.Xml team be on for the next hour or so: Title: C# and XML Use XML? Use C#? Have some questions, comments, or just want listen to people talk about your favorite technologies? Join members of the C# team and Dare Obasanjo <http://blogs.msdn.com/DareObasanjo/> of the XML/Data team for a discussion about C# and XML. Chat room: http://communities2.microsoft.com/home/chatroom.aspx?siteid=34000014 ...

3 of 24 | New Article - Xml Support in Microsoft Sql Server 2005 - There's a great new article up on MSDN giving an overview of the XML Support in Sql Server 2005: XML Support in Microsoft SQL Server 2005   How do I know its great?  Well, because I contributed of course!  Just a little, I did the section on SqlXml.  Shankar Pal and Mark Fussell did most of it.  Check it out for a great overview though. Off to San Deigo tomorrow to get in a little golf before Tech-Ed.  Demos and slides are mostly done, hopefully everyone will enjoy my talk.  I've ended up with 23 slides, but that also includes a nice bulkload demo and an objects out of the database demo using SqlXml.  Hopefully that will be “Extreme̶......

4 of 24 | Still Here, New Beginnings - Yes, for my faithful readers, I am still here.  It has been quite some time since I last posted, but I hope to make these much more frequently again.  Curious what I've been working on?  Well... SqlXml 3.0 SP3 - We're fixing issues with SqlXml running on Windows Server 2003, including removing our dependency on the SOAP Toolkit.  This should be out this week. SqlXml in Sql Server 2005 - Still working on that.  As anyone who grabbed Beta 2 saw, we're there! Now to finish nailing that down. SqlXml Long Term - We had planned on a new mapping stack in Whidbey, but that was cut due to varying circumstances. However, there are those of us who still believe grea......

5 of 24 | Tech Ed Prep - The past couple of weeks I've been working on my slide deck and demos for Tech Ed (DAT 405 if you're coming).  My biggest concern is to make sure that my talk isn't stale.  I want to ensure that anyone who comes, whether they're brand new to SqlXml or they've used it for years, gets something out of the talk.  Therefore, I'm approaching it a bit differently. Usually we give the standard history of SqlXml, go through each feature, explain what it does, one or two small demos and an “application” demo which usually consists of a small winforms app and a few lines of code that fill a text box with XML.  This year though I've (we've, to those who've helped put i......

6 of 24 | Tech Ed Wrap-Up - So I was hoping to have updated the blog a bit more during the week, but the internet access in the Cabana areas was iffy, and sitting back in the room here I usually just fell asleep.  This was my first Tech Ed US (I went to Barcelona last year) and I can say that it was very tiring but also very enjoyable.  I just got back from the big party at Sea World and some drinks with friends, and thought that I'd throw down my thoughts before enjoying a well-deserved nights rest.  You can see some stuff from the trip on my personal blog here. Overall, I thought the conference was great.  Every attendee I've talked to seems to agree and has told me that they've found ......

7 of 24 | Two New Articles - Bulkload in .Net and FOR XML in SQL Server 2005 - There are a few new SqlXml-related articles up on MSDN. First we have Amar Nalla's XML to SQL: Using SQLXML Bulkload in the .NET Framework which gives great examples on constructing annotated schemas and using Bulkload within .Net.  Amar goes into great detail on how to feed Bulkload with a stream, a process that takes some work when going from .Net through managed interop to Bulkload.  If you're using Bulkload within .Net check it out, its a great article and well worth your time to read. A little bit older is Michael Rys's article What's New in FOR XML in Microsoft SQL Server 2005 which discusses enhancements to the FOR XML extensions to T-SQL offered by SQL Server.&......

8 of 24 | SqlXml / MDAC Clarification - Apparently there`s been a bit of confusion out there lately about the list of deprecated technologies in the Data Access Road Map.  Both Ken and Bryant blogged about it, and I just wanted to clarify a few things: - This article specifically referrs to SqlXml in MDAC.  That`s the SqlXmlx.dll file that provides nifty things like Templates and Updategams through SqlOleDB directly.  This is actually a fairly old (1.0+) version of our code. - SqlXml will be removed from future versions of MDAC, as in MDAC > 2.X.  SqlXml still provies its own OleDb provider that can be used with MDAC or SQLNCLI (in Sql Server 2005).  We will remain in the 2.X line. - Notification Services has a dependency on SqlX......

9 of 24 | SqlXml / MDAC Clarification - Apparently there`s been a bit of confusion out there lately about the list of deprecated technologies in the Data Access Road Map.  Both Ken and Bryant blogged about it, and I just wanted to clarify a few things: - This article specifically referrs to SqlXml in MDAC.  That`s the SqlXmlx.dll file that provides nifty things like Templates and Updategams through SqlOleDB directly.  This is actually a fairly old (1.0+) version of our code. - SqlXml will be removed from future versions of MDAC, as in MDAC > 2.X.  SqlXml still provies its own OleDb provider that can be used with MDAC or SQLNCLI (in Sql Server 2005).  We will remain in the 2.X line. - Notification Services has a dependency on SqlX......

10 of 24 | Xml Team is back! - Well, we`re all back from the holidays here, spinning up again, looking forward to kicking out Yukon Beta 3 and Whidbey Beta 2.  As I promised, changes are coming after the new year.   The Xml Team blog should replace this one in the next day or two.  In the mean time, go check it out here.  I`m also going to add all of our indiviual blogs as links to the XmlTeam blog for a one-stop shop for finding all of your friendly neighborhood XML team members. ...

11 of 24 | Xml Team is back! - Well, we`re all back from the holidays here, spinning up again, looking forward to kicking out Yukon Beta 3 and Whidbey Beta 2.  As I promised, changes are coming after the new year.   The Xml Team blog should replace this one in the next day or two.  In the mean time, go check it out here.  I`m also going to add all of our indiviual blogs as links to the XmlTeam blog for a one-stop shop for finding all of your friendly neighborhood XML team members. ...

12 of 24 | Site Change - New Year, New Blog - Tomorrow, hopefully, you`ll all notice some changes to the blog here on the MSDN XML Dev Center.  No, I`m not leaving, I promise.  However, the blog here is being changed to move to a new blog - the XmlTeam blog.  This blog will have contributions from various members of the XML team.  My hope is that with more folks contributing you`ll see more frequent posts and a bigger variety of posts.  You can see the new blog now up at http://blogs.msdn.com/XmlTeam .  ...

13 of 24 | Site Change - New Year, New Blog - Tomorrow, hopefully, you`ll all notice some changes to the blog here on the MSDN XML Dev Center.  No, I`m not leaving, I promise.  However, the blog here is being changed to move to a new blog - the XmlTeam blog.  This blog will have contributions from various members of the XML team.  My hope is that with more folks contributing you`ll see more frequent posts and a bigger variety of posts.  You can see the new blog now up at http://blogs.msdn.com/XmlTeam .  ...

14 of 24 | He`s Back Folks! - I know everyone missed me the last two weeks, but rest assured, I`m back and on top of things.  Thanks to all those who were patient in waiting for a response from me.  I was bouncing around the East for two weeks in Bermuda and New Jersey, loving every minute of it.  Of course, now I`m back in bright, sunny Seattle.  Well, I`m back in Seattle at least. Coming Up I know articles have been a bit slow lately, mostly from folks out on vacation.  End of November to the end of December is always a bit of a slow down around here as everyone heads out for the holidays.  Fear not though, we`ve got a few in the pipe: Venkat Prasad writes a piece on Exchanging XML data with SQL Server 2000 and Repor......

15 of 24 | He`s Back Folks! - I know everyone missed me the last two weeks, but rest assured, I`m back and on top of things.  Thanks to all those who were patient in waiting for a response from me.  I was bouncing around the East for two weeks in Bermuda and New Jersey, loving every minute of it.  Of course, now I`m back in bright, sunny Seattle.  Well, I`m back in Seattle at least. Coming Up I know articles have been a bit slow lately, mostly from folks out on vacation.  End of November to the end of December is always a bit of a slow down around here as everyone heads out for the holidays.  Fear not though, we`ve got a few in the pipe: Venkat Prasad writes a piece on Exchanging XML data with SQL Server 2000 and Repor......

16 of 24 | Praise XML! - Read through my RSS items, I found a reference to this post about "The Church of XML".  Seems like someone`s been burned by this stuff a bit, huh  While the article is a obviously dripping with sarcasm, I actually thought it was a pretty funny read that, at the center, may actually have a few grains of truth.  Here`s what I seemed to get out of it (putting a little more positive spin on things): XML is here to stay and you`re probably (eh, definitely) going to have to deal with it Just because XML is here doesn`t mean you have to use it; there are times, many of them, when it isn`t needed The first point is something we all need to accept now and move on.  Our group has recently begun our......

17 of 24 | Praise XML! - Read through my RSS items, I found a reference to this post about "The Church of XML".  Seems like someone`s been burned by this stuff a bit, huh?  While the article is a obviously dripping with sarcasm, I actually thought it was a pretty funny read that, at the center, may actually have a few grains of truth.  Here`s what I seemed to get out of it (putting a little more positive spin on things): XML is here to stay and you`re probably (eh, definitely) going to have to deal with it Just because XML is here doesn`t mean you have to use it; there are times, many of them, when it isn`t needed The first point is something we all need to accept now and move on.  Our group has recently begun ou......

18 of 24 | First Post (redux) - Redux  Yes, that seems to be appropriate.  I think I`ve done 2 or 3 of these "first post" entries now, but a new endeavor calls for a new First Post for what I`m sure will become the millions of my fans out there. So here we go... Welcome to my blog!  My name is Irwin Dolobowsky and I`ve been a Program Manager at Microsoft for 3.5 years now, all within the XML group.  After interning at Microsoft in 2000, I came back to work on SqlXml, which I`ve owned since about month two of my employment.  Since then I`ve also had the opportunity to work on various technologies here, including System.Xml and the SOAP Toolkit.  My latest gig is this place - I`ve now taken ownership of the MSDN XML Develop......

19 of 24 | First Post (redux) - Redux?  Yes, that seems to be appropriate.  I think I`ve done 2 or 3 of these "first post" entries now, but a new endeavor calls for a new First Post for what I`m sure will become the millions of my fans out there. So here we go... Welcome to my blog!  My name is Irwin Dolobowsky and I`ve been a Program Manager at Microsoft for 3.5 years now, all within the XML group.  After interning at Microsoft in 2000, I came back to work on SqlXml, which I`ve owned since about month two of my employment.  Since then I`ve also had the opportunity to work on various technologies here, including System.Xml and the SOAP Toolkit.  My latest gig is this place - I`ve now taken ownership of the MSDN XML Develo......

20 of 24 | SqlXml 3.0 SP3 Now Available! - SqlXml 3.0 SP3 has just been released and is now availalbe for download from http://www.microsoft.com/downloads/details.aspx?FamilyId=51D4A154-8E23-47D2-A033-764259CFB53B&displaylang=en.    This release includes bug fixes and QFE rollups, as well as the removal of SqlXml`s dependency on the SOAP Toolkit.  Users no longer have to install the SOAP Toolkit to enable SqlXml Web Services functionallity.  This also simplifies the installion process on Windows Server 2003, on which the SOAP Toolkit was not supported.  This removes barriers our customers have toward upgrading their servers to Windows Server 2003.   Thanks, and spread the word!   Irwin...

21 of 24 | SqlXml 3.0 SP3 Now Available! - SqlXml 3.0 SP3 has just been released and is now availalbe for download from http://www.microsoft.com/downloads/details.aspxFamilyId=51D4A154-8E23-47D2-A033-764259CFB53B&displaylang=en.    This release includes bug fixes and QFE rollups, as well as the removal of SqlXml`s dependency on the SOAP Toolkit.  Users no longer have to install the SOAP Toolkit to enable SqlXml Web Services functionallity.  This also simplifies the installion process on Windows Server 2003, on which the SOAP Toolkit was not supported.  This removes barriers our customers have toward upgrading their servers to Windows Server 2003.   Thanks, and spread the word!   Irwin...

22 of 24 | Still Here, New Beginnings - Yes, for my faithful readers, I am still here.  It has been quite some time since I last posted, but I hope to make these much more frequently again.  Curious what I`ve been working on?  Well... SqlXml 3.0 SP3 - We`re fixing issues with SqlXml running on Windows Server 2003, including removing our dependency on the SOAP Toolkit.  This should be out this week. SqlXml in Sql Server 2005 - Still working on that.  As anyone who grabbed Beta 2 saw, we`re there! Now to finish nailing that down. SqlXml Long Term - We had planned on a new mapping stack in Whidbey, but that was cut due to varying circumstances. However, there are those of us who still believe greatly in a mapping technology as well......

23 of 24 | Chat with us now! - Sorry, got this rather late, but for anyone interested, the System.Xml team be on for the next hour or so: Title: C# and XML Use XML? Use C#? Have some questions, comments, or just want listen to people talk about your favorite technologies? Join members of the C# team and Dare Obasanjo http://blogs.msdn.com/DareObasanjo/> of the XML/Data team for a discussion about C# and XML. Chat room: http://communities2.microsoft.com/home/chatroom.aspx?siteid=34000014 ...

24 of 24 | Two New Articles - Bulkload in .Net and FOR XML in SQL Server 2005 - There are a few new SqlXml-related articles up on MSDN. First we have Amar Nalla`s XML to SQL: Using SQLXML Bulkload in the .NET Framework which gives great examples on constructing annotated schemas and using Bulkload within .Net.  Amar goes into great detail on how to feed Bulkload with a stream, a process that takes some work when going from .Net through managed interop to Bulkload.  If you`re using Bulkload within .Net check it out, its a great article and well worth your time to read. A little bit older is Michael Rys`s article What`s New in FOR XML in Microsoft SQL Server 2005 which discusses enhancements to the FOR XML extensions to T-SQL offered by SQL Server.  I`ve played with the ......