Usages Of MSSQL ROW_NUMBER()

ROW_NUMBER is an analytic function. It assigns a unique number to each row to which it is applied (either each row in the partition or each row returned by the query), in the ordered sequence of rows specified in the order_by_clause, beginning with 1. If you want to know more about the definition you can find many resources on the internet talking about ROW_NUMBER. The main focus of this article would be about the usages with providing some...

Read More

TDD and Automated Unit Testing for Console Application

You can find the code samples used in this post on this GitHub repository. Some friends of mine complained that sometimes they are not able to apply TDD or write automated unit tests for some kinds of modules or applications and the one on the top of these kinds is Console applications. How could I test a console application when the input is passed by key strokes and the output is presented on a screen?!! Actually this happens from time...

Read More

What is TDD and Automated Unit Testing Part 3

This is a part from a series dedicated to TDD and Automated Unit Testing. I will try to do my best to keep this series alive and updated. The series parts: What is TDD and Automated Unit Testing Part 1 What is TDD and Automated Unit Testing Part 2 What is TDD and Automated Unit Testing Part 3 On the previous part of this series we were trying to dive in TDD and the world of automated unit testing and have a look on the best practices and the new habits you should gain, abide to and embrace to be able to keep up with that world. We...

Read More

What is TDD and Automated Unit Testing Part 2

This is a part from a series dedicated to TDD and Automated Unit Testing. I will try to do my best to keep this series alive and updated. The series parts: What is TDD and Automated Unit Testing Part 1 What is TDD and Automated Unit Testing Part 2 What is TDD and Automated Unit Testing Part 3 On the first part of this series we found answers for questions like: Why is testing important? How could an experienced coder/developer miss some cases and scenarios and leave them uncovered? Why should we make testing automated, isn’t it enough...

Read More