This article by Adam Aspin reviews the Azure Cosmos DB SQL API from the perspective of the relational database developer. More specifically it will show you how to leverage your Structured Query Language skills to exploit the core possibilities of Cosmos DB as a NoSQL document database.
2019-03-25
219 reads
Global distribution of updatable data stores is one of the more challenging goals that software designers and architects have been struggling with over the years. Addressing this challenge has become increasingly pressing as the rapid growth of cloud technologies increased the need for deployments capable of spanning multiple geographical areas. In this article, we will provide an introduction to global distribution-related functionality in Cosmos DB.
2018-07-31
3,325 reads
Azure Cosmos DB is Microsoft’s NoSQL database platform running in the cloud. In this article, Suhas Pande explains many of the core concepts in Cosmos DB. Additionally, he goes over how to set up a local Cosmos DB emulator to create collections and documents. Using a local emulator is free and allows development with Cosmos DB without being connected to Azure.
2018-07-26
3,673 reads
When analyzing security-related challenges, it is important to note that they encompass several distinct but interrelated technologies. In addition, when dealing with data services, it is also necessary to distinguish between the data plane, facilitating access to the underlying content and the management plane, which allows for delegation of administrative tasks. In this article, Marcin Policht explores how these concepts apply to the Azure Cosmos DB offering.
2018-06-05
2,582 reads
Azure Cosmos DB offers features that facilitate data availability and resiliency. However, there is also a different, very important aspect of facilitating access to distributed data sources in the most optimal manner, which focuses on access control mechanisms. Read on to learn the specifics of this aspect, as it applies to Azure Cosmos DB.
2018-04-04
2,223 reads
One of the most important design decisions that must be made when planning deployment of Azure Cosmos DB involves logical partitioning of data that will populate target collections, graphs, or tables. Selecting the optimal partitioning model has both performance and pricing implications. In this article, we will explore the rationale behind these implications and review the partitioning options.
2018-03-08
2,357 reads
Azure Cosmos DB is the latest data service offering from Microsoft. Azure Cosmos DB is a super set of DocumentDB and provides a new set of capabilities. These capabilities make Azure Cosmos DB stand out from other members in the NoSQL database family.
2017-09-05
3,084 reads
2005-05-25
>>I've tried it the logical way by selecting to execute task and the typing 'exec sp_....' and this obviosuly does not work. It's pretty obvious that it does work, hence the large button at the bottom of the ExecSQL task UI labelled "Parameters".What are you trying to pass into the sproc as parameters ? Global DTS variables […]
2005-04-15
This is why I'm not a fan of using Maintenance Plans. I much prefer to code all the jobs myself so I get detailed output. When I'm in DBA mode (I'm currently doing SQL development) I use ISQL to run my DBCCs and pipe the output to a text file. It's run as a batch […]
2005-04-15
By Will Assaf
Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Very excited to take part in my third #PGSQLPhriday blogging event, even more so...
Hi All, One of our windows login is not working which is been configured...
Hello all I am sorry to bother but I really can't find the solution...
Ask SSC