SQL Server Data Tools (SSDT) is an evolving product. Besides revamping database projects this product has also changed the lifecycle in which we receive new features. In this session we demonstrate features such as database snapshots, localdb, and database unit testing. Most importantly, we show the many benefits of the Publish feature, and why you will want to use the built-in refactoring instead of just renaming objects. Throughout this presentation we also highlight and demonstrate the features that have been added to SSDT in the past year.
In the new scenarios where cloud is getting used, integration becomes very important. Luckily, the Windows Azure platform provides a lot of different capabilities and services to make a secure link between your local systems and the Windows Azure services or machines. In this session, an overview will be give of the different technologies and the scenarios to which these technologies are best applicable. The following technologies will be demonstrated and discussed: * Connectivity on messaging level: Service Bus Messaging * Connectivity on service level: Service Bus Relay * Connectivity on data level: SQL Data Sync * Connectivity on network level: Windows Azure Virtual Networking * Connectivity on security level: Active Directory integration