March 2004 - Posts

• SQLXML: Steps to usage

  Every once in a while people post to the lists that I am on ( AspAdvice , SSWUG , 15seconds , VISBAS-L ) asking about how to pass lists of data into stored procedures. There are a number of ways to accomplish this, some of which include (but not limited Read More... Posted Monday, March 22, 2004 9:43 AM by dpenton | 59 Comments Filed under: SQL Server

• "My eBooks" folder: Die!

  In case anyone *hates* the "My eBooks" folder that gets created in "My Documents" when Adobe Acrobat opens, here is the *fix*: http://www.annoyances.org/exec/forum/winxp/n1072006739 My...that thing was annoying! Share this post: email it! | bookmark it! Read More... Posted Thursday, March 18, 2004 7:43 AM by dpenton | 64 Comments Filed under: Miscellaneous

• More on Interfaces for System.Data

  Aaron blogged about interfaces and asked about people usage. I have been using them more and more in code. Here are some examples of closing and disposing of System.Data (and Microsoft.Data) resources using interfaces: static void DisposeIDbDataAdapter(ref Read More... Posted Tuesday, March 16, 2004 2:09 PM by dpenton | 326 Comments Filed under: General Programming, SQL Server, ASP.Net, C#

• SQL Server 2000 System Table Map

  I thought it would be worth mentioning again that there is a compiled help file called “SQL Server 2000 System Table Map” which is right here . I believe it to be a very valuable documentation tool for the database administrator, as well as Read More... Posted Tuesday, March 16, 2004 8:56 AM by dpenton | 67 Comments Filed under: SQL Server