Data Platform User Group (SQLWatch.io. PowerBI, DBA, Azure Managed Instances)-

Join fellow IT Professionals for an evening of knowledge sharing and networking in an open, friendly environment.

17:30 – 18:00 – Networking (drinks)
18:00 – 19:00 – Marcin Gminski (sqlwatch.io)
19:00 – 19:20 – Break (pizza / top up)
19:20 – 20:20 – John Martin (SentryOne)
20:20 – 20:30 – Off t’pub.

Marcin Gminski (sqlwatch.io) | SQLWatch Overview
SQLWATCH is free and community-driven SQL Server performance monitor, available for SQL Server 2008R2 to 2017. SQLWATCH collects your server performance metrics, database growth and disk space, index statistics and more. In this session, we will go through the conceptual design, installation, data collection and reports. You can download it free from https://sqlwatch.io/

Marcin is an independent SQL Server consultant specialising in performance, development, disaster recovery and data migrations. Following his degree in Computer Science, Marcin has gained over 15 years of experience and knowledge of technical architecture, data analysis, logical and physical design, coding, performance testing, implementation and support whilst working with SQL Server as well as Oracle and DB2 for global brands like Lloyds Banking Group, Wal-Mart, NHS and Solera Holdings.

John Martin (SentryOne) | Azure Managed Instances

Azure SQL DB Managed Instance is here, Microsoft want us to use it, but what is it good for and how should you use it? Let us get past the marketing hype and take a more in-depth look at Managed Instance and see what we can do with it.

To get the most out of Managed Instance you need to understand the Azure infrastructure that underpins it and how this behaves, as well as understanding the differences between General Purpose and Business Critical tiers.

There is far more to Managed Instance than meets the eye and if you do not understand the details then you run the risk of spending a lot more money and not getting the performance you want.
During this training day we will cover the core Azure infrastructure components that underpin Managed Instance and look at how these can impact its usability and performance. We will work through use cases and migration scenarios that are available for us to use when it comes to making the jump to Azure. We will also look at how applications that use with SQL Server on-premises can be updated to get the most out of Managed Instance, including authentication and high-level architecture.