AppDev: Something You Should Know by Irena Kennedy
Everything that is related to application development, and other cool stuff...
SYSK 174: What Does Stand-By Mode Have To Do With Display Device Driver?
As I found out, a lot! This is one of those things that you might not think about, but that makes a...
Author: irenake Date: 08/09/2006
SYSK 173: Rediscovering the Immediate Window
Many developers that started their programming carriers with Visual Basic have quickly come to...
Author: irenake Date: 08/08/2006
SYSK 172: C# 3.0 is Not Part of .NET 3.0
.NET 3.0 will be released with Vista. It will not contain C# 3.0, but will ship with C# 2.0. The...
Author: irenake Date: 08/07/2006
SYSK 171: MSDE Will Not Be Supported on Vista
Yes, it is true – Microsoft SQL Server 2000 Desktop Engine (MSDE) will not be supported on Windows...
Author: irenake Date: 08/04/2006
SYSK 170: Under the Hood of SQL System Objects
Want to know what’s inside sp_help stored proc? How about TABLE_PRIVILEGES view? All the system...
Author: irenake Date: 08/03/2006
SYSK 169: Quick Access to SPS 2007 Mobile View
Did you know that by typing http://servername/m you will be automatically redirected to...
Author: irenake Date: 08/02/2006
SYSK 168: Why Developers Should Know About Memory Bandwidth?
Similarly to a network bandwith, memory bandwidth is the amount of data per second that can be read...
Author: irenake Date: 08/01/2006
SYSK 167: “A program is trying to access your Address Book…”
After installing Adobe Acrobat, I, like many others, started getting “A program is trying to access...
Author: irenake Date: 07/31/2006
SYSK 166: Stream Output Performance Comparison
If you need to write a large number of data items (e.g. records with many fields) to a stream, do...
Author: irenake Date: 07/28/2006
SYSK 165: Are You Encrypting Your Stored Procedures?
If you’re concerned about unauthorized users looking at the business logic implemented in SQL stored...
Author: irenake Date: 07/27/2006
SYSK 164: ASP.NET ProfileModule Undercover
ProfileModule class is a new class available for ASP.NET 2.0 developers to create and manage user...
Author: irenake Date: 07/26/2006
SYSK 163: New Way to Reduce the Number of Unhandled Exceptions
Except for ThreadAbortException and AppDomainUnloadedException exceptions, all other unhandled...
Author: irenake Date: 07/25/2006
SYSK 162: P/Invoke Required. Or Is It?
This is one of those examples when not being able to see the publication timestamp can lead you to...
Author: irenake Date: 07/24/2006
SYSK 161: SQL – the Pros and Cons of Updating Statistics Asynchronously
As many of you may know, SQL Server 2005 provides a way to update statistics asynchronously. To my...
Author: irenake Date: 07/21/2006
SYSK 160: Implementing Session Expiration Concept in WinForms
If you’re writing an application that displays sensitive data (i.e. must be very secure), or you’re...
Author: irenake Date: 07/20/2006
SYSK 159: How to Clear ClickOnce Application Cache
ClickOnce installed apps are hidden deep under \Document and Settings\UserName\ \Local...
Author: irenake Date: 07/19/2006
SYSK 158: IComparable vs. IEquatable
Both compare objects of types T… So, which should your objects implement? IComparable<T>...
Author: irenake Date: 07/18/2006
SYSK 157: Conditional Methods
One of the less known features in .NET is conditional methods, which allow developers to create...
Author: irenake Date: 07/17/2006
SYSK 156: For Smart Client Developers…
Those of you who have developed smart client applications using Composite User Interface Application...
Author: irenake Date: 07/14/2006
SYSK 155: Don’t Know Much About GAX? Then read on…
If you’re familiar with Enterprise Templates in earlier versions of Visual Studio, GAX may sound...
Author: irenake Date: 07/13/2006
SYSK 154: Adding Existing Classes to a Class Diagram
There is plethora of articles describing how cool is the class diagramming functionality, available...
Author: irenake Date: 07/12/2006
SYSK 153: Leveraging XQuery in SQL Server
When you need to submit multiple values to a SQL stored procedure to execution queries like this –...
Author: irenake Date: 07/11/2006
SYSK 152: Comparison of DoEvents, Sleep and SpinWait
There are several ways to yield processing time. One common method used is to call...
Author: irenake Date: 07/10/2006
SYSK 151: New in SQL 2005 – DAC (dedicated administrator connection)
There are times when SQL Server may be so busy processing requests that it can no longer allocate...
Author: irenake Date: 07/07/2006
SYSK 150: RTF2PlainText
The other day I needed to display an RTF text stored in a database in a SQL Reporting Services...
Author: irenake Date: 07/06/2006
SYSK 149: Performance Analysis of the ‘yield return’ Statement
In the “old days”, if you wanted to expose a way for users of a custom collection class to enumerate...
Author: irenake Date: 07/05/2006
SYSK 148: Format My Code, Please!
Say you inherit from another developer some poorly formatted asp/html/cs/vb code – no tabbing, too...
Author: irenake Date: 06/30/2006
SYSK 147: On the Importance of Script Closing Tags
Are the following two lines semantically different? <script language="javascript"...
Author: irenake Date: 06/29/2006
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...
Author: irenake Date: 06/28/2006
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...
Author: irenake Date: 06/27/2006
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,...
Author: irenake Date: 06/26/2006
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...
Author: irenake Date: 06/23/2006
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...
Author: irenake Date: 06/22/2006
SYSK 141: RTFEditor Control
Need a control that encapsulates an RTFTextBox and an editing toolbar? Here it is – see attached. As...
Author: irenake Date: 06/21/2006
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…...
Author: irenake Date: 06/20/2006
SYSK 139: Multiple Environments Support by a ClickOnce Application
How do you configure an application distributed via ClickOnce technology to treat different...
Author: irenake Date: 06/19/2006
Will be back June 19th
Folks, I'm going on vacation and will not have Internet access. I will resume publishing the SYSK...
Author: irenake Date: 06/02/2006
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...
Author: irenake Date: 06/01/2006
SYSK 137: A Quick Way to Get to System Information Dialog
As you know, Windows System Information dialog shows you the hardware resources, installed...
Author: irenake Date: 05/31/2006
SYSK 136: INSERT SHRED(DelimitedString) INTO TABLE MyTable
In SYSK 131, Bill Wendel shows us how to convert a SQL string representing a boolean (e.g. ‘T’, ‘Y’,...
Author: irenake Date: 05/30/2006
SYSK 135: Hot Key for Windows XP System Properties Dialog
Many of us open Windows Explorer, right mouse button click on My Computer and click on Properties...
Author: irenake Date: 05/26/2006
SYSK 134: Intellisense for SQL Server
Do you want Intellisense in SQL Server Management Studio, Query Analyzer and SQL queries in VS...
Author: irenake Date: 05/25/2006
SYSK 133: Oh, the Mighty OUTPUT Clause!
SQL 2005 now has the new OUTPUT clause – see documentation at...
Author: irenake Date: 05/24/2006
SYSK 132: Loop Performance Comparison -- foreach vs. for
Do you think there is a performance difference between the following two loops? foreach (int x in...
Author: irenake Date: 05/23/2006
SYSK 131: SQL: String to Bit Conversion
Say you want to convert any of the following ‘1’, ‘-1’, ‘true’, ‘t’, ‘True’, ‘t’, ‘Yes’ to bit 1 and...
Author: irenake Date: 05/22/2006
SYSK 130: The Sexy Side of Internationalization in ASP.NET
Yes, let’s admit, internationalization (just as security) has not been the favorite of most...
Author: irenake Date: 05/19/2006
SYSK 129: A Tool Every ASP.NET Developer Should Know
Want to inspect all HTTP Traffic (both, incoming and outgoing data) from your computer? You can see...
Author: irenake Date: 05/18/2006
SYSK 128: Unexpected Behavior in NumericUpDown Control
Did you know that while setting ReadOnly property to True on a NumericUpDown control prohibits the...
Author: irenake Date: 05/17/2006
SYSK 127: ResetBindings To the Rescue!
.NET 2.0 came with a lot of cool (new and improved) controls, one of them is the...
Author: irenake Date: 05/16/2006
SYSK 126: Protect Yourself – Use ‘deployment retail’ Setting
As you know, compiling your web application with <compilation debug=”true”/> in web.config...
Author: irenake Date: 05/15/2006