2012-1-30 15:28

Tectura Convention 2012

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 hat nur Platz für 20 Personen , also schnell anmelden!
Posted by Jörg A. Stryk | 1 comment(s)
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 | with no comments
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 | 5 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: , , , ,
2010-11-3 14:00

Decisions Fall 2010 - Some cool SQL features

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:QP!14100&EventKey=28894&EventAttendeeKey=2296560&RandomValue=1289395987324
Posted by Jörg A. Stryk
Filed under: , , , ,
2010-10-22 11:07

Solving Blocking Issues – Practical Examples

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 mind that "blocking problems" is often a very individual thing, depend on code and business processes or user interaction … Thus, this should be some kind of starting point, hopefully...
Posted by Jörg A. Stryk | 12 comment(s)
Filed under: , , , ,
2010-10-6 0:00

„NAV/SQL Quickies“ on MSDynamicsWorld.com

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 be as long and detailed as my BLOG uses to be. But as I'm lacking any " gossip capabilities " it will be somewhat "technical" anyway. (Please regard that the articles might be...
Posted by Jörg A. Stryk | with no comments
Filed under: ,
2010-5-29 11:20

Optimizing SIFT and VSIFT

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 ", hence it is a technology used to display " FlowFields " in NAV. The idea of "FlowFields" (FF) is to not save any sum-values within a table, but to calculate these sums "on...
Posted by Jörg A. Stryk | 4 comment(s)
Filed under: , , , ,
2010-5-25 9:02

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

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 flattered - thank you all so much for voting for me! And congratulations to all others who made it on " The List " Cheers, Jörg
Posted by Jörg A. Stryk | 3 comment(s)
Filed under:
2010-5-20 11:00

Directions EMEA 2010 – NAV/SQL Performance: Indexes

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-airlift-2009-munich-nav-sql-performance-optimization-indexes.aspx The scripts & templates (attached) have been improved. ALL SCRIPTS, TEMPLATES ETC. ARE PROVIDED "AS IS". NO WARRANTY, NO...
Posted by Jörg A. Stryk | 4 comment(s)
Filed under: , , , , ,
More Posts Next page »