Browse by Tags

• ASP.Net
• C#
• General Programming
• Miscellaneous
• SQL Server

• A better, more manageable DataReader

  I had mentioned to the Plano DNUG when I presented a while back that I didn't like the idea of passing back a DataReader at all from a DAL. You lose control of what happens to it when you do (as in the DAL no longer has the responsibility of closing the Read More... Posted Monday, September 20, 2004 8:57 AM by dpenton | 87 Comments Filed under: General Programming, SQL Server, ASP.Net, C#

• Not-so Dynamic Sql

  Suppose you need to exclude or include parameters to a sql statement. Let's take this example: CREATE PROCEDURE dbo.myProc @pkA int , @pkB varchar(10) , @pkC decimal(12, 2) AS SELECT t .colA, t .colB, t .colC FROM dbo.myTable t WHERE t.pkA = @pkA AND Read More... Posted Wednesday, September 08, 2004 2:02 PM by dpenton | 56 Comments Filed under: SQL Server

• More on Interfaces and ADO.Net

  I spoke at the Plano DNUG last night and had a pretty good time. Basically I presented some information on interfaces, talked about the interfaces in System.Data, discussed what happens behind the scenes with SqlConnection.Close() and SqlConnection.Dispose(), Read More... Posted Thursday, June 03, 2004 10:28 AM by dpenton | 91 Comments Filed under: General Programming, SQL Server, C#

• More on inserting XML to SQL Server

  First off....I know I badly need to blog more. Life just keeps running me over (enough of the excuses). My friend Steve Schofield wanted me to blog more on inserting XML into SQL Server. So, I am going to post a number of things. All that actually work Read More... Posted Thursday, April 15, 2004 12:48 AM by dpenton | 46 Comments Filed under: SQL Server

• 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

• Security Warning

  Something I was reading on a list I am on made me think of security. Periodically I do searches on Google to see how secure some sites are designed. I won't put my actual search here, but if you search for specific parts of connection strings you may Read More... Posted Monday, February 23, 2004 8:59 AM by dpenton | 50 Comments Filed under: General Programming, SQL Server, ASP.Net

• The Axiomatic Method

  So, I have started blogging. I had been thinking about how and what I would start this off. It occured to me that I should talk about something that I had learned throughout my life but never knew the name of until college. Even after that, I wasn't sure Read More... Posted Monday, February 23, 2004 8:17 AM by dpenton | 45 Comments Filed under: General Programming