The next Minnesota SQL Server User Group meeting is coming up next week. This month Steve Hughes (@DataOnWheels) and Denny Cherry (@MrDenny) will be talking. The topics this month will be on oData and optimizing SQL Server in virtual environments. Be sure to register so that your name badge will be available for you at the Microsoft Technology Center when you arrive.
The sponsor for this month’s meeting is Magenium Solutions.
Date/Time: Tuesday, July 17 from 4 to 7 p.m.
- 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
- 4:00-4:15 : Registration / hospitality / networking
- 4:15-5:45 : O, there’s my data: The Open Data Protocol (OData) – Steve Hughes
- 5:45-6:00 : Announcements and prize giveaways
- 6:00-7:00 : Optimizing Microsoft SQL Server Performance in a Virtual Environment – Denny Cherry
O, there’s my data: The Open Data Protocol (OData) 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.
Steve Hughes is a Principal Consultant at Magenic. His area of expertise is in data and business intelligence architecture on the Microsoft SQL Server platform. He was also the data architect for a SaaS company which delivered a transportation management solution for fleets across the United States. Steve has co-authored two books and delivered more than 30 presentations on SQL Server and data architecture over the past six years. He also provides insights from the field on his blog at http://www.dataonwheels.com.
Optimizing Microsoft SQL Server Performance in a Virtual Environment 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.
Denny Cherry is an independent consultant with over a decade of experience working with platforms such as Microsoft SQL Server, Hyper-V, vSphere and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication and troubleshooting. Denny currently holds several of the Microsoft Certifications related to SQL Server for versions 2000 through 2008 including the Microsoft Certified Master for SQL Server 2008 as well as being a Microsoft MVP for several years and a VMware vExpert.