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 🙂
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
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?
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?
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.
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.
SQL Down Under show 14 features guest Adam Cogan (MSDN Regional Director) discussing his “rules” for better SQL Server Reporting Services. It’s now available for download from www.sqldownunder.com. Enjoy!
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!
Fellow Readifarian Derrick Buckley has fired up a Sydney Windows Infrastructure Group. Details are at: http://swiug.org.au. First meeting is April 11th. Jeff Alexander is presenting.
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