mibuso.com

Microsoft Business Solutions online community
It is currently Sat Nov 01, 2014 9:50 am

All times are UTC + 1 hour




Post new topic Reply to topic  [ 12 posts ] 
Author Message
 Post subject: [Good Posting!] NAV on SQL Server - Maintenance and Setup Essentials
PostPosted: Tue Mar 13, 2012 6:28 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jan 02, 2003 5:37 pm
Posts: 7993
Location: Flagstaff, AZ
Country: United States (us)
At Convergence 2012 in Houston I'll be part of a session about best practices for NAV database setup and maintenance on SQL Server. In preparation for this session I've created a couple of videos:

Essential Maintenance: http://www.youtube.com/watch?v=0KbZkKdyZps
Setup Essentials: http://www.youtube.com/watch?v=pOIjde-xpz4

_________________
Daniel Rimmelzwaan
KCP Dynamics
MVP - Dynamics NAV


Top
 Profile  
 
 Post subject: Re: NAV on SQL Server - Maintenance and Setup Essentials
PostPosted: Tue Mar 13, 2012 9:49 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Tue Jul 19, 2005 3:49 pm
Posts: 4185
Location: Olst
Country: Netherlands (nl)
Have fun!

_________________
Mark Brummel | Freelance Dynamics NAV (Navision) Specialist

Read my new book: Microsoft Dynamics NAV 2013 Application Design

MY BLOG : http://markbrummel.wordpress.com


Top
 Profile E-mail WWW  
 
 Post subject: Re: NAV on SQL Server - Maintenance and Setup Essentials
PostPosted: Wed Mar 14, 2012 5:49 pm 
Offline

Joined: Fri Aug 06, 2004 8:30 pm
Posts: 1068
Location: Richardson
Country: United States (us)
I will put your session on my list.
See you there. :thumbsup:

_________________
David Machanick
http://mibuso.com/blogs/davidmachanick/


Top
 Profile  
 
 Post subject: Re: NAV on SQL Server - Maintenance and Setup Essentials
PostPosted: Thu Mar 15, 2012 12:01 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 11, 2004 8:05 pm
Posts: 5013
Location: Los Angeles, CA
Country: United States (us)
What software did you use to record the session?

_________________
Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work

Getting Started with Dynamics NAV 2013 Application Development = my book


Top
 Profile E-mail WWW  
 
 Post subject: Re: NAV on SQL Server - Maintenance and Setup Essentials
PostPosted: Thu Mar 15, 2012 1:26 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jan 02, 2003 5:37 pm
Posts: 7993
Location: Flagstaff, AZ
Country: United States (us)
Camtasia Studio. The one with the bad audio was because it was set to pick up the system mic instead of my headset.

_________________
Daniel Rimmelzwaan
KCP Dynamics
MVP - Dynamics NAV


Top
 Profile  
 
 Post subject: Re: NAV on SQL Server - Maintenance and Setup Essentials
PostPosted: Thu Mar 15, 2012 2:02 am 
Offline

Joined: Fri Aug 06, 2004 8:30 pm
Posts: 1068
Location: Richardson
Country: United States (us)
Just watched both of your videos and I see you already answered the question I had - what did you use.

When it comes to basics, I like to recommend standard security and Case Insensitive (easier for external sql queries, and more standard with non-NAV SQL Server).
How do you feel about this?

Look forward to more of your videos.

_________________
David Machanick
http://mibuso.com/blogs/davidmachanick/


Top
 Profile  
 
 Post subject: Re: NAV on SQL Server - Maintenance and Setup Essentials
PostPosted: Thu Mar 15, 2012 7:11 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Oct 16, 2003 7:50 am
Posts: 12442
Location: Brno
Country: Czech Republic (cz)
E.g. Case-Insensitive is basics for Czech databases, because else NAV have problem with searching for specific texts including character "ch" (one char in Czech alphabet, two chars in NAV, case-insensitiveness helps NAV to search correctly when you enable the "Match Case" option).

_________________
Kamil Sacek
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.


Top
 Profile E-mail WWW  
 
 Post subject: Re: NAV on SQL Server - Maintenance and Setup Essentials
PostPosted: Thu Mar 15, 2012 8:43 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Tue Aug 14, 2001 6:01 am
Posts: 5349
Location: Prague
Country: Czech Republic (cz)
davmac1 wrote:
When it comes to basics, I like to recommend standard security and Case Insensitive (easier for external sql queries, and more standard with non-NAV SQL Server).
How do you feel about this?


Yes I agree those need to be there, as well as at least touching on Recovery modes.

_________________
David Singleton
Dynamics NAV Freelancer
Dynamics Book
Go-Live International


Top
 Profile E-mail WWW  
 
 Post subject: Re: NAV on SQL Server - Maintenance and Setup Essentials
PostPosted: Thu Mar 15, 2012 6:08 pm 
Offline

Joined: Thu Jul 17, 2003 9:52 pm
Posts: 639
Location: Capelle a/d IJssel
Country: Netherlands (nl)
Thank you for the time making this. :thumbsup: Now it's easier to explain to others.

_________________
Create dynamic Excel or Word documents, ReportX


Top
 Profile  
 
 Post subject: Re: NAV on SQL Server - Maintenance and Setup Essentials
PostPosted: Fri Mar 16, 2012 1:18 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jan 02, 2003 5:37 pm
Posts: 7993
Location: Flagstaff, AZ
Country: United States (us)
Thanks for the compliments guys :mrgreen:

My intention with these two videos was to focus solely on SQL Server, and I wasn't planning to address any settings in the NAV client at all, opening that kind of happened in the spur of the moment. They both come in at around 15 minutes and I thought that was enough as it is anyway :wink:

As far as the collation I don't really care about that, I've never had any issues with the default one, since the databases that I work with are all in the US and the default collation is fine for those. For sure if you are on an international database you have to be aware about the implications of the collation, but since I don't work with that I don't feel that I am qualified to say anything about it.

The security model should definitely be set to standard. I'll put together another video to go into more detail about database settings in the NAV client.

_________________
Daniel Rimmelzwaan
KCP Dynamics
MVP - Dynamics NAV


Top
 Profile  
 
 Post subject: Re: NAV on SQL Server - Maintenance and Setup Essentials
PostPosted: Tue Mar 27, 2012 9:39 am 
Offline

Joined: Tue Oct 04, 2011 9:26 am
Posts: 94
Country: Belgium (be)
Txn, wass looking for something like this a few weeks ago, when I had to look into how to migrate from Native to SQL and what would be needed to set it up & maintain it.

Off course, the moment I wanted to put in my findings, the manager of the IT department decided we're going to keep using native.


Top
 Profile E-mail  
 
 Post subject: Re: NAV on SQL Server - Maintenance and Setup Essentials
PostPosted: Tue Mar 27, 2012 5:43 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 11, 2004 8:05 pm
Posts: 5013
Location: Los Angeles, CA
Country: United States (us)
The video is some serious MVP stuff. :thumbsup:

This is what MVPs are about, giving useful information to the community without asking anything in return. =D>

_________________
Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work

Getting Started with Dynamics NAV 2013 Application Development = my book


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 12 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: