Category Archives : Database

03

Jul

New Azure #CosmosDB Explorer now in public preview
New Azure #CosmosDB Explorer now in public preview

Today we’re excited to announce Azure Cosmos DB Explorer, a full screen standalone web-based version of the Data Explorer many of you already use in Azure Portal for Cosmos DB.

With Cosmos DB Explorer you can:

Take advantage of the full screen real estate for your queries and results. Access your database account and collections with a connection string, without needing access to the Azure subscription or portal. Share query results with authorized peers who do not have Azure portal access. Work with Cosmos DB data without having to download any desktop tools locally.

From Azure Portal, you can open your account in Cosmos DB Explorer by clicking on the Open Full Screen button in Data Explorer blade.

In the drop-down dialog you can choose the type of access you’d like to open the account with and click Open, “read & write” is default. You can also copy the Cosmos DB Explorer link and share with your colleagues, for example if you want to share read-only results of a query with teammates who don’t have access to Azure Portal.

When you open Cosmos DB Explorer this way, the access will expire in few hours for security reasons. After

03

Jul

New Azure #CosmosDB Explorer now in public preview
New Azure #CosmosDB Explorer now in public preview

Today we’re excited to announce Azure Cosmos DB Explorer, a full screen standalone web-based version of the Data Explorer many of you already use in Azure Portal for Cosmos DB.

With Cosmos DB Explorer you can:

Take advantage of the full screen real estate for your queries and results. Access your database account and collections with a connection string, without needing access to the Azure subscription or portal. Share query results with authorized peers who do not have Azure portal access. Work with Cosmos DB data without having to download any desktop tools locally.

From Azure Portal, you can open your account in Cosmos DB Explorer by clicking on the Open Full Screen button in Data Explorer blade.

In the drop-down dialog you can choose the type of access you’d like to open the account with and click Open, “read & write” is default. You can also copy the Cosmos DB Explorer link and share with your colleagues, for example if you want to share read-only results of a query with teammates who don’t have access to Azure Portal.

When you open Cosmos DB Explorer this way, the access will expire in few hours for security reasons. After

02

Jul

Agile SAP development with SAP Cloud Platform on Azure

This blog post was co-authored by Mario Szpuszta, Principal Software Engineer, Azure CAT

Recently we announced that SAP Cloud Platform is transitioning from Beta to general availability on Azure. SAP Cloud Platform (SAP CP) is SAP’s multi-cloud platform-as-a-service offering and is now available for production use in Azure West Europe.

With SAP CP on Azure, we extend the choices available on Azure to meet your SAP development needs.  SAP CP offers a fully managed platform-as-a-service, operated by SAP, and is the first multi-tenant and fully managed Cloud Foundry PaaS on Azure. With SAP CP running on Azure, customers can

Leverage a broad range of certified SAP HANA offerings on Azure. Integrate with Azure-Native Services such as EventHubs, AzureSQL Database, Azure CosmosDB, Azure ServiceBus etc., using Meta Azure Service Broker. Integrate with Azure Active Directory to enable Single-Sign-On for SAP Cloud Platform SAP Cloud Platform on Azure – Getting started

To get started with SAP CP on Azure, login to your SAP CP account. Pick Cloud Foundry and select Europe (Netherlands) Azure region. This will create an Organization and Space within the SAP CP Cloud Foundry environment.

Deploying applications and services

Developers can use either the SAP CP cockpit

02

Jul

Securing the connection between Power BI and Azure SQL Database

How can you connect to Azure SQL Database from the Power BI service in a secure fashion? The easiest way to limit access to the database is to select the “allow access to Azure Services” option (Figure1). This can be found in the database server options in the Azure portal. This allows Power BI to access your database. However, it also makes the database visible to any component deployed within Azure, such as a virtual machine. For many organizations this is not sufficient for their security and compliance requirements.


Figure 1: Setting the database access in the Azure Portal.

  The following is a list of suggestions that one may want to consider achieving the organizations security goals:

To start, use VNet service endpoints to further secure access. This feature was introduced at the start of 2018. This is easy to configure. In the Azure portal either create a new virtual network or edit an existing VNet and enable service endpoints for SQL in the VNet (Figure2).

Figure 2: Creating a service endpoint in the virtual network.

Once completed, the next task is to set up a virtual network rule on the database server. This allows us to restrict

27

Jun

Azure Elastic Database jobs is now in public preview

We are excited to announce the availability of a new, significantly upgraded public preview release of Azure Elastic Database jobs. Elastic Database jobs is now a fully Azure-hosted service. Unlike the earlier, customer-hosted and managed version of Elastic Database jobs, this version is an integral part of Azure with no additional services or components to install and configure. This release also adds significant capabilities making it easy for customers to automate and execute T-SQL jobs using PowerShell, REST, or T-SQL APIs against a group of databases. These jobs can be used to handle a wide variety of tasks such as index rebuilding, schema updates, collection of query results for analytics, and performance monitoring.

