Aug 14: IAAS+ capabilities of Windows Azure

Peter Petesch
Principal Program Manager Lead, Microsoft
IAAS+ capabilities of Windows Azure

With Windows Azure, you can spin up new Windows Server and Linux virtual machines in minutes and adjust your usage as your needs change. With a pay-as-you-go approach, you only pay for what you use and there are never any penalties for changing your virtual machine configurations. With IAAS added to an already robust PAAS, new generations of applications for mobile, modern applications can be built while leveraging many core infrastructure server components including feature rich SQL Server configurations from an existing on premise architecture. IAAS+ enables leveraging existing infrastructure & protecting existing investments while enabling modern Azure based applications to be built around these environments.

Peter Petesch (Blog | LinkedIn | Twitter) is an industry veteran with 23 years with Microsoft and with over 30 years in the IT world including 7 years at IBM. Pete is currently responsible for all Customer Programs for Microsoft’s worldwide SQL Server and Windows Azure. Pete is responsible for driving feedback and product validation working with select customers and engineering teams.

Pete was previously a Principal Architectural Engineer on the Pacific Northwest and Western Region eCommerce and Technology Teams and an Architectural Engineer in Microsoft’s Pacific Northwest office. Pete’s prior positions at Microsoft include one of the original product managers for ODBC in the Developer Division. Pete Petesch joined Microsoft as a systems engineer with the initial launch of SQL Server 1.1 and LAN Manager 2.0 in April, 1990.

Prior to Microsoft, Pete was a Systems Engineer for IBM in Seattle. Pete was responsible for the early implementation of LANs, PS/2, OS/2, and AS/400 technical marketing. Pete also had several years programming experience with IBM as an IMS & CICS developer building distributed database applications for manufacturing in Poughkeepsie, NY.

Pete has an undergraduate degree in Computer Science from Washington State Universidty and an MBA from the University of Washington.

Claim your 30 day free trial of Azure

Get FREE Azure and SQL Server Training at Microsoft Virtual Academy

Arnie Rowland
Using Schemas for Security
In releases prior to SQL Server 2005, database object owners and users were the same things. SQL Server 2005 introduced the concept of database schemas and the separation between database objects and ownership by users. An object owned by a database user is no longer tied to that user. The object now belongs to a schema – a container that can hold many database objects. The schema owner may own one or many schemas. This concept creates opportunities to expose database objects within a database for consumption yet protect them from modification, direct access using poor query techniques, or removal by users other than the owner.

The ability to protect database objects in this way has many practical applications. One example of relevance is the protection of database objects in application development environments where developers and testers share the same set of database objects. Another example of protecting database objects is in ISV products such as Siebel or SAP. Unmanaged access by ad hoc queries or poorly tuned queries of the base objects will negatively impact the performance of the application. Additionally, the use of schemas can help to combine entities from separate applications or functional areas, or logical groups, into a single physical database.

Arnie [ Blog | LinkedIn | Twitter ] is a Senior Moderator on the MSDN and TechNet SQL Server related Forums, founding member of the TechNet Wiki Governing Council, founder, and current president of the Oregon SQL User group, co-Founder of the Portland Code Camp, and has been the lead facilitator for SQLSaturday Oregon events.