I ran some tests using ADO.NET to measure the time it takes to retrieve a single value from a database. All of my tests had the following attributes: Each test gets the CompanyName for the specified CustomerID (in Northwind) The same connection string, using integrated security Stored procedure (vs inline SQL) I used a SqlCommand with a...

I've always wanted to write. I love Tolkien's LOTR, Shakespeare (MacBeth is my favorite ... yeah, I know its dark, but it really grabbed me), Chaucer's Canterbury Tales, Beowulf (very cool monsters), and Homer's the Illiad (The Odyssey is just alright). I knew I was never going to be at that level, and with my career choice being what it is,...

I’ve been getting my slides and code samples together over the past few weeks for the upcoming conferences. The next one I’ll be at is at the end of this month in Boston at VSLive talking about transactions. The session is titled Lightweight Promotable Transactions using System Transactions and ADO.NET 2 and is at 2pm on June 30th. Below is...

I’ll be at VSLive in Boston at the end of this month demonstrating coding techniques with ADO.NET 2, so please drop by and say hi if you get a chance. The session is titled Get Ready for ADO.NET 2 and is at 5:45pm on June 29th. Below is the synopsis of the session … and the agenda from my slide deck:   Get Ready for ADO.NET 2 Data...

I’ve been getting my slides and code samples together over the past few weeks for the upcoming conferences. The next one I’ll be at is at the end of this month in Boston at VSLive talking about transactions. The session is titled Lightweight Promotable Transactions using System Transactions and ADO.NET 2 and is at 2pm on June 30th...

As I posted last week, I got up a new iPod mini for running and light soccer drills. It was a very nice birthday / father’s day gift from my family. I bought myself some of the Etymotic Research ER6i Isolator Earphones that Sahil and Brendan both recommended. They are excellent and quite comfortable. I don’t push them...

As I posted last week, I got up a new iPod mini for running and light soccer drills. It was a very nice birthday / father’s day gift from my family. I bought myself some of the Etymotic Research ER6i Isolator Earphones that Sahil and Brendan both recommended. They are excellent and quite comfortable. I don’t push them...

As I posted last week, I got up a new iPod mini for running and light soccer drills. It was a very nice birthday / father’s day gift from my family. I bought myself some of the Etymotic Research ER6i Isolator Earphones that Sahil and Brendan both recommended. They are excellent and quite comfortable. I don’t push them all the...

The July 2005 issue of MSDN Magazine is now available online. The amount of discussion that has surrounded the Enterprise Library and its Application Blocks (good, bad and indifferent) has been tremendous. I decided to create a 3 part series that explores the Enterprise Library Data Access blocks in my Data Points column. In this issue I...

OK, so I pick up a new iPod mini for running and light soccer drills. (I’ll review how it holds up after some time with it) The headphones are not so good so I get myself some of the Etymotic Research ER6i Isolator Earphones that Sahil and Brendan both recommended these as well). I got the headphones for $81 at buy.com which is also...

The Finalizer was revealed today at Tech Ed. You can check out this BattleBot that runs on .NET code at the new web site. New content is still being added including videos and an official case study.

At today's Tech-Ed keynote address in Orlando, Microsoft Vice President Paul Flessner announced that Visual Studio.NET 2005 will "launch internationally the week of November 7th". He also stated that SQL Server 2005 and BizTalk 2006 will be launched that week, too.   I imagine the official launch site will be updated soon,...

OK, so this isn’t rocket science, but then again some of the best things are the simplest. You can do a lot with the information_schema views in SQL Server. Here is a short stored procedure that you can use to find: a table by its full name a table by partial name a column by its full name a column by its partial name  It comes in handy...

Pablo Castro, Microsoft's Program Manager of the ADO.NET Team, has a good post last week that helps clarify how bath updates are intended to work in ADO.NET 2. This is a common discussion that I am drawn into since the DataAdapter actually invokes its command for each modified row in the DataTable that it is associated with. Thus if you have a...

As I mentioned in a blog last week, I downloaded two refactoring tools: .NET Refactor and ReSharper. I had some really horrible experiences with refactoring tools in the past, so I was a bit skeptical going in. It has been a week so here are a few more thoughts about the tools. While .NET Refactor has some nice features, like the how...