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

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

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

  • “ 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. ”

  • “ Again I really love this conference. I appreciate the high level of speakers and sessions. ”

  • “ 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. ”

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

  • “ This is THE tech conference in the NAV universe! As in the years before there is a lot of interesting input. All and all it is well organized conference, which I really like to attend for four years in a row now. ”

  • “ 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. ”

  • “ 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. ”

  • “ Great conference. The must attend conference for NAV developers. From a sponsor perspective this is the conference to sponsor if your target audience is technical decision makers. The NAV TechDays audience is full of CIOs, CTOs, IT Managers, developers, technical people from VARs. ”

    Susanne Priess , Mergetool.com , United States

  • “ 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. ”