Category Archives : Database

24

Sep

Azure Cosmos DB Developer Experience updates
Azure Cosmos DB Developer Experience updates

The Azure Cosmos DB team is excited to announce new features and improvements for developers:

1-month free trial of Azure Cosmos DB SDK updates to support multi-region writes Cosmos Explorer Portal UX updates and recommendations Emulator support for all APIs & Azure DevOps build task 1-month free trial of Azure Cosmos DB

You can now try Azure Cosmos DB for free for an entire month! This trial allows you to evaluate Azure Cosmos DB’s capabilities for free for 30 days, including creating a database with up to 25 containers (collections) and up to 10,000 Request Units (RU)/second of throughput, no Azure subscription or credit required. Get started with Try Azure Cosmos DB. Azure Cosmos DB is also included in the Azure free account, which includes 400 RU/s for 12 months.

.NET, Java, JavaScript, and Python SDK updates

The JavaScript 2.0 SDK is now generally available. We’ve added support for multi-region writes, a new “fluent” style object model – making it easier to reference Cosmos DB resources without an explicit URL– and support for promises and other modern JavaScript features. It is also written in TypeScript and supports the latest TypeScript 3.0.

With these changes, you can create a new

Share

24

Sep

Azure Cosmos DB JavaScript SDK 2.0 now generally available

Version 2.0 of the Azure Cosmos DB JavaScript SDK is now generally available. Thank you to all who tried the preview and gave feedback!

In this release, we’ve added support for multi-region writes, a new “fluent” style object model – making it easier to reference Azure Cosmos DB resources without an explicit URL– and support for promises and other modern JavaScript features. It is also written in TypeScript and supports the latest TypeScript 3.0.

What is Azure Cosmos DB?

Azure Cosmos DB is a globally distributed, multi-model database service. It offers turnkey global distribution, guarantees single-digit millisecond latencies at the 99th percentile, elastic scaling of throughput and storage, and comprehensive SLA’s.

New object model

Based on your feedback, we’ve redesigned the object model to make it easier to interact with and perform operations against Cosmos DB.

We’ve created a new top level CosmosClient class to replace DocumentDBClient, and split up its methods into modular Database, Container, and Items classes. This new API surface enables a “builder” or “fluent” pattern. For example, to create an item, we first reference its database and container, and call items.create(). This removes the need to build an explicit URL to reference a resource.

As

Share

23

Sep

Azure Database Migration Service and tool updates – Ignite 2018
Azure Database Migration Service and tool updates – Ignite 2018

In mid-July, I blogged about the exciting updates and additions we had made to the Azure Database Migration Service (DMS) and our data migration tools. Since that time, we have noticed increased usage of our database migration offerings. In August 2018, we helped migrate over 15,000 databases and since January 2018, we have assisted with the migration of more than 107,000 databases to Azure. We have also been hard at work in the interim, continuing to deliver functionality to address customer feedback and enhance the value of our database migration service and tools. Below is information about our latest updates.

Azure Database Migration Service (DMS)

Azure DMS is a fully managed service designed to enable seamless migrations from multiple database sources to Azure Data platforms with minimal downtime. In recent months, we have added the following improvements:

Online (minimal downtime) migrations. Customers can now use Azure DMS preview support for online migrations of: SQL Server databases running on-premises or on virtual machines to Azure SQL Database and Azure SQL Database Managed Instance. MySQL databases running on-premises or on virtual machines to Azure Database for MySQL. PostgreSQL databases running on-premises or on virtual machines to Azure Database for PostgreSQL. SKU

Share

23

Sep

Azure Cosmos DB: Pushing the frontier of globally distributed databases

Since its conception in 2010, as a cloud-born database, we have carefully designed and engineered Azure Cosmos DB to exploit the three fundamental properties of the cloud:

Global distribution by virtue of transparent multi-master replication. Elastic scalability of throughput and storage worldwide by virtue of horizontal partitioning. Fine grained multi-tenancy by virtue of highly resource-governed system stack all the way from the database engine to the replication protocol.

