But in my job I have to wear the DBA hat quite often. I was having a problem today where a query that returns 200 rows was taking 16 seconds to return to my application. The same query run in Query Analyzer came back in .47 seconds. Huh? One of my co-workers suggested that I run a stored procedure "sp_updateStats...

I'm off tomorrow to the VS 2005 Launch Event in Atlanta! I've got a buddy that would like to go, but registration's closed. Does anyone have a ticket that they're not going to use? I haven't had much time to delve into VS 2005 yet, so I'm really looking forward to the presentations!

I was illustrating TextBox Extender component that I had developed that automatically validates any TextBox on a form. I enterd "123" the TextBox and all was right with the world. I added ".-" in an attempt to make it non-numeric, when I got an application exception. Investigation revealed the following...

I've wanted to use tracing for awhile and was inspired by Kevin Blakely's Post on ASP .NET Tracing in a popup window . I didn't want the tracing in the popup window--just wanted to move it down the page below my other controls. So, I borrowed Kevin's code and modified it as follows: var defaultHeight...

A co-worker and I were having an argument this morning about the best way to databind to an ASP .NET datagrid control. The argument centered around whether to use the declarative server-tag syntax in the aspx file (e.g., <%# Container.DataItem("Name") %> ) or doing it programmatically in the code...

Matt Berther is doing something similar to what I was talking about in my previous post . Where we differ is where to do the validation of the business rules. He's wrapping his IMyView in a class that knows how to perform the Business Rule validation. I didn't discuss my validation method in my last...

I've recently begun using Test Driven Development as my method for developing and maintaining applications. A worry I had early on was that I have inherited several poorly designed ASP .NET applications (read "poorly designed" as "not designed") and that it would be difficult to use TDD in that environment...

I think I've found a failure in the Regular Expression validator for ASP .NET. If you choose US Zipcode from the validation expression list, it gives you the following expression: \d{5}(-\d{4})? The problem is that the expression passes "2961534" as a valid zipcode. The fix is extremely simple--simply...

I'm feeling a little overawed by the task that's before me right now. I have until the end of the month to develop two installation projects for our ASP.NET/SQL SERVER software, one as an upgrade, and the other for a fresh installation. I've been given the InstallShield Pro package to do this with. Aside...

So here's a question: Has anyone successfully been able to develop a .NET assembly that can be shared between multiple Compact Framework applications. Further, has anyone been able to write a .NET assembly that could be shared between a mobile device and a desktop application?