In my last post in this series, I talked about using the visual designers in SSMS.  This time, I wanted to treat the use of alias types. To clarify what I am talking about here, alias types used to be called ''user-defined data types.''  Then, when CLR came around in SQL Server 2005, they gave us the ability to create our own CLR ...

In my last post in this series, I talked about the assumptions many people make about IDENTITY columns.  In this post, I want to focus on choosing data types.  There are several areas where I see frequent mistakes in data type choice, and I'll mention a few here. Using CHAR / VARCHAR / INT for date / time values Countless times I have ...