sql server

There are 2 entries for the tag sql server

DreamSpark - Fantastic Idea But Only The First Step

When I was in high school one of my math teachers took it upon himself to teach a few students about computer programming.  It wasn't a real class it was just something he put together during our free period.  Instead of attending study hall we'd go to this computer programming class.  Basically other students in the school called the few of us taking the class the "Star Trek" club.  Honestly I didn't watch Star Trek and never have.  It just never interested me.  I know that I just lost thousands of geek points by stating I am not a Star...

Creating Custom SQL CLR User-Defined Types

Since SQL Server 2005 .Net developers and DBAs have had the ability to create custom SQL CLR types.  It wasn't until recent I found a few uses for them.  Not only did I find a use for them but a DBA who is a team member did as well.  If you would like more information about SQL CLR types or are new to them start by reading the introduction here.   What follows is a walk through from start to finish creating a user-defined type (UDT).   The project source code is available at the end of the article. Maintaining Data Integrity One of the advantages of SQL...

«September»
SunMonTueWedThuFriSat
2930311234
567891011
12131415161718
19202122232425
262728293012
3456789