NAV/SQL Performance - My Two Cents

Tectura Convention 2012

Jörg A. Stryk — Mon, 30 Jan 2012 14:28:00 GMT

Demnächst. 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...(read more)

Directions EMEA 2012 - Blocks & Deadlock

Jörg A. Stryk — Fri, 13 Jan 2012 07:44:00 GMT

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...(read more)

Using SQL Server Audit

Jörg A. Stryk — Tue, 04 Oct 2011 17:22:00 GMT

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...(read more)

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

Jörg A. Stryk — Thu, 29 Sep 2011 14:00:00 GMT

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...(read more)

Decisions Spring 2011 - NAV Programming with SQL Server

Jörg A. Stryk — Thu, 16 Jun 2011 12:00:00 GMT

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...(read more)

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

Jörg A. Stryk — Fri, 13 May 2011 08:00:00 GMT

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...(read more)

Data Compression

Jörg A. Stryk — Tue, 15 Feb 2011 11:02:00 GMT

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...(read more)

Block & Deadlock Detection – Updated Scripts

Jörg A. Stryk — Thu, 02 Dec 2010 07:28:00 GMT

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...(read more)

Transferring SQL Server Logins

Jörg A. Stryk — Wed, 10 Nov 2010 08:25:53 GMT

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...(read more)

Decisions Fall 2010 - Some cool SQL features

Jörg A. Stryk — Wed, 03 Nov 2010 13:00:00 GMT

Please find herewith the slides etc. to the session " NAV/SQL Performance - Some inspiration & cool features " presented at " Decisions Fall 2010 "; NAV Day on 3rd November 2010. Here the Link to the presentation video: https://vts.inxpo.com/scripts/Server.nxp?LASCmd=AI:1;S:17;F...(read more)

Solving Blocking Issues – Practical Examples

Jörg A. Stryk — Fri, 22 Oct 2010 09:07:00 GMT

Hi all, in previous BLOGS I was talking about general things like " blocking mechanisms ", " block/deadlock detection " or principal solutions. In this article I'd like to present some practical examples to really solve/prevent/reduce blocking and deadlocking issues! Having in...(read more)

„NAV/SQL Quickies“ on MSDynamicsWorld.com

Jörg A. Stryk — Tue, 05 Oct 2010 22:00:00 GMT

Recently I was asked by MSDynamicsWorld.com if I would like to write some articles for their website. Of course I would like I call this column " NAV/SQL Quickies " and I try to pick out several NAV/SQL related topics to put a brief spotlight on them; having in mind the articles should not...(read more)

Optimizing SIFT and VSIFT

Jörg A. Stryk — Sat, 29 May 2010 09:20:00 GMT

Well, I guess SIFT/VSIFT tuning is also some kind of standard task, and even though I previously – briefly - explained something about this I never got into the details. This is what I'd like to do now. 1. What's "SIFT"? SIFT is for " S um I ndex F lowfield T echnology "...(read more)

#13 of Top 100 Most Influential Dynamics People (2010)

Jörg A. Stryk — Tue, 25 May 2010 07:02:00 GMT

Wow, again! I just got the notice that the British Dynamics Community " Dynamics World " ( http://www.dynamicsworld.co.uk ) voted me on rank #13 of " The Top 100 Most Influential People in the Dynamics World 2010 "! I have to admit that I'm really proud about this and feel quite...(read more)

Directions EMEA 2010 – NAV/SQL Performance: Indexes

Jörg A. Stryk — Thu, 20 May 2010 09:00:00 GMT

Directions EMEA 2010 from 19 th to 21 st May 2010 in Prague/CZ. Website: http://www.directionsemea.com/ Well, actually this is not some new stuff, actually the presentation is quite similar (but stronger focus on indexes) than this one: http://dynamicsuser.net/blogs/stryk/archive/2010/02/10/technical...(read more)