Dave McMahon
My all-time top 10 SQL keywords
‘Top of the Pops’ might be dead, but Dave will give you his own countdown of his 10 most useful/favorite SQL keywords. No secrets to giveaway here, suffice to say that you will know some of them (but maybe not used this way) and some may be unfamiliar to you. The whole ‘Countdown’ will be demoed and Dave will explain why they make the top 10. This is a session for people who use SQL regularly, know the standard DML (Select, Insert, Update and Delete) but maybe never had the chance to peek around the corner to see what else was there!
XML - The missing LINQ
We've heard much about LINQ to SQL, its neat, but what is also neat is LINQ to XML, which hasn't has anywhere near as much press. So while everybody is looking the other way, lets sneak a look at how VB 9.0 is gearing up for a bit of a revolution in the way we handle XML: XML DOM is on its way out, XElement is on its way in. Along the way we'll check out a few new XML features in VB 9.0 including LINQ to XML, XML Literals and a bunch of other stuff too ...
• Dave McMahon
Dave works as Chief Architect for .NET Development at Ridgian Limited, a privately owned software house based in Central Birmingham. Ridgian are a Microsoft Certified Partner and specialise in Business Intelligence Solutions and Custom Software Solutions. He is very active in the Microsoft community speaking at DeveloperDeveloperDeveloper conferences, and at numerous User Group meetings around the country on such topics as SQL XML, SQL 2005 Security, Regular Expressions and his favourite technology, XSLT and XPATH. He has recently published articles on SQL Server 2005 Security in International Developer Magazine and on Vista and Office 2007 in the Microsoft Beta Newsletters.
|