July PASSMN Meeting

Sponsored by Magenium Solutions

Meeting Details

• Location: 3601 West 76th Street, Suite 600 Edina, MN  55437
• Date: July 17, 2011
• Time: 4:00 PM – 7:00 PM
• Live Meeting:
  • URL:  https://www.livemeeting.com/cc/usergroups/join?id=BFQM8K&role=attend&pw=FZ%2Bw3%3F%5BFm
  • Meeting ID: BFQM8K
  • Entry Code: FZ+w3?[Fm

Please click here for meeting details and to RSVP

O, there’s my data: The Open Data Protocol (OData)

Steve Hughes, Magenic

Earlier this year, Mark Souza from the SQL Server product team spoke at our user group. During the Q&A I asked about interacting better with Oracle. Mark mentioned that OData would be the best way to handle this. I will be discussing what OData is and what tools are involved. I will also explore how to create an OData feed and how to interact with it using tools such as PowerPivot, SSIS, and SQL Azure. I will also examine the impact of OData for data professionals, both good, bad and ugly. In the end, you should understand how OData works and where it can help us expose our data appropriately to our users.

Optimizing Microsoft SQL Server Performance in a Virtual Environment

Denny Cherry, independent consultant

In this session we’ll look over some of the things which you should be looking at within your virtual environment to ensure that you are getting the performance out of it that you should be. This will include how to look for CPU performance issues at the host level. We will also be discussing the Memory Balloon drivers and what they actually do, and how you should be configuring them, and why. We’ll discuss some of the memory sharing technologies which are built into vSphere and Hyper-V and how they relate to SQL Server. Then we will finish up with some storage configuration options to look at.