Posted by: Denny Cherry
Coffee And Code
I would have to say that the first SoCal Coffee and Code was a hit. Only a few people came, but I wasn’t sure if any were going to show, so fora first event I’d say that a few is a success.
First were a couple of co-workers named Rene and Hattan who stopped by to talk about SQL Server tuning. We ended up talking about SQL Server tuning, VMware, upgrading their companies SQL Server, crappy VB6 code that they’ve seen among other things. They are still running good old SQL Server 2000 in their environment. They have a machine with only a few Gigs of RAM but a 20+ Gig database so we talked about adding more RAM to increase the buffer cache on the machine to decrease the response time. Hattan had seen me speak at the SoCal Code Camp in January and started reading my blog, which led him to today.
Later Thu came by and we talked about SQL Server 2008, and how to install SQL Server 2000, 2005 and 2008 side by side. We also dug into using fn_listextendedproperty to problematically retrieve the extended properties of columns on a table. Apparently a legacy system at her company has some columns which are simply labeled as user defined and it’s been causing a problem not having them correctly documented anywhere. The most reliable system that they came up with was extended properties. Makes sense to me.
The last person to come by was Thomas. He’s a fellow speaker from the SoCal Code Camps and we know easy other fairly well. We chatted about SQL Server, and a project he’s working on which envolved moving data from mainframe systems to SQL Server. Thomas was the last person to come over and we decided to grab some dinner together before calling it for the night.