Cosmos DB composes these three properties in a novel way to offer elastic scalability of both writes and reads all around the world with guaranteed single digit millisecond latency at the 99th percentile and 99.999% high availability. The service transparently replicates your data and provides a single system image of your globally distributed Cosmos database with a choice of five well-defined consistency models (precisely specified using TLA+), while your users write and read to local replicas anywhere in the world. Since its launch last year, the growth of the service has validated our design choices and the unique engineering tradeoffs we have made.

Blazing fast, globally scalable writes

As one of the foundational services of Azure, Cosmos DB runs in every Azure region by default. At the time of writing, Cosmos DB

Share

23

Sep

Azure Cosmos DB – database for Intelligent Cloud – Intelligent Edge era

Azure Cosmos DB

Azure Cosmos DB is Microsoft’s globally distributed, multi-model database service for mission-critical workloads. Azure Cosmos DB provides turnkey global distribution with unlimited endpoint scalability, elastic scaling of throughput (at multiple granularities, e.g., database, key-space, tables and collections) and storage worldwide, single-digit millisecond latencies at the 99th percentile, five well-defined consistency models, and guaranteed high availability, all backed by the industry-leading comprehensive SLAs. Azure Cosmos DB automatically indexes all data without requiring developers to deal with schema or index management. It is a multi-model service, which natively supports document, key-value, graph, and column-family data models. As a natively born in the cloud service, Cosmos DB is carefully engineered with multitenancy and global distribution from the ground up. As a foundational service in Azure, Cosmos DB is ubiquitous, running in all public regions, DoD and sovereign clouds, with industry-leading compliance certification list, enterprise grade security – all without any extra cost.

Cosmos DB’s unique approach of providing wire protocol compatible APIs for the popular open source-databases ensures that you can continue to use Azure Cosmos DB in a cloud-agnostic manner while still leveraging a robust database platform natively designed for the cloud. You get the flexibility to run

Share

23

Sep

Announcing general availability of Azure Cosmos DB reserved capacity

We are excited to announce the general availability of Azure Cosmos DB reserved capacity – expanding our commitment to making Cosmos DB the most cost-effective database for your modern scale-out workloads.

As a cloud-born database, we have carefully engineered Azure Cosmos DB with multi-tenancy and global distribution (with transparent multi-master replication) from the ground up. Azure Cosmos DB provides, turnkey global distribution, elastic scaling of read and write throughput and storage worldwide, single-digit millisecond read and write latencies at the 99th percentile, five well-defined consistency models, and guaranteed high availability, all backed by industry-leading comprehensive SLAs. Azure Cosmos DB is completely schema-agnostic and automatically indexes all data. This means that you don’t have to deal with cumbersome schema changes, version management and manage indexes across multiple regions. Finally, thanks to the wire protocol compatible APIs for MongoDB/Apache Cassandra/Apache Gremlin on top of a write-optimized, multi-model database engine, migrating data from IaaS hosted/on-premises NoSQL databases to Azure Cosmos DB is more friction-free than before.

Azure Cosmos DB reserved capacity helps you save money by pre-paying for Azure Cosmos DB resources for a period of one year or three years. Azure Cosmos DB reserved capacity allows you to get a discount

Share

10

Sep

Announcing Azure Pipelines with unlimited CI/CD minutes for open source

With the introduction of Azure DevOps today, we’re offering developers a new CI/CD service called Azure Pipelines that enables you to continuously build, test, and deploy to any platform or cloud. It has cloud-hosted agents for Linux, macOS, and Windows, powerful workflows with native container support, and flexible deployments to Kubernetes, VMs, and serverless environments.

