April 2006 - Posts

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

Published Sun, Apr 30 2006 7:18 | GregLow

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...

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

Published Tue, Apr 25 2006 7:12 | GregLow

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...

Deferred constraint checking?

Published Fri, Apr 21 2006 3:47 | GregLow

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...

Tool to expand SQL Server views?

Published Fri, Apr 21 2006 3:35 | GregLow

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...

SQL Server 2005 SP1 Now Available

Published Wed, Apr 19 2006 23:56 | GregLow

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...

Express Products Now All Free

Published Wed, Apr 19 2006 23:47 | GregLow

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 - Adam Cogan - SQL Reporting

Published Wed, Apr 19 2006 12:29 | GregLow

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!

Now I Know CodeCampOz Is Happening Soon

Published Wed, Apr 12 2006 1:29 | GregLow

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...

Sydney Windows Infrastructure User Group

Published Thu, Apr 6 2006 14:24 | GregLow

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.

Views and SQL Server Performance

Published Sun, Apr 2 2006 2:11 | GregLow

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...

SQL Down Under Show 13 - Bill Graziano

Published Sat, Apr 1 2006 8:08 | GregLow

SQL Down Under show 13 with guest SQL Server MVP Bill Graziano is now available for download from www.sqldownunder.com . In this show, Bill discusses what he wishes developers knew about SQL Server, he discusses agile development, build environments,...