Sushil's WebLog

After a long hiatus, let me start with how the new XML data type in SQL Server 2005 is exposed via ADO.Net 2.0. I will discuss this new data type in following parts: XML data type in SQL Server 2005 – A brief Introduction : You can consider...

There are situation in real world; when you dont want to write code, dependent on just one of the managed provider. This also helps to easily move from using one provider to another if the code design changes in the future. Pre-Whidbey, the only way to...

Continuing with the discussion on enumeration, I will go over ways to enumerate active SQL servers on the network in this blog. Pre-Whidbey, to get list of active servers on the network, we could have done Inter-Op calls to server enumeration APIs in...

In this section we will look at ways ADO.Net v2.0 (Code named 'Whidbey') allows us to insert/delete/update Xml data values in a table containing Xml column in SQL Server 2005 (Code named 'Yukon'). With earlier versions of the .Net Framework (1.0 and 1...

After a brief hiatus, let me start with blogging the new Notification support in SqlClient MP that is introduced in Whidbey. There are scenarios in which an application would store a cache of data obtain from a DB Server and then re-query from the same...

Inspired by my colleagues here, I have taken into blogging. I had wanted to do it for a long time now. With the beta release 2.0 version of the Microsoft .Net framework (code named 'Whidbey'), its a opportune moment to blog on some of the exciting features...

I have been wanting to post for a long time now, and have finally decided to FIGHT my slackness. I will continue with my views on some of the new features in ADO.Net for Whidbey. I will start with talking about a new feature in Whidbey - Provider Enumeration...

With good things said about Notification in my previous blog, I will like to take a step further to walk you through some common issues in setting up this feature. We would need to undestand how notifications internally work to track some of these issues...

I am here at PDC05, LA represeting the SQL Server team as part of staffing the product pavillion. There is just one word to sum up the level of excitment/ enthusiasm that I feel in the air - WOW! And I have been told that its just starting, with more...

I just posted a blog on our team webpage on the changes in new SqlDependency feature from Beta 2 to RTM. There have been a lot of changes since we shipped in Beta 2. Do let us know what you think of the new changes. We are looking forward to hear about...

Yes, we have done it! SQL Server 2005 and Visual Studio 2005 are now released to manufacturing. What this means that we are done with both the products, you can even download the official bits if you have MSDN subscription. More information can be found...

Its me again after 4 long year. I have decided to start blogging agian. From the last time I wrote in 2005, there have been multitude of things I have been working. I was working on JDBC driver for SQL Server in 2005-06 and then moved to Entity Framework...

The team in which I work is called DataWorks. I am excited to announce that we as a team have our own Web Log at http://blogs.msdn.com/dataaccess . Check out the message from our PUM (Product Unit Manager) - Alyssa. Via this blog, we look forward to get...

Do you want to know more about ConnectionStringBuilder feature in ADO.Net v2.0? If yes, then look up our team site where I posted a short introduction.

In the earlier sections, we have been looking at Untyped XML which are different from Typed XML. Typed XML data type is an XML defined with an associated xml schema in Sql Server 2005. You may ask if there is anything different on how Typed XML are exposed...

I happened to go to one of the class from a mentoring company. It was presented by Bob Beauchemin-Niels Berglund-Dan Sullivan. Boy! they were great! I was just in time for the ADO.Net presentation that Bob made. He talked about top 3 features that he...