16 & 17 november 2017
Antwerp (Belgium)

speakers

Below is a list of all amazing speakers, who will host a session at the conference…

Jump to list

Jörg Stryk

Germany


STRYK System Improvement
SQL Server Performance Optimization and Troubleshooting

Jörg A. Stryk works with Microsoft Dynamics NAV since 1997, version 1.20.Since 2003 he is 100% focusing on “Dynamics NAV & SQL Server Performance Optimization and Troubleshooting”, founding his company “STRYK System Improvement” in 2006.

As a freelance consultant, he is supporting Microsoft Dynamics partners and customers with their NAV/SQL projects worldwide.

He was writing the book “The NAV/SQL Performance Field Guide” (ISBN 978-3-8370-1442-6) and is developing the “SSI Performance Toolbox”, an optimization utility which is used and distributed by many Dynamics partners/customers around the globe.

Hosted sessions

C/AL, Coding for Performance
LEVEL: 400 - Expert
LEVEL: 300 - Advanced
Room 8

There are several misunderstandings, confusions or “fake-news” around, when it is about C/AL programming and how it affects performance on SQL Server. Time to clean this up!

In this session we will explain some “DOs & DONTs” of programming NAV; showing best-practices in using certain methods and how to avoid common mistakes.

Further we will give some guidance about how to identify and troubleshoot query and code bottlenecks. Make your C/AL code rock!

Troubleshooting Essentials for SQL Server and Dynamics NAV
LEVEL: 400 - Expert
LEVEL: 300 - Advanced
Conference Hotel

The first part of the workshop will focus on resolving so called “Expensive Queries”. You will learn about the importance of “Keys” and “Indexes”, how to detect problems related to them and how to implement appropriate solutions. According to this, you will get an introduction of several useful tools, like “SQL Profiler”, “SQL Trace”, TSQL/DMV etc. and some pretty cool 3rd party tools.

The second part of the workshop will explain the concept of locking mechanisms in SQL Server and how to deal with it in NAV. You’ll learn how to detect blocks and deadlocks, using on-board features and 3rd party tools. Finally you’ll get some inspirations about how to resolve and prevent blocking problems.

Prerequisites:

  • Skill 300-400 (Advanced – Expert)
  • Attendees need to have some knowledge about SQL Server and TSQL, and of course Dynamics NAV programming.
  • Technical workshop environment:
    • Bring your own Laptop!
    • You need to have a pre-installed up-running NAV/SQL Installation – any SQL Version (2005 to 2014) and any NAV Version (4.0 SP3 to 2016) will do.
    • The SQL “Edition” should be at least STANDARD, DEVELOPER or ENTERPRISE; incl. SQL Agent, Management Studio, SQL Profiler, and “Books Online”.
    • If available, bring your NAV Developer’s License.
    • Important information: you probably WILL NOT be able to access any remote NAV/SQL installation via RDB, VPN, GTM, TV or something – you’ll need a local installation!

Workshop date: Tuesday 14 November or Wednesday 15 November. This is a one day workshop.


Other Speakers

platinum sponsors

I want to participate

other sponsors

  • “ GREAT job!! I kick myself for waiting until last year to go ”

  • “ The best of NAV TechDays is the more than sensational session environment both as a speaker and as an attendee. It allows attendees to really focus and it makes it worthwhile for speakers to prepare. ”

  • “ Absolute eye-opener. It helps to overcome fears of the unknown and stimulates the envy to try out new things. I am really very grateful to NAV TechDays and especially Luc Van Dyck to make this happen. ”

  • “ As in the years before, the best place to get concentrated information about the upcoming technical road path and current development issues without any marketing mumbo-jumbo. That the group of the speakers is a blend with people from Microsoft and independent Partners alike is also an great asset to this event. ”

  • “ Overall I thought it was very high quality, only one session I thought was a little too much of a stretch, but that's just my opinion, a very good event. Well worth the money. ”

  • “ The best of NAVTechDays is the unique opportunity to meet fellow technically-inclined professionals, and being able to deep-dive into all things new. ”

  • “ The pre-conference days were probably the highlight. The sessions that were run by experts in their areas were phenomenal. ”

  • “ The venue is great. There is nothing out there as comfortable as the Kinepolis rooms, and I LOVE the way the slide decks is mixed in with video of the presenter on the screen. ”

  • “ The whole event is fantastic. I REALLY loved the pre-conference workshops, so I was very happy to hear that there will be two days next year. The food was great, the accommodation is great, SUPER seats and screen, having the sessions on video later is icing on the cake. ”

  • “ Feeling part of the NAV community, and awareness of new tools and paths for the present and future. Thanks A LOT for arranging this great event. ”