I decided to do a SQL Advent series of posts this year as well, this year I will focus on best practices. In case you are interested in last year's posts, all of them are listed here: SQL Advent 2011 Recap Here is what the preliminary 25 posts will l…

Here is a recap of all the 24 SQL Advent 2011 posts Day 1: Date and time In this post I covered the new date, datetime2 and time datatypes Day 2: System tables and catalog views In this post we took a look what the replacements are for the all s…

What is a web developer? Recently I was involved in a discussion about the skills a web developer is expected to have and how interesting it has been to watch common bad practices (like table layout and SQL injection) continue to spread. So in the nature of Denis's What does a SQL Server developer need to know? post, I present the web developer breakdown.

Take a look at this piece of junk code, what pops up in your head when you look at this CREATE FUNCTION [dbo].[age](@set varchar(10)) RETURNS TABLE AS BEGIN IF (@set = 'tall') SELECT * from player where height > 180 ELSE IF (…

This question popped in the microsoft.public.sqlserver.programming forum yesterday. A person wanted to change a column from varchar 500 to varchar 2000. This is actually pretty easy to do in SQL Server, you can use the alter table alter column command

Let's take a quick look at how this works

First create this table

I was listening to show number 426 on dotnetrocks: Rob Boucher on Application Architecture Guidance! They mentioned the Patterns And Practices Application Architecture Guide 2.0, this guide is available for free on codeplex. Although it is a Microsof…

Today, Jimmy Bogard made a post over at LosTechies.com about DDD and it not being about patterns but all about the Domain and how you model it.

Since his words are better then mine, I would like to quote him.

One question Rob Conery asked me during a conversation on DDD was, “How do I recognize an application built with DDD?” WeR...

Which books should you read/buy when you are a programmer? I have listed 5 books that have helped me a lot. The books that I have chosen are not specific to any language although some of the books have examples in one language only. Design Patterns has examples in smalltalk and C++ but since the code is not very complicated you should have no problem converting it to your language of choice. I have included links to sample chapters for the books where I could find them. For some of the books I have also provided links to the author’s site; some of them have additional material so that...