Welcome to MSDN Blogs Sign in | Join | Help

June 2006 - Posts

Friday, June 30, 2006 6:12 AM

SYSK 148: Format My Code, Please!

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
Posted by irenak | 1 Comments
Thursday, June 29, 2006 6:38 AM

SYSK 147: On the Importance of Script Closing Tags

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 (at least in
Posted by irenak | 1 Comments
Wednesday, June 28, 2006 8:01 AM

SYSK 146: SMTP – More Configuration, Less Code

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 also
Posted by irenak | 2 Comments
Tuesday, June 27, 2006 4:40 AM

SYSK 145: Preventing Configuration Setting Inheritance in Web Apps

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.com/en-us/library/ms178685.aspx
Posted by irenak | 2 Comments
Monday, June 26, 2006 4:54 AM

SYSK 144: A Faster Way to Get a Total Number of Rows in a Table

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 way to do the
Posted by irenak | 8 Comments
Filed under:
Friday, June 23, 2006 4:46 AM

SYSK 143: Async Invocation of Stored Procs from SQL

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
Posted by irenak | 0 Comments
Filed under:
Thursday, June 22, 2006 5:00 AM

SYSK 142: Method Inlining

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
Posted by irenak | 0 Comments
Wednesday, June 21, 2006 6:35 AM

SYSK 141: RTFEditor Control

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.
Posted by irenak | 0 Comments
Attachment(s): RTFEditor.zip
Tuesday, June 20, 2006 5:36 AM

SYSK 140: Ranking Functions in SQL 2005

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 ORDER BY
Posted by irenak | 0 Comments
Filed under:
Monday, June 19, 2006 4:43 AM

SYSK 139: Multiple Environments Support by a ClickOnce Application

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
Posted by irenak | 3 Comments
Friday, June 02, 2006 7:18 AM

Will be back June 19th

Folks, I'm going on vacation and will not have Internet access. I will resume publishing the SYSK posts on June 19th.
Posted by irenak | 1 Comments
Thursday, June 01, 2006 5:00 AM

SYSK 138: Still Using text, ntext, and image data types? Then this post is for you…

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
Posted by irenak | 0 Comments
Filed under:
 
Page view tracker