Month: March 2015

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

Custom Membership User

Hello again. In the first part of these mini series we discussed how you can create a custom membership provider and a custom role provider. Many times you will find yourself in a situation where you need to store and retrieve more data for a […]

Custom Role Provider

In the first part of these series we discussed and provided an example of how to create a custom membership provider. We will continue these mini series with a discussion and an example of how to create a custom role provider. We said in […]

Custom Membership Provider

Custom Membership, Role Providers, Membership User Series. Since these articles and the examples in them are pretty long, it could get pretty cumbersome to have all of them in one go so I split them up in several articles. Here goes the first one. The Custom […]

FileUpload Control in ASP.NET and IIS7

When you want to work with the FileUpload control in ASP.NET probably the most important thing to have in mind is that you are working with files, and files can get big, sometimes really big. By default with the FIleUpload control you […]