TechEd U.S. -> Boston -> Simulcast & Missile Defence Systems

Hi Folks, got a note this morning to tell me my session for TechEd U.S. will also be simulcast. I’ll post the url when I get it. But also on the note, I saw that local MVP and fellow Readifarian Martin Granell’s session has been also been selected for simulcast. Outstanding! Martin clearly has picked the best title for any session at TechEd this year: How to get your grandmother building missile defence systems. No idea what he’s going to cover but I’m not going to miss it 🙂

CodeCampOz – Return to Wagga – Done and Dusted & Some Interesting Pizza Stats

So, CodeCampOz is over for another year. Again, it was wonderful to see the local developer community in action. Special thanks need to go to: * Irfan Altas and the gang at Charles Sturt University for their outstanding organisation help * Chuck Sterling, Andrew Coates, Dave Lemphers and all the Microsoft Australia gang – particularly those in Frank Arrigo’s group – (great to see Deeps and Rose Stamell there too) for their sponsorship and all-round help and encouragement * Adam Cogan for sponsorship of the speaker trainer * Mitch Denny for being Mitch * All the speakers. Apart from Mitch and myself, … Continue reading CodeCampOz – Return to Wagga – Done and Dusted & Some Interesting Pizza Stats

Deferred constraint checking?

Another discussion we’ve had on the local mailing lists lately has been around whether or not the ability to defer constraint checking (at least foreign key constraints) until the end of a transaction would be useful in SQL Server. I see a lot of convoluted update code from things like ADO.NET datasets that would be greatly simplified if you could say: a) start a transaction b) send all the updates in any order c) commit the transaction (and check the RI constraints at this point) I’d love to hear your thoughts. Oracle has had it for a long time. Would … Continue reading Deferred constraint checking?

Tool to expand SQL Server views?

In a previous post, I mentioned the sort of performance problems I see (when doing consulting work) that relate to the use of VIEWs. A discussion on this on our local mailing lists in the last day or so got me thinking that a tool is needed. I’d like to see a tool that could be used from within SQL Server Management Studio where you could: a) highlight some T-SQL text in a query window b) right-click it and have it expand out the code, including all the underlying views, into another query window. (would obviously also need to be permission-based) … Continue reading Tool to expand SQL Server views?

SQL Server 2005 SP1 Now Available

Conventional wisdom on many Microsoft products seems to be to wait for the first service pack. Although I’ve been telling people they don’t need to do that with SQL Server 2005 (as it’s been so stable and solid), SP1 is now available anyway. Great to see the list of improvements and fixes.

Express Products Now All Free

SQL Express has always been listed as being free but not the other Express products. Microsoft today announced that the other Express products are to be free as well. This is good news.

Now I Know CodeCampOz Is Happening Soon

Anthony Chan, a lecturer at Charles Sturt University has been making some signs for CodeCampOz. Outstanding work!   also if you have a UHF radio, the channel set up at CSU is Channel 1 (Duplex). Ask for “CodeCampOZ” and someone will respond that morning of your arrival, should you get lost!

Views and SQL Server Performance

On a recent consulting job, the performance problems that are easy to get into when using SQL Server Views was again made very clear to me. A common problem with views that I see is that when developers need to find a column from “somewhere”, they often find it’s available in a view and select it from there, with no thought as to what’s involved in obtaining the data from the view. This gets especially bad if the view is then built on other views.   It started with an innocuous little query like:   SELECT DISTINCT “SYSNAME” FROM GW_HA_LINELIST … Continue reading Views and SQL Server Performance