How to Use Update Cursors in SQL Server
There can be a situation where you have to use a cursor, even though the experts say not to use cursors or to avoid them as much as possible. But if you look cl
Database Design and Naming Conventions
Introduction
I have looked around a lot and decided that the majority of "standards"
for databases don't make sen
Single Responsibility Prinicple
SRP is one of the easiest principles to learn, but one of the hardest to master. The reason to this is that it can be quite hard to see if a method or class breaks SRP or not. I got a few simple rules
Signum Framework Tutorials Part 2 – Southwind Logic
Download Signum Framework
2.0 Binaries - 2.17 MB (also in codeplex.com)
Download Signum Framework
2.0 Sources - 1.48 MB (also in
github.com)&n
A less evil singleton
I’ve been working a bit more with my Griffin Framework and I’m almost ready to release the Specification library in it. The specification library is an abstraction layer similar to CommonLog and Commo
WinRM in mixed domain environments
Introduction
Windows Remoting works perfectly for same domain situations, and the set-up is relatively straight-forward. It's extremely powerful when it works, and offers a highly flexible way to s
Dynamic Decorator, Unity and Castle DynamicProxy Comparison
Download DynamicDecoratorCastleUnity - 246.81 KB
Introduction
Extending functionality by attaching behaviors to object has advantages over extending functionality by modifying existing classes or
Do you really need an ORM?
An Object-Relational Mapping (ORM) is necessary only when you have:
an object model, and
a need to persist this object model to a Relational Database Management System (RDBMS).
The latter may be
Handle Exception Carefully
Handle Exception carefully means I am not going to discuss some rocket science about exception handling but I am going to discuss not to shadow the exception in your program. Not going to discuss more
Solving Sudoku
Download Article Sudoku Solver english
Download Article Sudoku Solver persian Download source IntroductionIn computer systems and in the third millennium, The speed is very important. Therefor
How to Multicast messages with SQL Server Service Broker
Starting with SQL Server 11, the SEND verb has a new syntax and accepts multiple dialogs handles to send on:
SEND
ON CONVERSATION [(]conversation_handle [,.. @conversation_handle_n][)]
[ MESSAG
Web Scheduler for managing timed jobs with ASP.NET pages
Download jobs - 2.92 MB
Download JOBS_db - 163.54 KB
Introduction
This article is about to introduce a web based job scheduler where you can add and manage your
Search Engine – Windows Tool using C#
Download source - 33.04 KB
Objective
I have always felt the need for a personal search engine like Google :) which would make life easy for me. Here I am creating a tool which would help us add to
How to pass a NULL value in a message to a queue in SQL Server
The SEND Transact-SQL verb does not allow to send a NULL message body, attempting to do so will result in error:
Msg 8433, Level 16, State 1, Line 11
The message body may not be NULL.
A zero-length
How to update a table with a columnstore index
In my previous article How to use columnstore indexes in SQL Server, we saw how to create a columnstore index on a table and how certain queries can significantly reduce the IO needed and thus increas
A dialog based Win32 C program, step by step
1. Introduction
When writing pure Win32 programs, usually you see tutorials showing how to use “raw” windows, by filling a WNDCLASSEX structure, calling RegisterClassEx and then CreateWin
Metro In Motion #8 – AutoCompleteBox Reveal Animation
When I started the Metro In Motion series, I thought I would probably post three or four articles and be done. However, every time I use my Windows Phone 7 I seem to spot a new ‘native’ fluid UI effec
Implementing a Windows Phone 7 Conversation View
This blog post looks at how to to create a conversation view, mimicking the SMS messaging interface within Windows Phone 7. This post shows how we can select different DataTemplate for each item in an
Aspects to Object vs. Aspects to Class
It is clear that aspects address system (non-functional) requirements while classes address business (functional) requirements. System requirements are runtime requirements when software executes and
Consuming Amazon Web Services (SQS, S3) using C#.Net
Download SampleSQSS3 - 1.7 MB
Introduction
In my recent assignment, I got opportunity to consume Amazon
Web Services (SQS, S3) using C#.Net. I thought lets write an article which will
elaborate,