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.

Speaker focus

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

Tony Rogerson's blog http://sqlblogcasts.com/blogs/tonyrogerson

---

Downloads

File Type Ext ContentName Zip File .zip Demos

<< 1 >>

---

Other sessions from this conference

"SELECT TOP(@x) Name FROM MyFavouriteDMVs ORDER BY MyRanking"

2005 SQLCMD Scripting

Administering SQL Server 2008 and 2005 with Windows PowerShell

Development Life Cycle using Visual Studio Team Edition for DB Professionals

Extending SSIS with custom Data Flow components

Getting to grips with Service Broker.

I/O! I/O! It’s off to disk we go...

Introduction to SQL 2008 Performance Data Collector

Making more of SSIS in 2008

Master Data Management (MDM)

New Product Demos

Recruitment Open Panel

Reporting in SQL Server 2008

SQL Server 2008 – Declarative Management Framework concepts & database problem solutions with policy management.

SQL Server 2008 TSQL Enhancements

SQL Server High Availability and Disaster Recovery Overview

Transient data in SQL Server

Understanding LINQ in .NET Framework V3.5 and Beyond

Using Analysis Services as a data source for Reporting Services reports

What Are You Waiting For?

Where do you live? Intro to spatial indexing