Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

Browsing "design"

4

SQL Advent 2012, here is what is coming

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…

Read More...
0

SQL Advent 2011 Recap

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…

Read More...
9

What Does a Web Developer Need To Know

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.

Read More...
11

Use a database how it was intended to be used

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 (…

Read More...
0

Use alter table alter column to change datatypes for a column in SQL Server

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

Read More...
0

Patterns And Practices Application Architecture Guide 2.0, Something Everyone Should Read

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…

Read More...
7

5 Books Every Developer Should Read

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

Read More...