Spatial library for SQL Server 2008 would be great for SilverLight

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. It would be highly desirable to have a version of this library (or at least as much of it as possible) able to be deployed with a SilverLight application, given the likely popularity of SilverLight during the upcoming year and the style of application that the spatial library would otherwise support. If you think so too, please vote here: … Continue reading Spatial library for SQL Server 2008 would be great for SilverLight

User-defined Facets in DMF for SQL Server

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 framework using T-SQL statements, this does not go far enough. Being able to extend the list of facets via managed code would greatly increase the possible uses of DMF. You can vote for this here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=299330

DMF should allow regular expressions in its expressions

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 the names of tables that a policy element would apply to. If you’d like to see this, the connect site is looking for your vote: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=299329

INSTEAD OF DDL Triggers

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 for these even more pressing. Many operations are way too expensive to roll back and some operations such as CREATE DATABASE are unable to be rolled back.It should be possible to issue DMF policies for say “you may not rebuild indexes during 9am to 5pm Mon to Fri”. INSTEAD OF triggers would also allow updating the DDL before executing … Continue reading INSTEAD OF DDL Triggers

DDL vs System Stored Procedures

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 these statements to be trapped by DDL triggers, notified via Event Notifications and controlled by Declarative Management Framework policies (coming in SQL Server 2008). However, a number of aspects of SQL Server 2008 have moved back to using system stored procedures. I am encouraging Microsoft to reverse this trend. They seem to be making a … Continue reading DDL vs System Stored Procedures

SQL PASS in Denver was Excellent

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 product group staff and other presenters and attendees. We had a PASS volunteer meet and greet function on Monday night and I was honoured to get to present sort of a keynote for the PASS volunteer day on Tuesday morning. Paul Nielsen had obtained copies of my technical communities book for all attendees and I … Continue reading SQL PASS in Denver was Excellent

The Woeful Service at QANTAS Continues

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, etc. on domestic flights, nothing’s improved on the international routes in the last three months either. We got to spend time in the wonderful new first class lounge in Melbourne. (This is a great benefit of platinum membership in the frequent flyer program). However, much as Mai loved being able to have a facial in the day spa while we were … Continue reading The Woeful Service at QANTAS Continues

Juval is back in town soon – learn WCF from the master

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 get your head around WCF, Juval is the one to help you do it. I’m desperately hoping I have time available to attend it as I missed it last time he was here. Details are at: http://www.readify.net.au/Default.aspx?tabid=241 The class is in Sydney this time but if you’re based in another location, talk to Faith at training@readify.net about … Continue reading Juval is back in town soon – learn WCF from the master

Silverlight 1.0 RTM and Moonlight for Linux Announcement

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/2007/09/04/silverlight-1-0-released-and-silverlight-for-linux-announced.aspx If you’re based in Canberra, Sydney or Melbourne, also make sure you get along to see our very own Philip Beadle covering Silverlight at the first Readify Developer Network session in October. Details are at: http://www.readify.net/rdn.

Book: Inside SQL Server 2005 – The Storage Engine

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 working with SQL Server 2005 at any depth. In this book, Kalen looks at how data is stored in SQL Server, particularly with reference to tables, indexes and locks. She also provdes good coverage of Row Versioning and Snapshot Isolation and shows many examples of using Dynamic Management Views (DMVs) to explore what’s going on inside … Continue reading Book: Inside SQL Server 2005 – The Storage Engine