Entity Framework 6 gives you a variety of ways to call stored procedures that return data and capture the results those procedures return. Here's a look at all of them. In an earlier column, I showed ...

Stored procedure is prewritten sql codes saved inside database, reused later over and over again. Why do we need stored Procedure? Suppose you have to perform some specific tasks on the database ...

What happens on the typical load-testing project? For me, the projects tend to fall into one of two buckets. Bucket No. 1: We've got a problem. Bucket No. 2: We've got a performance penalty clause in ...

Windrose is out now in early access and is already an impressive survival crafting pirate adventure in its current state. With a planned early access period of around two years, there’s a lot more ...

WHERE (p_voucher_id IS NULL OR v.voucher_id = p_voucher_id) ...