Data Access blog

(this blog is now in suspended animation - please update your bookmarks!)

Quick update re: Data Access blog.

We're putting this blog (Data Access blog) into suspended animation. That doesn't mean we will stop...

Author: MSDN Archive Date: 07/11/2006

ADO.NET and SQL Server Everywhere

Steve Lasker has posted a screencast / video over on Channel 9 providing an overview on the various...

Author: MSDN Archive Date: 07/07/2006

What I Wish Developers Knew About 'x' in / for SQL Server 2005 (webcasts)

Database Journal has a good list of some upcoming SQL Server related live webcasts scheduled for...

Author: MSDN Archive Date: 06/28/2006

ADO.NET vNext - feedback so far

Since announcing our ADO.NET vNext plans at TechEd last week, the team has been on the lookout for...

Author: MSDN Archive Date: 06/24/2006

ADO.NET vNext screencast

Hi - I'm Shyam Pather, Development Lead on the ADO.NET vNext team. I’m incredibly excited to share...

Author: dpblogs Date: 06/21/2006

ADO.NET vNext: The Entity Framework, LINQ and more

Once you are done with shipping large products such as SQL Server 2005 and Visual Studio 2005 you’d...

Author: dpblogs Date: 06/20/2006

Lightweight Promotable Transactions, SqlDataReader and Commitment.

Here's a small issue you may need to watch out for when using a System.Transactions transaction with...

Author: MSDN Archive Date: 04/14/2006

Data Access with Visual Basic 2005 (Webcast)

Register to watch this: MSDN Webcast: Data Access with Visual Basic 2005 (Level 200) Start Time:...

Author: MSDN Archive Date: 04/12/2006

We love customers like David Hayden!

