drifter89 · HackerTrans

11 jaar geledendiscuss

This literally makes no sense to me. At 11, I used to run, ride my bike for miles by my self. Hell, if I go to my parents neighborhood now. There are kids playing outside all the time. By this logic, I can call the cops, and get the entire neighborhood arrested. Can't think of a normal adult that would support this.

drifter89

11 jaar geledendiscuss

DBA & PL-SQL/UNIX Developer here. Primary work with Oracle and SQL Server. Also support PG, and MySQL.

SQL Server hands down has the best GUI tools, none of the other DB's can even match this. Lots of information/documentation online. Makes life a lot easier. With Flashback being added to SQL16, it's going to be really hard to beat. Setting up, and maintaining HA options like Mirroring, Clustering, Replication is significantly easier that all the other DB's I've used.

Oracle is great, and also a pain in the ass. Works on any OS...but in my experience works best on Solaris. They really need to improve their tools. If you want to be effective you pretty much have to use the command line, and sql plus. There is nothing wrong with that, and in fact I prefer this method for most things. However, once you get used to SQL Server, it's crazy how much time you save, by having simple tools. Data Grid sucks ass, and is just a pain. They try to push this now, instead of the command line tools, pretty big mistake in my eyes. Oracle also has a lot of new features that are truly awesome. Like Audit Vault, and data masking.

PG is pretty awesome, but most enterprise level applications do not support it. Same issue with MySQL. The learning curve is also steeper for these. I don't believe MySQL, or PG can come close to SQL Server, or Oracle.

comments