Welcome to EMC Consulting Blogs

November 2004 - Posts

• Heavyweight Blog Referral

  None other than Niels Berglund has posted a referral to my blog! He is a true SQL Server 2005 development guru, who co-wrote the only SQL Server 2005 development book on the market. I attended the Developmentor SQL Server 2005 Dev course a couple of weeks Read More... Posted 09 November 2004 17:20 by christian.wade | 4 Comments

• SQL Server 2005: Recursive Hierarchies to XML - CTEs vs. UDFs

  Suppose we have a recursive hierarchy stored in a relational database and we want to write it to XML. This might be for a variety of reasons – e.g. as a pre-cached input to a UI control, to export to another system using a pre-defined format, etc. Read More... Posted 09 November 2004 13:16 by christian.wade | 6 Comments Filed under: SQL Server 2005 - Relational Attachment(s): RecursiveHierarchiesToXml.zip

• History of Partitioning in SQL Server: from 6.5 to 2005

  Horizontal partitioning allows us to split our database entities into more manageable chunks. It is especially applicable to data-warehousing environments and enterprise implementations with Very Large DataBases. For example, we might have a partition Read More... Posted 08 November 2004 17:00 by christian.wade | 2 Comments Filed under: SQL Server 2005 - Relational

• My Daughter Annabel's Moment of Enlightenment

  Read More... Posted 08 November 2004 09:31 by christian.wade | 0 Comments

• Populating varchar(MAX) with varchar(n)

  This may seem a logical solution to a simple problem, but I have seen a few people bitten by it. Why does the following TSQL return LEN(@s3) as 8000 instead of 16000? DECLARE @s1 varchar ( 8000 ), @s2 varchar ( 8000 ), @s3 varchar ( max ) SELECT @s1 = Read More... Posted 06 November 2004 10:46 by christian.wade | 0 Comments Filed under: SQL Server 2005 - Relational

• Full Support for ANSI SQL Declarative Referential Integrity Actions in SQL Server 2005

  Since SQL Server 2000, we’ve had the option of cascading updates and deletes for our RI constraints. Believe it or not, Access had this feature before SQL Server. But ANSI SQL defines four possible referential actions to support FOREIGN KEY constraints: Read More... Posted 04 November 2004 10:08 by christian.wade | 0 Comments Filed under: SQL Server 2005 - Relational

• Why Managed Code in the Data Tier?

  This is an introductory-level post for developers looking at running managed code in the data tier. So we have this wonderful feature in SQL Server 2005 where we can host the CLR in the SQL Server process. But what does managed code give us over TSQL? Read More... Posted 03 November 2004 15:34 by christian.wade | 0 Comments Filed under: SQL-CLR

• Shortcut Keys for SQL 2000 & 2005 (Beta 2)

  http://yukonxml.com/weblog/darshan/archive/2004/08/09/164.aspx Read More... Posted 03 November 2004 15:33 by christian.wade | 0 Comments

• SQL Server 2005: Dynamic SQL Security Context for .NET Managed Code Sprocs - With Better EG

  In SQL Server 2000, recommended practice was to use object-ownership chains to secure databases. Regular users would not be assigned access to underlying tables. They would typically be given execute permissions on stored procs in order to get at data. Read More... Posted 02 November 2004 16:06 by christian.wade | 1 Comments Filed under: SQL-CLR