September 2007 - Posts

Spatial library for SQL Server 2008 would be great for SilverLight
Published Mon, Sep 24 2007 8:20 | GregLow
The new spatial library is a wonderful addition to the SQL Server 2008. Even better is the ability to install this library separately on client systems. However, a really important target for this library is likely to be SilverLight based applications...
User-defined Facets in DMF for SQL Server
Published Mon, Sep 24 2007 7:58 | GregLow
The Declarative Management Framework in SQL Server 2008 has a built-in list of facets that policies can be based on. It would be desirable for users to be able to build their own Facets via CLR-based managed code. While it is possible to extend the existing...
DMF should allow regular expressions in its expressions
Published Mon, Sep 24 2007 7:53 | GregLow
The new declarative management framework in SQL Server 2008 allows for the use of expressions. When you are entering expressions, it'd be great if you could use regular expressions. This would allow for example, a regular expression to be used for...
INSTEAD OF DDL Triggers
Published Mon, Sep 24 2007 7:47 | GregLow
I know we've talked about this a number of times with a number of people but I've decided to reopen Adam Machanic's 243986 suggestion on the connect site regarding the need for INSTEAD OF triggers for DDL operations. DMF now makes the need...
DDL vs System Stored Procedures
Published Mon, Sep 24 2007 7:25 | GregLow
In SQL Server 2005, a really good move towards the use of DDL (ie: CREATE/ALTER/DROP etc) rather than the use of system stored procedures (ie: sp_addlogin) was made. This is an important move not only for the clarity of the language itself but it allows...
SQL PASS in Denver was Excellent
Published Sun, Sep 23 2007 7:04 | GregLow
In stark contrast to the quality of the trip to/from the US, the PASS conference in Denver was really excellent. This really is *the* world-wide SQL Server related event of the year. It was great to see the support of so many PASS volunteers, Microsoft...
The Woeful Service at QANTAS Continues
Published Sun, Sep 23 2007 5:39 | GregLow
In a recent post , I discussed at length the issues I have been finding with QANTAS flights recently. I've just returned from yet another international trip with them and sadly, while I've continued to have endless delays, mechanical problems...
Juval is back in town soon - learn WCF from the master
Published Wed, Sep 12 2007 3:06 | GregLow
Juval Lowy is back in Australia next month. He'll be teaching our Industrial Strength WCF Master Series class from 15th to 19th October. WCF will be very important to most new applications being built for the Windows platform. If you really want to...
Silverlight 1.0 RTM and Moonlight for Linux Announcement
Published Wed, Sep 5 2007 8:06 | GregLow
Congratulations to Scott Guthrie and his team for getting Silverlight 1.0 out the door. It was also interesting to note his announcement regarding official support and cooperation with Novell on Moonlight for Linux. http://weblogs.asp.net/scottgu/archive...
Book: Inside SQL Server 2005 - The Storage Engine
Published Tue, Sep 4 2007 6:25 | GregLow
In the first volume of the Inside SQL Server series for SQL Server 2005, Kalen Delaney again does a wonderful job of clearly describing many aspects of the system internals. Inside SQL Server 2005 - The Storage Engine is a must-have reference for anyone...