Fabiano is a Data Platform MVP, MCP for SQL Server 2000, MCTS and MCITP Data Base Developer for SQL Server 2005/2008/2012 and 2014. He also is a data platform MVP and actively involved in SQL Server community though forums, writes articles for Simple-Talk (https://www.red-gate.com/simple-talk/author/fabiano-amorim//), and he also presents online Webcasts and In-Person events around world (Brazil , Portugal, UK, Japan, Canada, US, India, Denmark, Belgium, Israel, Johannesburg…), he already spoke to more than 18 SQLSaturday events. He also wrote an e-book about SQL Server called “Complete ShowPlan Operators”.

Fabiano as a unique gift of presenting and teaching about very hard subject with so easy manners that the audience is able to understand the subject without any difficulty. Using this talent, he developed several trainings and presentations to teach people how to get the best from Databases technologies.

Fabiano Neves Amorim has submitted 6 sessions for SQLBits 2018, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

Query optimizer is getting smart, computers are taking DBAs jobs. In this session MVP Fabiano Amorim will talk about new “automatic” optimizations on SQL 2017. Adaptive query processing, auto tuning and few other features added into the product.
SQL is a tricky programming language, as a developer, DBA, or a SQL user, you need to know how to write a good T-SQL code. Come to this session to learn how re-write a query and see many tips on what to do to make queries execute as fast as possible.
If you are a developer+DBA, consultant+DBA, IT Manager+DBA, Intern+DBA, technical support+DBA or just a DBA, this session will be useful to you.
Tired to look at colored and nice shape plans? Want to go further and see geek stuff? Came to this session to explore the query trees, internals and deep analysis on execution plans on SQL Server.
In this session, I'll present some hidden and tricky optimizations that will help you to "speed-up" your queries. It all begins by looking at the query execution plan and from there, we'll explore the alternatives.
In this session the MVP Fabiano Amorim (@mcflyamorim) will show 7 different development techniques that you should avoid in case your company DBA suffer from some heart diseases.

Sessions

Previous Sessions

Once upon a time in a kingdom of darkness… SQL Server 2012 + Windows Functions… and they lived happily ever after… This session describes the improvements in Windows Functions T-SQL support from SQL Server 2005 through SQL Server 2012.
fabiano_neves_amorim.jpg