Imagine you are a SaaS developer in the cloud offering online ordering services for a collection of large stores. To support this and allow unlimited scale, you’ve provisioned separate Azure SQL databases to handle each store’s business, and this set of databases share a common schema. While your application directs customer transactions to the appropriate store’s databases, you want the capability to easily manage all databases jointly to ensure the performance and customer experience remain optimal. Additionally, you periodically have new schema to deploy to each database

27

Jun

Azure Elastic Database jobs is now in public preview

We are excited to announce the availability of a new, significantly upgraded public preview release of Azure Elastic Database jobs. Elastic Database jobs is now a fully Azure-hosted service. Unlike the earlier, customer-hosted and managed version of Elastic Database jobs, this version is an integral part of Azure with no additional services or components to install and configure. This release also adds significant capabilities making it easy for customers to automate and execute T-SQL jobs using PowerShell, REST, or T-SQL APIs against a group of databases. These jobs can be used to handle a wide variety of tasks such as index rebuilding, schema updates, collection of query results for analytics, and performance monitoring.

Imagine you are a SaaS developer in the cloud offering online ordering services for a collection of large stores. To support this and allow unlimited scale, you’ve provisioned separate Azure SQL databases to handle each store’s business, and this set of databases share a common schema. While your application directs customer transactions to the appropriate store’s databases, you want the capability to easily manage all databases jointly to ensure the performance and customer experience remain optimal. Additionally, you periodically have new schema to deploy to each database

27

Jun

Azure Data Factory new capabilities are now generally available

Microsoft is excited to announce the General Availability of new Azure Data Factory (ADF V2) features that will make data integration in the cloud easier than ever before. With a new browser-based user interface, you can accelerate your time to production by building and scheduling your data pipelines using drag and drop. Manage and monitor the health of your data integration projects at scale, wherever your data lives, in cloud or on-premises, with enterprise-grade security. ADF comes with support for over 70 data source connectors and enables you to easily dispatch data transformation jobs at scale to transform raw data into processed data that is ready for consumption by business analysts using their favorite BI tools or custom applications.

For existing SQL Server Integration Services (SSIS) users, ADF now allows you to easily lift and shift your SSIS packages into the cloud and run SSIS as a service with minimal changes required to your existing packages. ADF will now manage your SSIS resources for you so you can increase productivity and lower total cost of ownership. Meet your security and compliance needs while taking advantage of extensive capabilities and paying only for what you use.

All of these new Azure

27

Jun

Azure Data Factory new capabilities are now generally available

Microsoft is excited to announce the General Availability of new Azure Data Factory (ADF V2) features that will make data integration in the cloud easier than ever before. With a new browser-based user interface, you can accelerate your time to production by building and scheduling your data pipelines using drag and drop. Manage and monitor the health of your data integration projects at scale, wherever your data lives, in cloud or on-premises, with enterprise-grade security. ADF comes with support for over 70 data source connectors and enables you to easily dispatch data transformation jobs at scale to transform raw data into processed data that is ready for consumption by business analysts using their favorite BI tools or custom applications.

For existing SQL Server Integration Services (SSIS) users, ADF now allows you to easily lift and shift your SSIS packages into the cloud and run SSIS as a service with minimal changes required to your existing packages. ADF will now manage your SSIS resources for you so you can increase productivity and lower total cost of ownership. Meet your security and compliance needs while taking advantage of extensive capabilities and paying only for what you use.

All of these new Azure

21

Jun

Resumable Online Index Create is in public preview for Azure SQL DB

We are delighted to announce that Resumable Online Index Create (ROIC) is now available for public preview in Azure SQL DB. The feature allows the ability to pause an index create operation and resume it later from where the index create operation was paused or failed, rather than having to restart the operation from the beginning. Additionally, this feature creates indexes using only a small amount of log space. You can use the new feature in the following scenarios:

Resume an index create operation after an index create failure, such as after a database failover or after running out of disk space. There is no need to restart the operation from the beginning. This can save a significant amount of time when creating indexes for large tables. Pause an ongoing index create operation and resume it later. For example, you may need to temporarily free up system resources in order to execute a high priority task or you may have a single maintenance window that is too short to complete the operation for a large index. Instead of aborting the index create process, you can pause the index create operation and resume it later without losing prior progress. Create large

21

Jun

Resumable Online Index Create is in public preview for Azure SQL DB

We are delighted to announce that Resumable Online Index Create (ROIC) is now available for public preview in Azure SQL DB. The feature allows the ability to pause an index create operation and resume it later from where the index create operation was paused or failed, rather than having to restart the operation from the beginning. Additionally, this feature creates indexes using only a small amount of log space. You can use the new feature in the following scenarios:

Resume an index create operation after an index create failure, such as after a database failover or after running out of disk space. There is no need to restart the operation from the beginning. This can save a significant amount of time when creating indexes for large tables. Pause an ongoing index create operation and resume it later. For example, you may need to temporarily free up system resources in order to execute a high priority task or you may have a single maintenance window that is too short to complete the operation for a large index. Instead of aborting the index create process, you can pause the index create operation and resume it later without losing prior progress. Create large