Welcome to MSDN Blogs Sign in | Join | Help

July 2006 - Posts

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 your Address Book…” message every time I created a new mail item. Luckily, many people prior to me have come across same issue and provided recommendations
Posted by irenak | 1 Comments

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 you think it’s faster to use multiple stream.Write statements or “batch it” via string.Format and use one stream.Write statement per record? My tests show
Posted by irenak | 3 Comments

SYSK 165: Are You Encrypting Your Stored Procedures?

If you’re concerned about unauthorized users looking at the business logic implemented in SQL stored procs (e.g. deploying database to client computers or using a shared SQL server), this blog is for you. SQL Server can encrypt the following components:
Posted by irenak | 4 Comments

SYSK 164: ASP.NET ProfileModule Undercover

ProfileModule class is a new class available for ASP.NET 2.0 developers to create and manage user specific settings (profile). ProfileModule is an ASP.NET HttpRuntime Module (i.e. class that implements IHttpModule interface). As such, it will be called
Posted by irenak | 0 Comments

SYSK 163: New Way to Reduce the Number of Unhandled Exceptions

Except for ThreadAbortException and AppDomainUnloadedException exceptions, all other unhandled exceptions in .NET 2.0 lead to process termination. Note : this was not the case in earlier version of .NET – e.g. unhandled exceptions that happen on a thread
Posted by irenak | 0 Comments

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 make false conclusions... So, “trust but verify”… Say, you want to secure your application and disallow users from opening network files (or think of your
Posted by irenak | 3 Comments

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 asynchronous ly. To my surprise, searching for “ AUTO_UPDATE_STATISTICS_ASYNC pros cons” on www.live.com and www.google.com resulted in “ We could not find any results…” message…
Posted by irenak | 1 Comments
Filed under:

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 working on an application run by multiple users sharing a windows login (yes, it still happens), you may want to implement a “Session Expiration” concept
Posted by irenak | 3 Comments

SYSK 159: How to Clear ClickOnce Application Cache

ClickOnce installed apps are hidden deep under \Document and Settings\UserName\ \Local Settings\Application Data\CompanyName\ApplicationName_StrongName\ApplicationVersion\... If you want to remove a ClickOnce application, you should use Add/Remove Programs
Posted by irenak | 4 Comments

SYSK 158: IComparable<T> vs. IEquatable<T>

Both compare objects of types T… So, which should your objects implement? IComparable<T> specifies ordering, e.g. less than, equals, greater than. String class implements IComparable<T> interface with its int CompareTo(T objectToCompare) function.
Posted by irenak | 3 Comments

SYSK 157: Conditional Methods

One of the less known features in .NET is conditional methods, which allow developers to create methods whose calls are included or excluded during compilations based on a preprocessing symbol. Say, you want to execute a certain method only under certain
Posted by irenak | 3 Comments

SYSK 156: For Smart Client Developers…

Those of you who have developed smart client applications using Composite User Interface Application Block ( http://msdn.microsoft.com/practices/default.aspx?pull=/library/en-us/dnpag2/html/cab.asp ) will likely agree that the biggest downside to CAB
Posted by irenak | 0 Comments

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 familiar… GAX stands for Guidance Automation Extensions in Visual Studio 2005. GAX toolkit allows architects and developers to create frameworks, components
Posted by irenak | 0 Comments

SYSK 154: Adding Existing Classes to a Class Diagram

There is plethora of articles describing how cool is the class diagramming functionality, available in most (Standard and up) editions of Visual Studio 2005. “The Visual Studio Class Designer lets you visualize the structure of classes and other types,
Posted by irenak | 0 Comments

SYSK 153: Leveraging XQuery in SQL Server

When you need to submit multiple values to a SQL stored procedure to execution queries like this – return xyz info for all products that match these product ids, many of us would use a delimited string, shred it using a custom function, insert the values
Posted by irenak | 1 Comments
Filed under:

SYSK 152: Comparison of DoEvents, Sleep and SpinWait

There are several ways to yield processing time. One common method used is to call Application.DoEvents(); This method processes all Windows messages currently in the message queue. Another frequently used method is to invoke Thread.Sleep(milliseconds)
Posted by irenak | 1 Comments

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 memory or processor resources to even allow an administrator to connect. This was a big issue with SQL Server 2000 but SQL Server 2005 solves this problem
Posted by irenak | 0 Comments
Filed under:

SYSK 150: RTF2PlainText

The other day I needed to display an RTF text stored in a database in a SQL Reporting Services report… After doing some research, the team came to a conclusion that there is no easy way to do that, especially given the time we had left on the project.
Posted by irenak | 8 Comments

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 through the elements of the collection, you had to implement a custom enumerator (e.g. foreach (Car car in cars) { … } ) In .NET 2.0 (C#), there is a
Posted by irenak | 5 Comments
 
Page view tracker