Category Archives : Database

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.

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,

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

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,

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 at 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,

08

Aug

Announcing general availability of Azure SQL Database reserved capacity

We are excited to announce the general availability of Azure SQL Database reserved capacity, now available for single and elastic pool databases—expanding our commitment to making Azure the most cost-effective cloud for your workloads. This new pricing option enables you to save up to 33 percent1 compared to license-included pricing by pre-paying for your SQL database vCores for a one or three-year term.

Azure is the most cost-effective cloud for SQL Server workloads

Today, customers with active Software Assurance can save up to 55 percent using Azure Hybrid Benefit for SQL Server with the new vCore-based purchasing model in SQL Database. With support for reserved capacity on single databases and elastic pools, you can unlock even more savings when you combine your Azure Hybrid Benefit with reserved capacity pricing to achieve savings of up to 80 percent2. 

 

 

If you’re facing end of support for SQL Server 2008/2008 R2 on July 9, 2019, you can migrate your workloads to Azure SQL Database, a fully-managed service, and eliminate end of support transition costs. Azure Hybrid Benefit lets you use your existing licenses with active Software Assurance to save more on Azure, and now reserved capacity makes the move to

01

Aug

Microsoft Azure Data welcomes Data Platform Summit attendees

I am extremely honored to be delivering the keynote next week at the Data Platform Summit (DPS) in Bangalore. DPS is one of the events that I am looking forward to participating in as it will provide me with a pulse on data and analytics in the Asia Pacific region. More importantly, the event gives me a chance to connect with you — our customers, partners, and overall community.

As a preface, I want to share with you some of the exciting work happening on the Azure Data team at Microsoft and invite you to take a closer look. It is no secret that today’s mobile-first, cloud-first world is evolving to the intelligent cloud and intelligent edge, the new frontier for computing and data management. And IT decision makers and developers are at the forefront, driving this evolution.

We see three key trends that are defining and shaping the evolution of data management. 

First, data continues to grow exponentially and it’s not stopping any time soon. The explosion of data creates an urgency to deliver insights. Second, the rate of cloud adoption is increasing. Investments in public cloud technologies drive the need to collect data and innovate further at a

23

Jul

Accelerated and Flexible Restore Points with SQL Data Warehouse

We are thrilled to announce that SQL Data Warehouse (SQL DW) has released accelerated and flexible restore points for fast data recovery. SQL DW is a fully managed and secure analytics platform for the enterprise, optimized for running complex queries fast across petabytes of data.

The ability to quickly restore a data warehouse offers customers data protection from accidental corruption, deletion, and disaster recovery. We have seen scenarios where compliance requirements and having multiple test and development environments of a data warehouse enforce stricter capabilities in this area as well. To continue delivering first-class data protection and recovery, we have released the following critical improvements which are seamlessly integrated within the Azure Portal.

Finer granularity for cross region and server restores

You can now restore across regions and servers using any restore point instead of selecting geo redundant backups which are taken every 24 hours. Cross region and server restore is supported for both user-defined or automatic restore points enabling finer granularity for additional data protection. With more restore points available, you can be assured that your data warehouse will be logically consistent when restoring across regions.

Fast restore with Enhanced Restore Points

You can now restore your

23

Jul

Accelerated and Flexible Restore Points with SQL Data Warehouse

We are thrilled to announce that SQL Data Warehouse (SQL DW) has released accelerated and flexible restore points for fast data recovery. SQL DW is a fully managed and secure analytics platform for the enterprise, optimized for running complex queries fast across petabytes of data.

The ability to quickly restore a data warehouse offers customers data protection from accidental corruption, deletion, and disaster recovery. We have seen scenarios where compliance requirements and having multiple test and development environments of a data warehouse enforce stricter capabilities in this area as well. To continue delivering first-class data protection and recovery, we have released the following critical improvements which are seamlessly integrated within the Azure Portal.

Finer granularity for cross region and server restores

You can now restore across regions and servers using any restore point instead of selecting geo redundant backups which are taken every 24 hours. Cross region and server restore is supported for both user-defined or automatic restore points enabling finer granularity for additional data protection. With more restore points available, you can be assured that your data warehouse will be logically consistent when restoring across regions.

Fast restore with Enhanced Restore Points

You can now restore your

16

Jul

Spring Data Gremlin for Azure Cosmos DB Graph API

We are pleased to announce that Spring Data Gremlin is now available on Maven Central and source code on GitHub. This project provides Spring Data support for Graph databases that use Gremlin as a traversal language. For Azure users, it provides a delightful experience to interact with Azure Cosmos DB using Graph API. Java developers can now use Spring annotations to map with database entities, such as Vertex and Edge. It also allows developers to create their own database queries based on Spring Data Repository.

Key features

Spring Data Gremlin supports annotation-oriented programming model to simplify the mapping to the database entity. It also provides supports to create custom queries.

Mapping with database entities, including annotations.

@Id to map a filed in the domain class with id field of an entity.
@Vertex and @VertexSet map to Vertex. @Edge, @EdgeSet, @EdgeFrom and @EdgeTo to map with Edge

Advanced operations with Vertex, Edge and Graph.

findVertexById and findEdgeById to find data by specific field. vertexCount and edgeCount for counting Vertex and Edge numbers.

Spring Data CRUD functionality.

Custom database queries based on Spring Data Repository. Getting started

You can follow this tutorial to create a Graph database instance in