March 2006 - Posts

SQL Snapshots - coming soon
Published Thu, Mar 30 2006 11:01 | GregLow
Hi Folks, I'd taken a bit of a break from producing SQL Down Under podcasts over the last few weeks. It came on the end of a lot of travelling. However, there is good news for listeners. I'm recording three shows over the next week, so watch out for a...
More on Primary Keys and GUIDs - NewSequentialID()
Published Sun, Mar 26 2006 23:51 | GregLow
In answering a query on the SQLDownUnder mailing list today, one of the functions Paul Nielsen mentioned was the NewSequentialID() function, which is new to SQL Server 2005. I then had an email asking about this function, so I thought a short post explaining...
OzFox Lite
Published Sat, Mar 25 2006 6:13 | GregLow
I had the honour to spend the day in Sydney today with the Craig Bailey's group at OzFox Lite . I was speaking about SQL Server 2005 and developers. It was really excellent to see the level of passion still present in the Visual FoxPro community. Thanks...
CodeCampOz Swag/Prizes
Published Wed, Mar 22 2006 8:51 | GregLow
Mitch created a CafePress store for CodeCampOz . I ordered 3 large mugs from it. I'm going to use them as swag / prizes at CodeCampOz . They're here! Anyone planning on coming that hasn't let us know, please do so to registrations@codecampoz.com soon...
Avoiding source code deployment with CLR projects
Published Wed, Mar 15 2006 5:34 | GregLow
One of the things I haven't been keen on is the auto-deployment of source code when deploying an assembly from within a Visual Studio Database project. Each assembly that is sent to the database ends up with an entry in sys.assemblies. However, there...
Measuring the speed of light with chocolate chips
Published Mon, Mar 13 2006 5:09 | GregLow
I spent some time at the University of Queensland way back in the 70's. One of the things I remember most vividly was the physics pracs. In the pass-level class, they gave you the equipment, told you what you had to show and then told you step-by-step...
Kent Tegels Podcasting
Published Mon, Mar 13 2006 4:56 | GregLow
Great to see our buddy (and fellow MVP) Kent Tegels now podcasting. Kent is well known for his Enjoy Every Sandwich blog. Check it out at: http://www.sqljunkies.com/WebLog/ktegels/articles/TOAE001.aspx .
Product Feedback Center Status Oddities
Published Sun, Mar 12 2006 1:41 | GregLow
The Product Feedback Center is a great initiative from Microsoft. I do struggle with some of the feedback/statuses though. Take this excerpt for example: Resolved as Not Reproduced by Microsoft on 2006-02-09 at 18:04:03 This issue has been fixed in upcoming...
TSQL Variable Definition based on Column Type
Published Sun, Mar 12 2006 1:29 | GregLow
I ran into Scott Thornton at the VDNUG meeting in Melbourne a week or so ago. Scott was a student I had taught in a SQL Server class last year. He sent me a number of suggestions regarding enhancements to T-SQL he'd like to see, particularly ones he misses...
What Makes A Good Data Entry App
Published Thu, Mar 2 2006 23:43 | GregLow
We had an internal discussion the other day about what makes a good data entry app. The vast majority of Windows applications I see are lousy for data entry purposes. The discussion was prompted by an Outlook-style app that had a scrolling data-entry...