Microsoft is committed to fueling open source software development. Our next step in this journey is to provide the best CI/CD experience for open source projects. Starting today, Azure Pipelines provides unlimited CI/CD minutes and 10 parallel jobs to every open source project for free. All open source projects run on the same infrastructure that our paying customers use. That means you’ll have the same fast performance and high quality of service. Many of the top open source projects are already using Azure Pipelines for CI/CD, such as Atom, Cpython, Pipenv, Tox, Visual Studio Code, and TypeScript – and the list is growing every day.

In the following, you can see Atom running parallel jobs on Linux, macOS, and Windows for its CI.

Azure Pipelines app on GitHub Marketplace

Azure Pipelines has an app in the GitHub Marketplace so it’s easy to get started.

Share

04

Sep

Transparent data encryption or always encrypted?
Transparent data encryption or always encrypted?

How to choose the right encryption technology for Azure SQL Database or SQL Server

Transparent Data Encryption (TDE) and Always Encrypted are two different encryption technologies offered by SQL Server and Azure SQL Database. Generally, encryption protects data from unauthorized access in different scenarios. They are complementary features, and this blog post will show a side-by-side comparison to help decide which technology to choose and how to combine them to provide a layered security approach.

Transparent Data Encryption

TDE is intended to add a layer of security to protect data at rest from offline access to raw files or backups, common scenarios include datacenter theft or unsecured disposal of hardware or media such as disk drives and backup tapes. For a deeper look into how TDE protects against the risk of malicious parties trying to recover stolen databases: data, log files, snapshots, copies or backups and to review TDE best practices see Feature Spotlight: Transparent Data Encryption (TDE). 

Enabling TDE on databases provides the ability to comply with many laws, regulations, and security guidelines established across various industries that require data to be encrypted at rest. Unless data stored in a SQL database has no protection requirements at all,

Share

16

Aug

Announcing VNet service endpoints general availability for MySQL and PostgreSQL

This blog post was co-authored by Anitha Adusumilli, Principal Program Manager, Azure Networking.

We recently made Azure database services for MySQL and PostgreSQL generally available. These services offer the community versions of MySQL and PostgreSQL with built-in high availability, a 99.99 percent availability SLA, elastic scaling for performance, and industry-leading security and compliance on Azure. Since general availability, we have continued to bring new features and capabilities like increased storage and availability across more regions worldwide.

We are excited to announce the general availability of Virtual Network (VNet) service endpoints for Azure Database for MySQL and PostgreSQL in all regions where the service is available for General Purpose and Memory Optimized servers. Visit region expansion for MySQL and PostgreSQL for service availability. VNet service endpoints enable you to isolate connectivity to your logical server from only a given subnet or set of subnets within your virtual network. The traffic to Azure Database for MySQL and/or PostgreSQL from your VNet always stays within the Azure backbone network. Preference for this direct route is over any specific ones that route Internet traffic through virtual appliances or on-premises.

There is no additional billing for virtual network access through service endpoints. The current pricing model for Azure Database for MySQL and PostgreSQL applies as is.

Using

Share

08

Aug

New Azure #CosmosDB JavaScript SDK 2.0 now in public preview

The Azure Cosmos DB team is excited to announce version 2.0 RC of the JavaScript SDK for SQL API, now in public preview!

We are excited to get feedback through this RC before general availability, so please try it out and let us know what you think. You can get the latest version through npm with:

What is Azure Cosmos DB?

Azure Cosmos DB is a globally distributed, multi-model database service. It offers turnkey global distribution, guarantees single-digit millisecond latencies a the 99th percentile, and elastic scaling of throughput and storage.

For the SQL API, we support a JavaScript SDK to enable development against Azure Cosmos DB from JavaScript and Node.js projects. Version 2.0 of the SDK is written completely in TypeScript, and we’ve redesigned the object model and added support for promises. Let’s dive into these updates.

New object model

Based on user feedback, we’ve redesigned the object model to make it easier to interact with and perform operations against Cosmos DB. 

If you’re familiar with the previous version of the JavaScript SDK, you’ve likely noticed that the entire API surface hangs off DocumentDBClient. While the previous design makes it easy to find the entry point for methods,

Share