2013-3-20 6:55

The NAV/SQL Performance Field Guide - E-Book

Hi folks! It has been a very long time, since the last release of the " NAV/SQL Performance Field Guide " in 2009 ... mea culpa ... Reason is - or actually was - some struggle about the contract with my publisher: many people were asking to get the PFG as an E-Book, but so far it wasn't possible - until now! From today (20th March 2013) on the PFG is indeed available on paper and as an e-Book (Kindle, iBook, etc.) Please regard that this is still the old version from 2009 . As this...
Posted by Jörg A. Stryk | 1 comment(s)
Filed under: ,
2012-11-29 12:00

NAV Developer's Day - Update

Ankündigung: Microsoft plant aktuell die Durchführung eines " NAV Developer's Day " (vorläufiger Arbeitstitel ) Edit 30.10.2012: Achtung - Terminänderung! Stattfinden soll die erste Veranstaltung am 08. November 2012 17. Dezember 2012 (Abends) im Microsoft HQ in Hamburg - nähere Details folgen noch. Eingeladen sind alle an NAV interessierten Entwickler, Administratoren etc., egal ob Dynamics Partner oder Anwender. MS kümmert sich um die Organisation, den...
Posted by Jörg A. Stryk | 12 comment(s)
Filed under: , , , , , ,
2012-9-28 12:00

NAV TechDays 2012 - Understanding Blocks & Deadlocks with NAV & SQL Server

Blocks and Deadlocks are a major issue in NAV/SQL systems; causing decreased performance and poor user experience . This session will explain the locking mechanisms with Dynamics NAV and SQL Server and how they could be properly used. Further it will be demonstrated how blocks & deadlocks could be easily monitored and analyzed to get clues about the problem’s origin and to find appropriate solutions. Some practical examples will highlight common problems and give inspiration for practicable...
Posted by Jörg A. Stryk | 8 comment(s)
Filed under: , , , , ,
2012-9-21 9:00

NAV 2013 Beta (Refresh) – First Impressions

Normal 0 false 21 false false false DE X-NONE X-NONE So, finally the first public „Beta“ of “ NAV 2013 ” is available … https://mbs.microsoft.com/partnersource/newsevents/news/msdnav2013betadownload.htm http://msdn.microsoft.com/en-us/library/hh173988(v=nav.70).aspx … so I also have started to check it out! Of course, as usual my focus is on the NAV/SQL technical site Those of you who have access to MS Connect are encouraged to provide feedback, as well. The...
Posted by Jörg A. Stryk | 3 comment(s)
Filed under: , , ,
2012-7-14 9:58

Dynamics NAV on SQL 2012

Hi folks, you should be aware that Microsoft has just published some statement regarding Compatibility of Dynamics NAV 2009 SP1/R2 with SQL Server 2012 Check out the NAV Team BLOG and Partner Source about details! But have in mind, that MS just checks/proves/grants compatibility with currently supported versions of NAV - which is NAV 2009 SP1 and R2 . E.g. the Mainstream Support for NAV 4.0 SP3 endet several years ago, and for NAV 5.0 SP1 it ended in April this year. As you could also read from the...
Posted by Jörg A. Stryk | with no comments
Filed under: ,
2012-5-23 11:15

MSDynamics.de Konferenz 2012

Am 09. Mai fand ja parallel zur " Tectura Convention 2012 " auch erstmals unsere " MSDynamics.de Konferenz " statt! WIr waren zwar ein kleinerer Kreis, hat aber viel Spass gemacht mal ein paar Gesichter hinter den Forums-Beiträgen zu sehen Ich durfte ja auch einen kleinen Vortrag zu Besten geben, den Folienfilm etc. dazu findet ihr hier im Anhang. Mehr dazu - auch ein paar Bilder von Kowa - hier: http://www.msdynamics.de/viewtopic.php?f=16&t=14984
Posted by Jörg A. Stryk | with no comments
Filed under: , , , , ,
2012-1-30 15:28

Tectura Convention 2012

Ich werde hier einen kleinen Vortrag zum Thema " Hochverfügbarkeit mit NAV & SQL " halten Im Rahmen dieser Veranstaltung - soz. als " Event im Event " - findet auch die " MSDynamics.de Konferenz " (09.05.2012) statt. Achtung : dieser Community-Event hat nur Platz für 20 Personen , also schnell anmelden!
Posted by Jörg A. Stryk | 1 comment(s)
Filed under: , , , , ,
2012-1-13 8:44

