Browse by Tags

• Using Column Names with IsUpdatedColumn() in SQL CLR Triggers

  As a preface to actually writing the meat of what this blog post is about, I have to admit that I am not a fan of using triggers in general, and I am even less of a fan of having SQL CLR Triggers in all but the most obscure of scenario, but that is just Read More... Posted Wednesday, May 06, 2009 4:11 AM by Jonathan Kehayias | 2 Comments Filed under: .NET/CLR Integration

• Using the sql_variant datatype in CLR

  I am not generally a proponent of creating tables with columns of datatype sql_variant in them.  Often times these tables seem to be a really great idea at first, but then slowly begin to become problemattic.  However, if you do happen to use Read More... Posted Wednesday, January 21, 2009 7:32 AM by Jonathan Kehayias | 4 Comments Filed under: .NET/CLR Integration

• CLR Safety Issues After Database Restore to New Server

  While working on finalizing the installation and configuration of SQL 2005 on a test server that I plan to upgrade to SQL 2008 Feb CTP, I ran into a snag. In order to test all the different Upgrade paths that would affect me, I have built a test server Read More... Posted Thursday, March 06, 2008 2:45 PM by Jonathan Kehayias | 1 Comments Filed under: .NET/CLR Integration