Category: BESTPRACTICES

Loose Coupling

High Cohesion, Loose Coupling

We are living in a time where businesses and the people running them often change their mind. I won’t be going into details of why is that so, let’s just say it is a given, and let’s say they are […]

Find Stored Procedure by Name

There are several ways to find a stored procedure in the server by name: we can query sys.procedures, syscomments, or information_scema.routines. Respective examples would be: or or

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 […]

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 […]