AppDev: Something You Should Know by Irena Kennedy

Say you inherit from another developer some poorly formatted asp/html/cs/vb code – no tabbing, too many or not enough space lines… you know, the code that’s just hard to read… What do you do? Just press Ctrl+K+D (or click menu Edit->Advanced->Format...

Are the following two lines semantically different? <script language="javascript" type="text/javascript" src="JScript.js"></script> <script language="javascript" type="text/javascript" src="JScript.js" /> As it turns out...

If you’re using SmtpMail class in your projects, you may want to check out a new class in .NET 2.0 -- System.Net.SmtpClient. This class allows you to send messages asynchronously and to receive a notification when the e-mail has been sent. You can...

If you have a website that contains nested ASP.NET web applications, by default, the settings in the root website’s configuration file inherit downward through all of the ASP.NET applications and subdirectories of the site (see http://msdn2.microsoft...

How many times you wanted to know the number of rows in a large table before doing some operations, but had to wait for some time till the usual SELECT COUNT(*) FROM <tablename> returns a result? With SQL 2005, there is an alternate...

If you need to call a stored proc that may take a while, and you don’t want to block on it, your option is to call it asynchronously. In SQL 2005 you can take advantage of the Service Broker… But if you need to do it from SQL 2000, or you just don’t want...

First, what is it? When you make a method call, there is a lot of work that happens to make it happen -- the registers and parameters get written to the stack just before the function call, then the parameters get read from the stack inside the function...

Need a control that encapsulates an RTFTextBox and an editing toolbar? Here it is – see attached. As always, do your own testing… the code is provided as is.

Do you know the difference between ROW_NUMBER and RANK functions? What about NTILE? If not, read on… ROW_NUMBER Returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition. The...

How do you configure an application distributed via ClickOnce technology to treat different environments (e.g. integration, QA, staging, production) as different “versions” and not override each other? In other words, does ClickOnce technology support...

Folks, I'm going on vacation and will not have Internet access. I will resume publishing the SYSK posts on June 19th.

Did you know that SQL 2005 only supports text, ntext, and image data types for backward compatibility purposes? The preferred storage for large data is to use the varchar(max), nvarchar(max), and varbinary(max) data types, where max indicates that the...