We love customers like David Hayden! David has been spending time at the MSDN Forums (in particular...

Author: MSDN Archive Date: 03/29/2006

Adding nesting options to DbConnectionScope.

I managed to squeeze in enough time to implement nesting options for the DbConnectionScope class. My...

Author: MSDN Archive Date: 03/29/2006

ADO.NET Versions and Indexing

Julia Lerman over at DevSource posted this quick article: "Someone asked me about ADO.NET indexing...

Author: MSDN Archive Date: 03/17/2006

Fun Hash Joins with VB9 LINQ

Brian Beckman is a Software Architect in the Data Programmability team here at Microsoft. His latest...

Author: MSDN Archive Date: 03/16/2006

Developers! - Express contest - win $10K

A new worldwide contest for developers has been launched by the folks at Visual Studio Express and...

Author: MSDN Archive Date: 03/14/2006

An Introduction to Data Structures

In November 2003 MSDN Online published a popular six-part series on using data structures in the...

Author: MSDN Archive Date: 03/13/2006

Conversation with scientist, engineer and database legend Jim Gray

Channel 9 has posted great video interview with Jim Gray, a researcher and manager of Microsoft...

Author: MSDN Archive Date: 03/09/2006

10 Mistakes Developers Make With Databases

A new article published at Developer.com is worth checking out: Ten of the Biggest Mistakes...

Author: MSDN Archive Date: 03/06/2006

Data Binding in ASP.NET 2.0

Jesse Liberty has written up a good article showing how to bind data into ASP.NET control over at...

Author: MSDN Archive Date: 03/04/2006

.NET Rocks! - LINQ with Barry Gervin

Over at .Net Rocks!, Regional Director Barry Gervin introduces LINQ, a nascent set of language...

Author: MSDN Archive Date: 02/17/2006

A ConnectionScope class. [Alazel Acheson]

I’ve heard a few comments from people who would like an easier way to manage connection lifetime...

Author: MSDN Archive Date: 02/14/2006

Getting Schema in ADO.Net 2.0

Carl Perry, a Program Manager from our ADO.Net team has blogged about how to use and extend the new...

Author: MSDN Archive Date: 02/12/2006

Shawn Wildermuth on Decomposing ADO.NET

The .NET Rocks! Show had Shawn Wilderman as their guest last week. Shawn is the Microsoft C# MVP who...

Author: MSDN Archive Date: 01/29/2006

WinFS and peer-to-peer

Mark Scurrell, Program Manager on the WinFS Sync team has provided an overview on the WinFS blog of...

Author: MSDN Archive Date: 01/27/2006

Impersonation inside SQLCLR Stored Procedure [Jian Zeng]

In SQL Server 2005, we now have the ability to write managed (or CLR) code inside a Stored...

Author: MSDN Archive Date: 01/25/2006

Microsoft SQL Server 2005 JDBC Driver -- RTW [Shelby Goerlitz]

After two betas and 6 months of customer feedback the SQL Server 2005 JDBC Driver is generally...

Author: MSDN Archive Date: 01/23/2006

PDC 05 demos - Query Processing over DataSet, Fast Uploads, Caching

First of all I’ll have to apologize because it took me several months to put this code out here....

Author: MSDN Archive Date: 01/09/2006

ADO.Net 2.0: Relative paths in ConnectionString [Sushil Chordia]

In SqlClient Managed Provider, there has always existed (right from ADO.Net 1.0 days) a keyword in...

Author: MSDN Archive Date: 10/28/2005

SqlDependency changes for RTM [Sushil Chordia]

As mentioned in my previous blog, SqlDependency is a new feature in .Net framework 2.0, which...

Author: MSDN Archive Date: 09/27/2005

Introduction to SQL 2005 Native XML Web Services (SOAP)

The Native XML Web Services (SOAP) being a new feature in SQL 2005, I like to provide a brief...

Author: MSDN Archive Date: 08/30/2005

Getting the MARS Sample working in the June CTP

Multiple Active Result Sets (MARS) is a cool new feature in SQL Server 2005 which allows you to...

Author: MSDN Archive Date: 08/29/2005

SSL in SQL Server 2005 [Il-Sung Lee]

I often receive questions inquiring about the (channel) encryption capabilities in SQL Server 2005....

Author: MSDN Archive Date: 08/05/2005

Using MARS with SQL Native Client [Chris Lee]

As stated in my previous post, the majority of new features available through SQL Native Client are...

Author: MSDN Archive Date: 08/02/2005

Getting started with SQL Native Client [Chris Lee]

As Acey Bunch explained in April, SQL Native Client meets the needs of developers wanting to take...

Author: MSDN Archive Date: 07/29/2005

Win the Ultimate Chopper!

Share your story of migrating from Oracle to SQL Server, and the ultimate chopper might just migrate...

Author: MSDN Archive Date: 07/01/2005

Exceptions in ADO.Net 2.0 [Siraj Lala]

I’d like to briefly talk about some of the work we have done in ADO.NET 2.0, for improvement of...

Author: MSDN Archive Date: 06/09/2005

Dataworks team at TechEd 2005

How many of you are coming to TechEd 2005 in Orlando? A show of hands, please. Excellent! The...

Author: MSDN Archive Date: 06/03/2005

Announcing the MDAC 2.8 sp1 Redistributable [Brad Rhodes]

We have shipped MDAC 2.8 sp1. This is the version of MDAC that originally shipped with Windows XP...

Author: MSDN Archive Date: 05/19/2005

Does ADO.NET update batching really do something?

I’ve gotten this same question several times in the last few weeks, so I thought it would be a good...

Author: MSDN Archive Date: 05/19/2005

Introducing SQL Native Client

By now you may have heard of a new data access technology called “SQL Native Client” that will ship...

Author: MSDN Archive Date: 04/26/2005

.Net Framework 2005 (aka Whidbey) Beta2 Shipped! [Carl Perry]

At long last we’ve completed and signed-off on Whidbey Beta 2!!!!! It’s been quite a long time since...

Author: MSDN Archive Date: 04/19/2005

API Changes between CTP [Pablo Castro]

We’ve been seeing several comments on email and blogs lately about changes in the APIs between CTP...

Author: MSDN Archive Date: 04/05/2005

Primer to ConnectionStringBuilder in ADO.Net v2.0 [Sushil Chordia]

We had got good amount of feedback from developers in 1.0 and 1.1 versions for need to have a...

Author: MSDN Archive Date: 03/30/2005

Unification of System.Data.SqlClient and System.Data.SqlServer [Pablo Castro]

Many of us would like to have a space to write about the stuff we do, publish open issues for...

Author: MSDN Archive Date: 03/22/2005

Welcome!

Welcome to the DataWorks team blog. If you’re a regular on our MSDN site...

Author: MSDN Archive Date: 03/20/2005