Directions EMEA 2012 - Blocks & Deadlock

The major event for Dynamics Partners in Europe; 25th to 27th April 2012 in Rome. Check out the website for detailed information: http://www.directionsemea.com Looking forward to meeting you in Rome
Posted by Jörg A. Stryk | 1 comment(s)
Filed under: , , , , ,
2011-10-4 19:22

Using SQL Server Audit

A guest BLOG article published on " Microsoft Dynamics Community " forum: https://community.dynamics.com/product/nav/navnontechnical/b/navguestcolumn/archive/2011/09/27/using-sql-server-audit.aspx
Posted by Jörg A. Stryk
Filed under: , , ,
2011-9-29 16:00

NAV TechDays 2011 - Understanding Keys & Indexes with NAV & SQL Server

29th to 30th September 2011 in Antwerp (Belgium) Abstract : With Dynamics NAV and SQL Server it is important to understand how “ Keys ” and “ Indexes ” actually work; how they could/should be used within the C/AL code, which problems they could cause and how those could be solved. “Indexes” could have a dramatic impact on the system’s performance, thus learning to optimize them could give a huge benefit. The session will explain the general aspects of “Indexes”...
Posted by Jörg A. Stryk | with no comments
Filed under: , , , , ,
2011-6-16 14:00

Decisions Spring 2011 - NAV Programming with SQL Server

16th June 2011; Online Virtual Conference Abstract : Today the NAV application is designed to be runnable on two different database servers: the proprietary C/SIDE Server and SQL Server . Due to some “ history ” the code has a higher affinity to the native server which may result in performance issues with SQL Server – the older the C/AL code, the more problems could be expected. This session will give some practical examples to explain how to avoid SQL performance issues by appropriate...
Posted by Jörg A. Stryk | with no comments
Filed under: , , , ,
2011-5-13 10:00

Directions EMEA 2011 - High Availability Options with NAV and SQL Server

11th to 13th May 2011 in Berlin (Germany) Abstract : With increasing transaction volumes processed by NAV customers the need for HA solutions also growing. This session will explain some available HA solutions with NAV and SQL as there are e.g. “ Transaction Log-Shipping ” and “ Mirroring ”, but also in addition with using “ Database Snapshot ”. The advantages and disadvantages of the several solutions are discussed to inspire NAV partners to implement the appropriate...
Posted by Jörg A. Stryk | 2 comment(s)
Filed under: , , , , ,
2011-2-15 12:02

Data Compression

Just recently Michael De Voe from the MS Dynamics NAV team has published a great article about the DATA COMPRESSION – a feature introduced with SQL Server 2008 ( Enterprise feature). I highly recommend to read this article first ( Thanks a lot, Michael! ): http://blogs.msdn.com/b/nav/archive/2011/02/11/microsoft-dynamics-nav-and-sql-server-database-compression.aspx There are also several discussions about this feature on http://dynamicsusers.net and http://www.mibuso.com But I'd like to...
Posted by Jörg A. Stryk | 8 comment(s)
Filed under: , , , ,
2010-12-2 8:28

Block & Deadlock Detection – Updated Scripts

Hi there, many of you are using the templates for Block & Deadlock Detections provided on MIBUSO ( http://www.mibuso.com/dlinfo.asp?FileID=1182 ) or with these BLOG articles: http://dynamicsuser.net/blogs/stryk/archive/2008/11/03/blocks-amp-deadlocks-in-nav-with-sql-server.aspx http://dynamicsuser.net/blogs/stryk/archive/2010/05/19/decisions-spring-2010-nav-sql-performance-blocks-and-deadlocks.aspx Due to your great feedback the current versions of these procedures etc. are somewhat improved...
Posted by Jörg A. Stryk | with no comments
Filed under: , , , ,
2010-11-10 9:25

Transferring SQL Server Logins

Well, this is going to be a rather short one, but as I frequently come across this issue I'd like to put it here. If you are using a second (or third, etc.) SQL Server instance, e.g. as Standby-System, Mirror, Test-System or whatsoever you encounter the problem of " How to automatically transfer the SQL Server Logins to the remote Server? " While the Users (aka " database principals ") are actually copied with the Database-Backup, the Logins (aka " server principals "...
Posted by Jörg A. Stryk | 2 comment(s)
Filed under: , , , ,
More Posts Next page »