-
Besides the advantages mentiones above, working on Sql gives you many more possibilities to integrate with third party tools. Using the 'native' database you have ODBC, or the NAS or CFRONT, but these are not so straithforward. Reporting Services is really nice and 'easy' to integrate...
-
Hi, my two pence worth ... Personally, the performance issue is factored by size of installation. I have worked with companyies that were happy to stay with the native database because there were maybe 5-10 users and the company did not want the expense of upgrading to SQL Server - and performance was...
-
[quote user="girish.joshi"] 1. Active Directory management - this can be a huge plus for managing security. In addition to streamlining an enterprises security it also allows for passwords that expire. [/quote] "WIndows Authentication" (ie. Active Directory) is not a SQL Only feature...
-
1. Active Directory management - this can be a huge plus for managing security. In addition to streamlining an enterprises security it also allows for passwords that expire. 2. SQL Backups - incomparably more effective as part of Disastor Recovery model because of the speed of the backup and restore...
-
OK, over the last couple of weeks I have been asked, more than once, 'so if I go to SQL, what can I do, that I can't do on Native'? I started to ponder on this, did a bunch of searching, but couldn't find a definitive list. I thought I would get your thoughts on this and put my two cents...