AppDev: Something You Should Know by Irena Kennedy
Everything that is related to application development, and other cool stuff...
SYSK 75: Do You Use Your Computer From Public Places? If Yes, Read This...
With public access points available across town in coffee shops, restaurants, libraries, hotels, and...
Author: irenake Date: 03/03/2006
SYSK 74: Are You Using SecureString Class?
The new System.Security.SecureString type (introduced in .NET 2.0) uses DPAPI to help ensure that...
Author: irenake Date: 03/02/2006
SYSK 73: On the Importance of allowExeDefinition Attribute
When you create an application scoped setting, the allowExeDefinition attribute on the...
Author: irenake Date: 03/01/2006
SYSK 72: Fast Comparison of Dates
It’s well known that comparing variables of DateTime data type, whether in .NET or in SQL, is not...
Author: irenake Date: 02/28/2006
SYSK 71: Dataset Footprint in Memory vs. Remoting Size
A lot of good discussions have been held over the last several years on the remoting size of a...
Author: irenake Date: 02/27/2006
SYSK 70: Where Does the Expression “You’re Fired” Come From?
I’ve been “under the weather” for the last week or so, and ran out of prepared appdev SYSK items, so...
Author: irenake Date: 02/24/2006
SYSK 69: Visual Studio – Controlling Which Files Are Saved At Build Time
Did you know you can modify what gets saved before building? Go to Tools -> Options ->...
Author: irenake Date: 02/23/2006
SYSK 68: Choosing Between T-SQL and .NET Stored Procs
The official recommendation is relatively well known by now, and is stated below: Transact-SQL is...
Author: irenake Date: 02/22/2006
SYSK 67: SQL – Who is Connected and What are They Running?
Want to know who the users that are connected and how many sessions do each of them have? Then use...
Author: irenake Date: 02/21/2006
SYSK 66: .NET 1.1 and 2.0 Handles ASCII Encoding Differently?
My tests show that the answer is Yes… See it for yourself. Create a windows app in VS 2003, add one...
Author: irenake Date: 02/20/2006
SYSK 65: Change to Full Trust Definition in .NET 2.0
Did you know that full trust assemblies now satisfy any code access security demands? In the .NET...
Author: irenake Date: 02/17/2006
SYSK 64: Notes from “Windows Presentation Foundation Under the Hood” talk
The other day, I listened to a "Windows Presentation Foundation Under the Hood" talk by Leonardo...
Author: irenake Date: 02/16/2006
SYSK 63: Vista’s Speech Capabilities
The next version of OS (Vista) will have state-of-the-art speech technology built right in. WinFX...
Author: irenake Date: 02/15/2006
SYSK 62: Jim Allchin's view of what Vista will offer the enterprise
Vista brings to the enterprise much more than just enhanced security. Amongst many features I...
Author: irenake Date: 02/14/2006
SYSK 61: Creating Temporary (not persisted, a.k.a. in-memory) Projects in VS 2005
If you miss the old VB 6.0 (and prior) feature of being able to create a project and not save it to...
Author: irenake Date: 02/13/2006
SYSK 60: How Does SqlBulkCopy Deal with Duplicate Records?
The other day, I was asked the following question “Does the SqlBulkCopy update records if they...
Author: irenake Date: 02/10/2006
SYSK 59: How to Stay Young
Those of you who follow my blog know that I almost never write on topics outside of appdev… But this...
Author: irenake Date: 02/09/2006
SYSK 58: Making Code Line Length Conformance Easy in VS
Many teams agree on the maximum line length that should not be exceeded for code readability....
Author: irenake Date: 02/08/2006
SYSK 57: Handy Undocumented Stored Procs
In case you didn’t know, there are a couple of very cool SQL stored process that allow you to...
Author: irenake Date: 02/07/2006
SYSK 56: A Word on Frameworks (from the lighten up series)
Ok, it’s time to lighten up a bit… and then to think a bit on not such a light topic. Check out this...
Author: irenake Date: 02/06/2006
SYSK 55: Rotate SQL table without any INNER JOIN (narrow to wide table without PIVOT)
If you have a narrow table, e.g. just the following columns -- GroupId, DataId, DataValue...
Author: irenake Date: 02/03/2006
SYSK 54: The New Way to Deal with Apostrophes in SQL
In SQL, you can now use quotename instead of ‘’’’… So, if you need to pass O’Brian as the last name,...
Author: irenake Date: 02/02/2006
SYSK 53: To Close() or to Dispose()? That is the question…
Since I’m still meeting developers that are not quite sure of the differences between the two, and...
Author: irenake Date: 02/01/2006
SYSK 52: Looking for NDOC that Works with .NET 2.0?
Well, look no further. Not sure if this is the only conversion available, but here is one link that...
Author: irenake Date: 01/31/2006
SYSK 51: Ten Essential Tools for VS Developers
In case you haven’t seen it, MSDN magazine published an article listing ten “Visual Studio Add-Ins...
Author: irenake Date: 01/30/2006
SYSK 50: Beyond Vista…
Curious about what Microsoft is up to after the Vista release this year? Here is what I got from a...
Author: irenake Date: 01/27/2006
SYSK 49: Have You Heard about BitLocker™ Drive Encryption?
BitLocker™ Drive Encryption (BDE) provides stronger security on Windows Vista Systems even when the...
Author: irenake Date: 01/26/2006
SYSK 48: Why is Microsoft Recommending WebServices as the Best Path to WCF upgrade?
(long, but, hopefully, worth your while) In my (non-authoritative) opinion, it’s not because...
Author: irenake Date: 01/25/2006
SYSK 47: OLEDB deja vu? A look into LINQ.
Remember the promise of OLEDB? Regardless of where the data is stored – relational database,...
Author: irenake Date: 01/24/2006
SYSK 46: New in SQL 2005 -- Snapshot Isolation
Did you know that SQL 2005 now has new snapshot isolation level? Snapshot isolation is a row level...
Author: irenake Date: 01/23/2006
SYSK 45: Is RSS Just a Fad?
Ok, so we all know by now that RSS (Real Simple Syndication) is a great way to push the web content...
Author: irenake Date: 01/20/2006
SYSK 44: ASP.NET 2.0 Website Administration Tool
If you haven’t yet, make sure to check out the new administration tool which allows you to view and...
Author: irenake Date: 01/19/2006
SYSK 43: What’s New in IIS 7?
Vista is well known for the new graphical user interface and other cool easy to demo features. But...
Author: irenake Date: 01/18/2006
SYSK 42: A must-read article on BackgroundWorker class
I was going to write a post on the different ways to execute code asynchronously in .NET, the pros...
Author: irenake Date: 01/17/2006
SYSK 41: “The Curse and Blessings of Dynamic SQL” by Erland Sommarskog
I came across this article a couple of days ago. You can see the full text at...
Author: irenake Date: 01/16/2006
SYSK 40: Beyond E-Mail – E12 promises to be one of the most impressive upgrades to Exchange that Microsoft has ever released
With proliferation of speech recognition and speech synthesis, you’d expect e-mail, voice mail and...
Author: irenake Date: 01/13/2006
SYSK 39: ASP ViewState Stored as SessionState
Unquestionably, ViewState was one of the most valuable things that came with .NET. The problem was...
Author: irenake Date: 01/12/2006
SYSK 38: Visual Studio 2005 Code Snippets
Did you know that if you type prop and press Tab key two times, VS will create a property definition...
Author: irenake Date: 01/11/2006
SYSK 37: 5 minute video on Windows Vista
Check this out -- http://news.com.com/1606-2_3-6018907.html. It’s certainly worth the 5 minutes of...
Author: irenake Date: 01/10/2006
SYSK 36: The Cost of SQL EndPoints
Many of you already know that you can expose your data as a web service natively in SQL 2005. No...
Author: irenake Date: 01/09/2006
SYSK 35: Performance comparison of WITH and TABLE variable queries
As many of you know, SQL 2005 now has a common table expression (CTE) WITH. You can think of it as a...
Author: irenake Date: 01/06/2006
SYSK 34: Tool Time – Spellchecker for Visual Studio
Want to get Microsoft Word like spell checker in Visual Studio? Then check out Visual Assist X --...
Author: irenake Date: 01/05/2006
SYSK 33: New kind of “friend” -- assembly:InternalsVisibleTo
An internal type or internal member in an assembly can now be accessed from another assembly. Yes,...
Author: irenake Date: 01/04/2006
SYSK 32: Should you use temp tables or table variables in SQL?
Kimberly Tripp, President of Founder of SQLSkills.com, uses the following “rule-of-thumb”: Use temp...
Author: irenake Date: 01/03/2006
Be back Jan. 3, 2006
Folks, thanks to all of you who read my posts, and special thanks for those of you who make it a...
Author: irenake Date: 12/20/2005
SYSK 31: Wondering what is vhost.exe, and why you need it? Then read on…
By default, when you build a Visual Studio 2005 project, you get two executables created, the...
Author: irenake Date: 12/19/2005
SYSK 30: Differences between SET and SELECT in SQL Server
I came across a great post with same title by Narayana Vyas Kondreddi at...
Author: irenake Date: 12/16/2005
SYSK 29: The Power of Ctrl+Shift+N
Did you know that Ctrl+Shift+N clears formatting of the selected text in Microsoft Word. No more...
Author: irenake Date: 12/15/2005
SYSK 28: Do you know about ‘Anonymous Methods’? If not, read on…
Have you ever created a delegate that has just a couple of lines of code? If yes, in .NET 2.0 you...
Author: irenake Date: 12/14/2005
SYSK 27: What you need to know about referenced assemblies in VS2005
Summary: Visual Studio has a new property for assembly references – Specific Version. When this...
Author: irenake Date: 12/13/2005