Realiza-se no dia 27 de Novembro de 2018, o 104º Encontro da comunidade SQLPort, que tem como objectivo a partilha de experiências e conhecimento entre os profissionais e entusiastas de SQL Server em Portugal. O evento vai ser realizado nas instalações da Create IT in Lisbon, sendo a entrada livre para todos os inscritos.
Avenida da Igreja
nº 42 12º Esquerdo
19:00 “Query Optimization Explained in 15 Demos” – Erik Darling (Consultant @ Brent Ozar Unlimited)
20:30 “ADR – Accelerated Database Recovery” – Vitor Pombeiro (CSS Azure SQL Database Support Engineer @ Microsoft)
22:00 Jantar livre
You’ve got the hang of writing queries and creating indexes, but once you hit F5 you have no idea what’s going to happen.
* Why did I get that plan?
* Why didn’t you use that index?
* Why are you slow?
In this session, we’ll look a little deeper into query optimization, and why SQL Server makes the choices it does.
This will be fast-paced, demo-heavy and slide-light.
Erik Darling started using SQL Server after a dispute with Excel over a vlookup. Since then he’s been a developer at a market research company and a DBA for an eDiscovery shop. He enjoys arguing with the Optimizer and contributing to the First Responder Kit.
Accelerated Database Recovery (ADR) is a new SQL Server Engine feature (available in Azure SQL, Azure SQL Data Warehouse, and in the upcoming version of SQL Server on-premises) that greatly improves database availability, especially in the presence of long running transactions, by completely redesigning the current SQL Server recovery process from the ground up.
Vitor Pombeiro is a Azure SQL DB Support Engineer at Microsoft.
Working with SQL Server since version 7.0 and before that with SQL Anywhere.
Working in the clouds with SQL Server and Azure SQL DB, DW, MySQL and PostgreSQL.