Bill Emmert


William Emmert, Technical Director/Technology Architect, Microsoft Technology Center, Microsoft Corporation
Technical Director and SQL\BI Architect in the Philadelphia Microsoft Technology Center (MTC) in Malvern, PA. He started his career at Microsoft in 1998 in Consulting Services focusing on design, development, testing, deployment and troubleshooting SQL Server OLTP and OLAP solutions. In 2007, Bill worked on the SQL Server product group for 1 year as a member of the SQL Server Customer Advisory Team (SQLCAT) returning back to consulting in 2008. In 2010 he joined the New York MTC as a SQL Architect before taking on his current roles in the Philadelphia MTC in 2011.

Bill has worked in the computer industry for 28 years with experiences in mainframe software support & development, network architecture and administration, client server application development, project management, consulting, IT management and database administration, development and architecture.

He has a bachelor’s of Business Administration in Marketing from Adelphi University (NY) and a Master’s of Science in Information Systems from Penn State University (PA).

Elastic Scale for Azure SQL Database – Overview

Saturday, March 21st, 2015 at 11:30 am in

Abstract: Now in Preview, Elastic Scale for Azure DB offers a set of features that make it easier to build and manage a sharded data tier for cloud applications that can grow and shrink database capacity on demand. Delivering on this the key promises of cloud computing used to be challenging in particular for the database tier. Over the last few years, the industry has converged on sharding as a well-established design pattern for cloud applications. Elastic Scale adopts the general sharding pattern and significantly simplifies building and managing sharded applications for Azure SQL DB.

In this session, we are going to explore workloads that are a natural fit for sharding and Azure SQL DB Elastic Scale. Workloads discussed in depth include multi-tenancy as well as telemetry and sensor data processing. We will use capabilities from the Elastic Scale preview to make developing, scaling and managing sharded applications on Azure SQL DB much easier. The capabilities discussed in the session include shard management, data dependent routing, querying across shards and elastic capacity at the data tier in Azure SQL DB.

Objectives: 1. Identify workloads that will benefit from Elastic Scale. 2. Guide you on how to apply sharding to your data tiers.

SQL Server 2014 In-Memory OLTP: DB Developer Deep Dive

Saturday, November 23rd, 2013 at 10:00 am in 305

SQL Server 2014 introduces in-memory technology for optimizing OLTP workloads. In this DB developer focused session, we discuss the new memory-optimized tables and indexes. You will learn how to access memory-optimized tables using interpreted Transact-SQL, and how to optimize data access using the new natively compiled stored procedures. Finally, you will learn how to work with the new lock-free transaction semantics for in-memory OLTP.

Moving Databases to SQL Azure

Wednesday, September 21st, 2011 at 5:30 pm

In this session, Bill will walk through step-by-step how to migrate an existing on-premises SQL Server 2008 R2 database to the Microsoft cloud database version of SQL Server, called SQL Azure