July 2005 - Posts

Common Table Expressions in SQL Server 2005 ROCK!!!
22 July 05 11:56 AM | James World | 2 Comments   

I've been taking a look at a new feature in SQL Server 2005 called "Common Table Expressions" (hereafter CTEs). This is an extra-ordinally powerful extenstion to Transact SQL that removes the need for managing temporary tables in many common scenarios. Read More...

Encrypting Data In SQL Server 2005
20 July 05 06:03 PM | James World | 3 Comments   

I've been looking at the new encryption functionality in SQL Server 2005. Here's some sql that executes on IDW15 - June CTP (most of it should work on IDW14 - April CTP apart from DecryptByKeyAutoCert I think... This sample code sets up a database and Read More...

New InternalsVisibleTo attribute in .NET 2.0
07 July 05 08:42 PM | James World | 0 Comments   

I discovered a cool new attribute in .NET 2.0 called "InternalsVisibleTo". This takes an assembly name and public key token and grants it access to the assembly internals. One cool application I can think of is that you no longer have to place your unit Read More...