The Story of the Modern Day Developer

Software Developer, a “Programmer” even an “Engineer” or a “Craftsman“, although there are substantial differences between these according to some people, when we say any of them we mean one thing….an organism that transforms coffee into code 🙂 so I […]

Sql Server: datetime vs datetime2 recap

The MSDN documentation for datetime recommends using datetime2. datetime2 has larger date range, a larger default fractional precision, and optional user-specified precision. Also depending on the user-specified precision it may use less storage. Furthermore, datetime2 has a date range of […]

Get all stored procedures related to a table

To get all stored procedures related to a table: Option 1: SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so ON sc.id=so.id WHERE sc.TEXT LIKE ‘%tablename%’ Option2: SELECT DISTINCT o.name, o.xtype FROM syscomments c INNER JOIN sysobjects o ON […]

Sql Server: Delete duplicate rows with CTE

Here’s a code snippet to remove duplicate rows in a table: WITH CTE (Column1, Column2, DuplicateCount) AS ( SELECT Column1,Column2, ROW_NUMBER() OVER(PARTITION BY Column1,Column2 ORDER BY Column1) AS DuplicateCount FROM TheTable ) DELETE FROM CTE WHERE DuplicateCount > 1 GO […]

Filtering duplicates out of an IEnumerable

Problem: Filtering out(removing duplicates) from an IEnumerable One possible solution with using linq would be to group by key and take the first element of each group. Here’s an example: enumerable.GroupBy(x => x.key).Select(g => g.First())

Sql Server: Get all tables containing column with a specified name

A little helper query I came accross, very useful if you want to find all the tables that contain a specific column: SELECT c.name AS ColName, t.name AS TableName FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE […]

Test Driven Development

It is pretty hard writing an article on something that so many super cool authors have written books about. But, as I said it is my own experience learning and embracing TDD that I want to share here so that […]

The S.O.L.I.D. Principles

There have been many questions I encountered lately of what are the best practices / guidances that you can take up on when designing an application. Wheather that’s an ASP.NET application or any other type of application that uses object oriented […]

Providing a File for Download trough a Save As Dialog in ASP.NET

The question of providing a file trough a SaveAs dialog in a web browser appears very often in the forums and QA websites like Stackoverflow. The default action of the web browser when a file is provided is to open it. […]

Using a .NET assembly in SQL Server 2008

Many times you fnd yourself in a situation where you have to do something that seems too complex to implement in TSQL or you just want to use some feature from the .NET framework, or you already have something implemented in an assembly […]