[TriLUG] ROI moving gov to Linux?

[William Sutton via TriLUG]

two comments:

1.  If I recall correctly, NetBackup still uses Sybase under the hood.
2.  MSSQL's row width limitation is a royal PITA, especially when you want 
to add a column to a production database table and it locks the table so 
that it can check EVERY. SINGLE. BLOODY. ROW. to make sure that the new 
column doesn't exceed that limitation.  I never had that problem with 
Oracle.  That and SSMS having autocommit enabled by default.  You should 
NEVER autocommit by default.

William Sutton

On Thu, 6 Sep 2018, Warren Myers via TriLUG wrote:

> If you had pgsql devs and DBAs, sure
>
> Odds are, though, you don't.
>
>
> SQL Server and Sybase diverged 23 years ago with SQL Server 6.0 in 1995, 
> completely eliminating any remnants of Sybase code 10 years later in 
> 2005. /Technically/ "Sybase" doesn't exist anymore (as of 2014 when SAP 
> dropped the name) ... but you still see it some places.
>
> ---
> Warren Myers
>
> On 18-09-06 12:08, Mauricio Tavares wrote:
>> On Thu, Sep 6, 2018 at 11:55 AM, Warren Myers via TriLUG
>> <trilug at trilug.org> wrote:
>>> Because SQL Server is better than Oracle, DB2, and Sybase - that's why 
> :)
>>>
>>        I've always thought MSSQL is an offspring of sybase...
>>
>>> Plus, with built-in tie-ins to Visual Studio, AD, etc, it's a simple 
> choice
>>> for many organizations.
>>>
>>> The only FLOSS DB that can really compete with SQL Server is PostgreSQL 
> (I
>>> know about MySQL and MariaDB - they are different beasts). And if you 
> don't
>>> already have the expertise on it, it's going to be a lot cheaper to 
> just
>>> leverage all your SQL Server DBAs and devs than to find ones who can 
> work
>>> with pgsql
>>>
>>        Isn't the opposite of this argument -- if you have postgresql
>> DBAs and devs already -- also valid?
>>
>>> ---
>>> Warren Myers
>>>
>>> On 18-09-05 13:58, Charles Fischer via TriLUG wrote:
>>>> I think Apple used one of the BSDs for their Mac OS, not Linux.  Small 
> nit
>>>> pick.
>>>>
>>>> As for moving to FOSS, I would pick expensive back office software to
>>>> replace first.  Why anybody starts a project with Microsoft's SQL is
>>>> beyond
>>>> my capability to understand.  There are at least three open source
>>>> databases that can replace Microsoft SQL.  I would also go after most 
> if
>>>> not all of the Microsoft Servers.  Expect a lot of push back from 
> those
>>>> who
>>>> only know Microsoft.  Expect help from those who run Linux at home.
>>>>
>>>> Good luck,
>>>> Charles Fischer
>>>
>>> --
>>> This message was sent to: raubvogel at gmail.com <raubvogel at gmail.com>
>>> To unsubscribe, send a blank message to trilug-leave at trilug.org from 
> that
>>> address.
>>> TriLUG mailing list : https://www.trilug.org/mailman/listinfo/trilug
>>> Unsubscribe or edit options on the web  :
>>> https://www.trilug.org/mailman/options/trilug/raubvogel%40gmail.com
>>> Welcome to TriLUG: https://trilug.org/welcome
>
> -- 
> This message was sent to: William <william at trilug.org>
> To unsubscribe, send a blank message to trilug-leave at trilug.org from that 
> address.
> TriLUG mailing list : https://www.trilug.org/mailman/listinfo/trilug
> Unsubscribe or edit options on the web	: 
> https://www.trilug.org/mailman/options/trilug/william%40trilug.org
> Welcome to TriLUG: https://trilug.org/welcome