SQL Server 2012 TAP: Lessons learned

2012

TL; DR

Coeo worked with Microsoft and European tour operator Sundio Group to migrate their mission critical, line of business application to SQL Server 2012. This session presents a case study of this project and the lessons learned from the experience.

Session Details

This session presents the approach, execution and lessons learned from the SQL Server 2012 upgrade project for Sundio Group - a leading European tour operator, based in Rotterdam, Netherlands.

The project was delivered by Sundio Group together with Coeo and assistance from Microsoft SQLCAT team through the early adoption TAP program.

This session will provide details of the approach adopted to de-risk the program, including functional and performance testing and areas where we were able to influence the SQL Server product features and design. The session will also includes details of issues encountered, lessons learned and recommendations for others considering approaching similar projects.

3 things you'll get out of this session

Ewan Fairweather's previous sessions

Building Big - In The Cloud

The Azure CAT team has successfully architected, designed and built hundreds of cloud projects. In this session we will share the learnings on how to design a cloud application to scale to handle large, complex workloads.

SQL Server in Windows Azure Infrastructure as a Service

Ewan Fairweather and Silvano Coriani from the SQL CAT team will take you on a tour of the new features that make up the Windows Azure Virtual Machines and Virtual Networks running SQL Server 2012 in a Virtual Machine.

High Scale OLTP - LL From SQLCAT Performance Labs

In this session, I will talk about the lessons we have learned and the methodology we follow when diagnosing and resolving issues with real customer workloads running on 64 and 128 logical cores

Justin Langford's previous sessions

5 Mistakes in Cloud Data Migration

We're fortunate in seeing tons of customers migrate to the cloud - this session covers major

Azure: Maxmise your bang for Buck

Considerations in how you buy Azure to provide maximum bang for buck

Serverless data solutions-what are they and when to use?

Azure introduces a range of new services for transaction processing and analytics solutions which mean we don’t need to deploy virtual machines. This session provides insight into how we see customers deploying evergreen and futureproof solutions.

Hybrid Data Solutions-how to have you cake and eat it!

We live in a cloud first World, but many organisation still run largely on-premise. This session covers how these organisations can begin their journey and leverage Azure data services.

Get started with troubleshooting SQL Server

This session present key tools, methodology and approach for troubleshooting SQL Server. Performance and availability of the database engine has a direct impact on user experience of applications.

DR with the Worlds largest data center

This session will look at providing cost effective DR capability with Azure.

Using Windows Azure to provide SQL Server Disaster Recovery

This session provides an architectural blueprint to deploying disaster recovery solutions combining on-premise and Windows Azure cloud technologies. The session looks at a design pattern to solve a long standing and often expensive issue of DR.

Hadoop, Big Data and SQL Server

There has been rapid development in the capabilities of SQL Server to support big data and hadoop following introduction of the HDInsight Service and HDInsight Server. This session covers SQL Server capability and integration points.

Notes from the field: Cross-team Performance Troubleshooting

This session will be presented jointly by Justin Langford and Gavin Payne . The focus of the session is the approach to a cross-team Performance Troubleshooting engagement where multiple stakeholders were involved.

Notes from the field: High Performance storage for SQL Server

This session provides an overview of a recent customer engagement to investigate storage performance problems and evaluate potential solutions. The session include details on measuring performance of the existing storage solution, profiling SQL Server disk IO activity and tools to simulate load and evaluate performance.