Making the leap into Advanced SQL - SqlBits III

It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. Or, if your browser does not support JavaScript, click here.

Session Details - Making the leap into Advanced SQL

There are three major features in SQL Server that are usually under used or not used optimally; these are - a) Derived Tables, b) Common Table Expressions and c) The CASE expression. In this session I look at the in's and out's of each feature from basics right through to advanced techniques and considerations.

Tony Rogerson

Tony started his IT career in 1986 coding on the IBM mainframe programming in such languages as Application System, PL/1, CICS, DB2, System W. Around 1994 he moved into the client/server environment using Visual Basic and C++, Oracle at first and then Microsoft SQL Server, he primarily does SQL Server consultancy but also knows VB.NET and C# but is really SQL Server focused.Tony has been an independent consultant since 1999 based in Harpenden - Hertfordshire. He has a broad client base from a Research Fellow right the way through to enterprise covering a lot of business areas, Banking (Retail, Investment), Retail, Knowledge Management, Manufacturing, Motor Racing, Web Industries and a ton more I don't even know how to classify!In 1998 he founded the UK SQL Server Community (http://sqlserverfaq.com) a community of over 9,000 members. He also co runs SQLBlogcasts.COM with Simon Sabin, Tony’s blog