Viewing 15 posts - 916 through 930 (of 3,658 total)
For destructive deployments we had an explicit DBA schema so the relevant data could backed up and be rolled back. The deployment/rollback usually involved some form of sp_rename for the...
August 30, 2017 at 3:26 am
Certainly HIVE gives a sort of SQL called HQL which is based on the MySQL dialect.
Cassandra has CQL, Aerospike has AQL and Couchbase has NiQL.
Apache Spark goes for...
August 29, 2017 at 2:31 pm
August 29, 2017 at 11:29 am
The thing with NOSQL is that it is not a single thing, it's a massive range of things. Each one is intended to solve a particular problem. The trick is...
August 29, 2017 at 10:10 am
When I was experimenting with Neo4J I found that consistent performance was a strength. A 4 hop query seems to take the same amount of time regardless of data volumes
August 28, 2017 at 2:08 pm
There are similarities between Gremlin and Cypher. I'm not confident to say one way or the other but have noticed the pictorial style of the MATCH statement looks just like...
August 28, 2017 at 10:27 am
I saw recently a paper comparing the performance of Postgres, MySql, Oracle and SQL Server. As loads got more complex so the difference in performance between the proprietary and the...
August 28, 2017 at 8:49 am
I spent some time working through the Vagrant tutorials. There are a number of pre-canned virtual boxes with all sorts of software as part of the box. This allows you...
August 22, 2017 at 3:02 pm
Excellent editorial Steve. I've spent 3 years playing with all sorts of data technologies and have learned some hard lessons.
1. There are some fundamental disciplines that must not...
August 22, 2017 at 12:59 am
August 21, 2017 at 9:00 am
August 20, 2017 at 11:43 pm
This is a timely rerun of this editorial, particularly with the events that have taken place in Charlottesville recently. We have to understand the difference between
August 17, 2017 at 4:03 am
Since the original editorial we've had Solomun Rutzky's excellent Stairway to SQL CLR series which pretty much drove a stake through the heart of a lot of the...
August 11, 2017 at 1:42 am
Once you eliminate the impossible, whatever remains, no matter how improbable, must be the truth.
Ideally I'd like a script I can run to do as many smoke tests...
August 10, 2017 at 1:37 am
If it needs doing we raise a user story so that it is visible and can be prioritised. These stories can be relatively minor TODO list type items or something...
August 7, 2017 at 2:23 am
Viewing 15 posts - 916 through 930 (of 3,658 total)