I recieved the slides from one of the attendees (thanks Bram De Daele ). It isn't available for download though, so just updated some sections below.
The second edition of the Belgian MSDN/Technet sessions was even more successful than the first. About 50 people registered, and about 45 of them showed up. That's quite a few for a small country like Belgium . This was to expect, because the topic is quite hot at the moment.
This year, I have been involved in quite a few opportunities involving SQL Server Performance Tuning with iFacto. To keep a long story short, all of my work is based on knowledge, methodologies and tools from SQLPerform. For me, it has worked 100%, so I'm very happy to be able to work with them.
Now, I wondered: are the other parties following the same strategy? Are they using the same tools, the same reasonings, the same logic, ... ? So I was very interested in what Steven from Plataan had to say about SQL Server Performance tuning.
Now, I have been writing quite a bit about this topic on my blog and on Mibuso, so I will just try to highlight some of the similarities and contradictions... . To start with ... you can find some of my postings here:
I must say, for 95% of all things he covered, I had no problem with. Most of the topics he covered corresponded with the things I learned in the past. And you probably agree, definitely for a topic like this, the confirmation that what you apply in real life corresponds to what others are teaching, is always nice .
There were some new highlights that were quite interesting:
If you have several companies and many users in the same database, the synchronization process will be slower with Enhanced Security.
Windows groups displayed
Local domain + forest of domains
Local domain only
Logins required in Navision
Windows groups and individual Windows users
Windows Groups + the members of each group and individual Windows users
Granularity of Synchronization
Entire security system
Entire security system and individual logins.
Automatic synchronization when you insert, modify or delete a Windows login or a database login in Navision.
Required Extended Stored Procedure
Furthermore, there were just a few things that did not sound very similar with the info I already got:
@ Find statements: let's just say that things are not clear yet, and are still not clear for many people .
I did not get a message yet, but thanks already .
@ Find statements: Steven said MS is "beginning to" replace the FIND('-') with FINDFIRST where necessary, in their new development and in the code they "review" (that's what I understood).
He DID say that these 2 statements did two different things... :-)
If you need the ppt, I can send it to you (left you a message via "contact").