Get me out of my desktop

Friday again, it call for another working day in a week of the month :)
By chance I got hit by a cartoon draw on the Kapuchea Thmei newspaper it just hit me so hard that I can't stand but post it for you guy so check this out

Don't you wish your girlfriend just like this? trouble!

Security for the Geek

ក្រោយពេលសំរាកពីការងារនាល្ងាចមួយខ្ញុំបានបើកមើលអាល់ប៊ុមរូបថតចាស់ៗ​​ រូបខាងក្រោមនេះធ្វើអោយខ្ញុំនឹកនូវសំដីដែល​គ្រូ Module: Network Security​​ និយាយប្រាប់នាទីចុងក្រោយថា Martin:

"Security is not a product, it is a process"
Think like a alien, defend in deep like the layer of an onion,
the chain is as strong as it weakness link.
delay attack against brute force attack.

Database programming in a disconnected environment

This is a pre-release post!

How many time have you encounter with this problem? During the course of my carrier 99.9% of the time I need to write database application in a disconnected manner. I decided to write this up and if you got some gut to try it as your assignment ;)

$diagram_place_holder$

Scope:

• Application that run on a single workstation
• Be able to consolidate data from multiple data from the workstation (incremental dataset)
• Allow DBA to consolidate & tracking changed records from each station (for various reasons).

that sound simple enough, now let talk about the infrastructure:

• No WAN available (CRUD process on a single machine)
• Each station rely on slow e-mail connection to submit update dataset

Technology:
Let try to solve this problem base on OOP language

• ASP.NET 2.0 (? I hope one day all station got will be on WAN)
  
• Data Transfer Object (DTO) + use internally by DAL
• Implement Data Access Layer (DAL) + support Import/Export functionality.
  
• Business Logic Layer (BLL) -- interact from user interface (form), use DAL internally

Data Structure Convention:

• Avoid using composite primary key
• Recommended field name:
  IsActive = T/F,
  IsDeleted = T/F, -- logical deletion
  CreatedBy NVARCHAR(50),
  CreatedOn DATETIME,
  ModifiedBy NVARCHAR(50),
  ModifiedOn DATETIME -- using this field to extract data into DTO object
• DataSyn table to store the status of data extraction
• Obsolated table to store deleted record of each table.

Debugging failed because integrated Windows authentication is not enabled

On of the annoying error message while trying to debug my ASP.NET application.

The fact, I just did a clean install my machine (winxp) and manually create virtual directory from IIS and epected it just work, but no I need to perform a few additional step to make thing work.

Enable Integrated Windows Authentication on the local IIS

1. Open IIS Manager (Internbet Information Services)
2. Right-click the web site (in case you run it locally you only have Default web site) and pick Properties
3. Choose "Directory Security" tab and click Edit on "Anonymous access and authentication control"
4. In the opening window, uncheck "Allow Anonymous access" and check "Integrated Windows Authentication" (allowing anonymous can make that you don't have enough permissions to debug)

Hope I don't forget it again ;)