PASS Virtual Chapters 

• Performance Virtual Chapter: Introduction to SQL Server Statistics, Sept 7
• 24 Hours of PASS: Summit Preview, September 15-16
• Virtualization Virtual Chapter: Storage and Virtualization for the DBA, September 23

SQLSaturday 

• PASS SQLSaturday, Raleigh, NC, September 18
• PASS SQLSaturday, East Iowa, September 18
• PASS SQLSaturday, San Diego, September 18
• PASS SQLSaturday, Denver, September 25

 

  

 

 Meeting Time

We typically meet on the second Tuesday of the month from 6 - 8 pm.  

 Meeting Location

SQLShare Offices

225 S Westmonte Dr., Suite 2010

Altamonte Springs, FL

View Larger Map

Typical Agenda 

We normally start with about 10 minutes of news and announcements.  We then have 10-15 minutes of networking.  Right before the food is served, usually pizza, we give our sponsor for the month a chance to present for 10-20 minutes.  At about 6:45 we start our feature presentation. Finally we end by raffling off any SWAG our sponsors have graciously supplied.

Sign up here for news, and join us on our LinkedIn group for networking, discussion, and job posts.

September 14, 6:00pm - 8:30pm

Mini-Session

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.

Main Session

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