4 ms·
If SQLServer is going to be referred to as "Microsoft" shouldn't MySQL be lumped under the "Oracle" grouping?
by j-bone 15y ago
If SQLServer is going to be referred to as "Microsoft" shouldn't MySQL be lumped under the "Oracle" grouping?
- jpitz 15y agoMS really only has one relevant offering in this discussion, unless you want to add Exchange as a document-oriented store.
- Someone 15y agoIt would not surprise me if MS Access were used at more companies than MS SQL Server. I'll leave it to you whether you call it a database :-)
- sjwright 15y agoI think it would be fair to say that Jet (Microsoft Access) is a least as much a database as SQLite.
- jpitz 15y agoI wont argue, but Jet hasn't been the default backend to Access in a long time. It is SQL Server Desktop Edition now, IIRC.
- sixtypoundhound 15y agoHah! Don't discount it that quickly - MS Access can be surprisingly useful, particularly for RAD work at a large company where you need to push stuff out to a bunch of MS Office users. I've delivered a bunch of "light" Access/VBA applications to support business initiatives (cranked out in under a week or two) which probably account for over 80% of the value created by my hands on technical work (several of which provided the "chassis" for multi-million dollar performance improvement programs). Access plays well with everyone (including Oracle, the MS Office family, and Sharepoint), can be heavily extended if you know VBA and are willing to hack a bit, and can often be handed off to a non-technical person for support. The trick is to try to use the same coding/design standards that you would use in a real langauge - the internal parts of my Access/VBA work is influenced by Python and C++. And from a consulting perspective, it has the advantage of being aligned with what 90% of your Fortune 500 end-users are familar with (MS Office)... simpler handoffs. That being said...not my first choice for after hours work (do a lot of MySQL, looking to step up to Postgres). Incidently (for the other thread) - one really nice thing about oracle is their statistical analysis functions - very nice set of tools, co-located with your data, and can be accessed through SQL. Only free solution I've seen that is competitive in terms of functionality is Postgres...
- ern 15y agoLightswitch ( http://www.microsoft.com/visualstudio/en-us/lightswitch http://www.microsoft.com/visualstudio/en-us/lightswitch ) also seems to be aimed at the sort of thing you describe. RAD, but providing a solid MS architecture in the background. Have you looked at it yet?
- smiler 15y agoA nice distinction would be SQL Server and SQL Server Express. Express being free, it would be interesting to see how many people are using SQL Server Express as a free alternative to MySQL and how many are using SQL Server as the paid alternative
- r00fus 15y agoYes, sadly FoxPro died when it was acquired by Microsoft.
- rksprst 15y agoMicrosoft has key-value database on Azure as Azure Tables. They also have Azure SQL which is different than just SQL Server (though very similar).
- abyssknight 15y agoI have to agree, and planned to comment just to say the same. SQL Server is incredibly powerful, easy to use, and scales okay. If StackOverflow is any indication, people are seriously underestimating (and mis-representing) the Microsoft offerings. Just to name a few: * SQL Server * SQL Server Express * SQL Compact 4 * SQL Azure