Brian Madsen's now an MVP too!
Congrats to Brian Madsen - our Perth SQL Server User Group organiser - who has recently also been given an MVP award by Microsoft, albeit a Visual Developer MVP award rather than a SQL Server one. We know where your heart is Brian (c:
Brian has started a discussion about "how to write correct queries to a database" - in terms of structuring and choosing your flavour in regards to T-SQL, Stored Procedures and/or CLR integration etc there is only really a trial n' error process involved when writing your queries - most developers go for the "but it returns the data i want!!!??? what's wrong with that?" approach, which generally leave me speechless (not saying i'm perfect..but...).
So the suggestion is to get a discussion group going on how to do this properly. How do you correctly relate data? is it better to use a stored procedure than a t-sql command through and object? where does santa really live? how should you structure a stored procedure? We could also summarise some advanced topics like transactions and working with system objects and/or some of the houndreds of undocumented stored procedures and functions SQL Server has.
This gives me good impetus for some more blogging, so I'll try & crank out a few more tekkie blogs as discussion starters. See what happens (c: