Of course they don't really, as evidenced by the fact they're still around after all these years.
However if someone was unconvinced as to why SQL Server (or any other big-iron database like PostgreSQL, Maria, Oracle ) is better going forward, purely in terms of the data layer, what would you say in addition to the items below ?
* Scalable
* Secure in terms of authentication and authorisation
* Not malware vector at a file level, as such
* Can be backed up while in use
* Logging
* Speed especially with many connections
* Modern reporting and analytics tools geared up to talk to it
* Modern development stacks are designed to work with it
* Cloud-deployable
* Things that should happen server side can happen with sprocs
* Multi-user locking and access won't be messed up inadvertently by future OS versions or patches * Supported
Thanks
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
Technology improvements you say?
On Fri, Feb 3, 2017 at 8:30 AM, Alan Bourke alanpbourke@fastmail.fm wrote:
Of course they don't really, as evidenced by the fact they're still around after all these years.
However if someone was unconvinced as to why SQL Server (or any other big-iron database like PostgreSQL, Maria, Oracle ) is better going forward, purely in terms of the data layer, what would you say in addition to the items below ?
Scalable
Secure in terms of authentication and authorisation
Not malware vector at a file level, as such
Can be backed up while in use
Logging
Speed especially with many connections
Modern reporting and analytics tools geared up to talk to it
Modern development stacks are designed to work with it
Cloud-deployable
Things that should happen server side can happen with sprocs
Multi-user locking and access won't be messed up inadvertently by future OS versions or patches
Supported
Thanks
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
Free
Easily backed up in real time (Mirroring/Clustering)
Reversible transactions (Rollback)
Audit trails (Log files)
Operating System independent
Easily extracted and processed Business Intelligence
Disconnected datasets
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Alan Bourke Sent: 03 February 2017 14:31 To: profoxtech@leafe.com Subject: DBF why you suck so bad.
Of course they don't really, as evidenced by the fact they're still around after all these years.
However if someone was unconvinced as to why SQL Server (or any other big-iron database like PostgreSQL, Maria, Oracle ) is better going forward, purely in terms of the data layer, what would you say in addition to the items below ?
* Scalable
* Secure in terms of authentication and authorisation
* Not malware vector at a file level, as such
* Can be backed up while in use
* Logging
* Speed especially with many connections
* Modern reporting and analytics tools geared up to talk to it
* Modern development stacks are designed to work with it
* Cloud-deployable
* Things that should happen server side can happen with sprocs
* Multi-user locking and access won't be messed up inadvertently by future OS versions or patches * Supported
Thanks
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]
-
Alan Bourke -
Dave Crozier -
Stephen Russell