Recently I have been working with a colleague who is doing a bit of a side projects outside of work. He's trying to expand his skillset using a pet project at home. I encouraged him to look at NoSQL, in particular MongoDB. While I'm a traditional 3rd Normal Form relational developer, I still think there is […]
2019-09-02
4,876 reads
The JSON documents that are part of Cosmos DB document collections can be complex with arrays and nesting. In this article, Adam Aspin shows you how to query them with SQL.
2019-06-17
Building on the introduction to the SQL used by Cosmos DB in the first article in the series, here you will learn how to handle some of the more classic challenges that you may face when querying JSON documents. Adam Aspin shows you some of the workarounds that are useful in practice when finding and shaping output data ready for further analysis.
2019-05-22
Organizations have many choices when it comes to database platforms. Choosing the right one for an application should be based on the application’s characteristics and the platform’s features. In this article, Pushpa Sekhara explains why the Apache Cassandra database might be a good choice and how to get the most from it.
2019-03-04
2,398 reads
Choosing the right data platform is not an easy task. Warner Chaves compares the capabilities of the big three Database as a Service (DBaaS) offerings, Microsoft’s Cosmos DB, Google’s Cloud Spanner, and Amazon’s DynamoDB, to help you make the right choice for your application.
2017-12-27
3,064 reads
There’s a new kid on the block in the NoSQL world – Azure DocumentDB. Released in preview back in August 2014 and going Generally Available this month, Azure DocumentDB is Microsoft’s initial foray into the increasingly competitive space of non-relational database management systems. Of course there is no better competitor in this space to measure up against than MongoDB. How close does DocumentDB stack up to MongoDB? Are they even close?
2015-05-04
9,575 reads
SQL Server may not be the best solution for every problem, but we have the means to extend its capabilities by linking it to external resources; in this case, using SQLCLR to query a graph database.
2014-01-08
7,623 reads
SQL is derided by modern developers as 'Scarcely Qualifies as a Language'. But just how efficient are the new wave of NoSQL languages touted by bleeding-edge skunk works? This tip is a defense of SQL and of the relational model, and argues for the efficiency and suitability of relational technology. Check out this tip to learn more.
2013-09-10
4,656 reads
The buzz around NoSQL solutions has reached stratospheric heights. This buzz has led many Microsoft SQL Server development shops to start looking at how and where a NoSQL solution can fit into their business.
2013-02-22
5,201 reads
The NoSQL concept has been attracting a lot of attention in recent years, primarily due to big-name production implementations.
2010-05-21
8,007 reads
By Ed Elliott
It has been a little while but I have updated SQLCover to include a...
By Rayis Imayev
(2019-October-16) Developing conditional logic of your Azure Data Factory control flow has been simplified with...
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Comments posted to this topic are about the item Using Graph Theory To Group...
Comments posted to this topic are about the item More Network Restrictions
Comments posted to this topic are about the item Checking on IFI
Ask SSC