Topic: Using PIVOT – Going from Static to Dynamic

Sometimes data normalization results in a data structure that is not convenient for displaying the data. Take the common example of a sales database in which each record represents a single sale.  However, what the customer really wants is a summary of sales for each product by quarter in which the quarters are columns, not vertical groupings.  SQL 2005 introduced PIVOT  to solve that type of problem.  The only drawback is that you must know when you write the SQL statement, how many columns you will need along with their name/values.  In some situations you may not know how many columns you need ahead of time.  Suppose you wanted to pivot on products that your company sells, but the number of products changes frequently.  How can you make the PIVOT statement dynamic?  We will explore one solution to that problem in this month’s SQL Tech Shot.

Speaker: Michael Antonovich

Mike Antonovich is the Assistant Director of Web Services for Orange County Public Schools in Orlando, FL where he manages the SharePoint portal team implementing the Internet, intranet, collaboration, project, team, and school sites. They are also responsible for multiple .Net custom applications around the district. In June of 2010, he published his 7th book: Office and SharePoint 2010 User's Guide. Mike has been using SQL Server since 1998 and SharePoint since 2007.

Topic:  Cool Stuff with SQL Azure

This session will provide a quick introduction into SQL Azure, including account creation and security, and discuss why a move to SQL Azure might be important to your organization. We will discuss supported functionality in SQL Azure and then look at different deployment scenarios and data access techniques such as sharding and why that is important in SQL Azure. We will then take a look at how to develop applications for SQL Azure using many of the topics discussed

Speaker: Scott Klein

Scott Klein is President of Blue Syntax, a consulting and services firm specializing in SQL Azure. Scott is a Microsoft SQL Server MVP and author of several books including Professional SQL Server 2005 XML, Professional LINQ, Professional Entity Framework 4.0, and Pro SQL Azure. Scott runs the South Florida SQL Server Users Group.

RSVP to webmaster@opass.org

Agenda

Hope to see you there