Category Archives : Database



Azure Data Lake tools integrates with VSCode Data Lake Explorer and Azure Account

If you are a data scientist and want to explore the data and understand what is being saved and what the hierarchy of the folder is, please try Data Lake Explorer in VSCode ADL Tools. If you are a developer and look for easier navigation inside the ADLS, please use Data Lake Explorer in VSCode ADL Tools. The VSCode Data Lake Explorer enhances your Azure login experiences, empowers you to manage your ADLA metadata in a tree like hierarchical way and enables easier file exploration for ADLS resources under your Azure subscriptions. You can also preview, delete, download, and upload files through contextual menu. With the integration of VSCode explorer, you can choose your preferred way to manage your U-SQL databases and your ADLS storage accounts in addition to the existing ADLA and ADLS commands.

If you have difficulties to login to Azure and look for simpler sign in processes, the Azure Data Lake Tools integration with VSCode Azure account enables auto sign in and greatly enhance the integration with Azure experiences. If you are an Azure multi-tenant user, the integration with Azure account unblocks you and empowers you to navigate your Azure subscription resources across tenants.

If your source



Azure #CosmosDB: Recap of 2017
Azure #CosmosDB: Recap of 2017

It was a pretty amazing year for Azure Cosmos DB, highlighted by the launch of the service, the preview and general availability of Graph, Table APIs, MongoDB API, native Spark connector and many other awesome capabilities. There were breakthroughs in making our SLAs truly industry-leading, adding native integration with Azure Functions and launching Try Cosmos DB for free to empower anyone to experience and play with our service without having an Azure account or having to specify a credit card. Below is a look back at 2017 and some of the memorable milestones.

The Launch of Azure Cosmos DB

In May, we were super excited to announce the general availability of Azure Cosmos DB – Microsoft’s globally distributed, massively scalable, multi-model database service. It is the first globally-distributed data service that lets you elastically scale throughput and store across any number of geographical regions while guaranteeing low latency, high availability and consistency. While also backed by the most comprehensive SLAs in the industry. It is the first cloud database to natively support a multitude of data models and popular query APIs. It is built on a novel database engine capable of ingesting sustained volumes of data and provides blazing



Join on-demand recasts of Azure Cosmos DB and Azure SQL Database webinars!

In case you missed them, we’ve posted the Azure Cosmos Database and Azure SQL Database webinars for on-demand viewing. The first webinar takes a closer look at Azure Cosmos DB, a globally distributed, multi-model database service that enables scaled throughput and storage across many geographical regions.  The second webinar shares how you can make the most of Azure SQL Database’s machine learning features to deliver intelligent apps to your customers.

Azure Cosmos DB – Easily build globally distributed, highly scalable applications

Building successful apps depends on having well-indexed and formatted data—regardless of how or where data is stored. With Azure Cosmos DB, you can build globally distributed applications without the hassle of complex, multi-datacenter configurations.

Tune in to this webinar and learn how you can leverage Azure Cosmos DB to:

Create lightning-fast globally distributed apps Model your app’s data using familiar tools and APIs Easily distribute data across multiple regions Fine-tune performance based on your application’s needs. Register to watch this webinar on demand. Build intelligent apps faster with Azure SQL Database

Applications benefit when machine learning intelligence is applied to its underlying databases to optimize performance. Intelligent apps can spot trends, react to unusual events, and make useful predictions



Azure #CosmosDB: Entry point for unlimited containers is now 60% cheaper and other improvements

Azure Cosmos DB is Microsoft’s globally distributed, horizontally partitioned, multi-model database service. The service is designed to allow customers to elastically and independently scale throughput and storage across any number of geographical regions. Azure Cosmos DB offers guaranteed low latency at the 99th percentile, 99.999% high availability, predictable throughput, and multiple well-defined consistency models. Azure Cosmos DB is the first and only globally distributed database service in the industry today to offer comprehensive Service Level Agreements (SLAs) encompassing all four dimensions of global distributions which our customers care the most: throughput, latency at the 99th percentile, availability, and consistency. As a cloud service, we have carefully designed and engineered Azure Cosmos DB with multi-tenancy, horizontal scalability and global distribution in mind.

We have just rolled out a few long-awaited changes and we wanted to share them with you:

Entry point for unlimited collections/containers is now 60% cheaper. In February, we’ve lowered entry point for unlimited containers making them 75% cheaper. We continue making improvements in our service and today we are pleased to announce that unlimited containers have now an entry point that is 60% cheaper than before. Instead of provisioning 2,500 RU/sec as a minimum, you can now



How cloud speed helps SQL Server DBAs
How cloud speed helps SQL Server DBAs

A few years ago, the Microsoft SQL Server product team introduced a new cloud Platform-as-a-Service (PaaS), Azure SQL Database, which shares the SQL Server code base. Running a cloud-first service required significant changes to the legacy SQL Server engineering model which took years of investment in order to fully enable. With these engineering model changes came big benefits which positively impacted both Azure SQL Database and SQL Server.

Even if you are a SQL Server database administrator who isn’t using Azure SQL Database today, you’ll still be seeing benefits from Microsoft’s investments in the cloud. This blog post will review how engineering model transformations, driven by cloud requirements, resulted in several improvements in how we build, ship and service SQL Server. 

Features arrive faster

In the earlier days of SQL Server (2005 through 2012), SQL Server had roughly three-year long engineering cycles. For each planned release of SQL Server, a significant amount of planning would go into the up-front design, using a waterfall-like software development process coordinated across different teams. This included the generation of functional specification documentation by program managers, design specifications by developers and automated testing code developed by testers. 

Once SQL Server finally shipped, customers could take years to



November 2017 Leaderboard of Database Systems contributors on MSDN

Congratulations to our November top-10 contributors! Alberto Morillo maintains the first position in the cloud ranking while Visakh Murukesan maintains the top in the All Databases ranking.

This Leaderboard initiative was started in October 2016 to recognize the top Database Systems contributors on MSDN forums. The following continues to be the points hierarchy (in decreasing order of points):



Performance best practices for using Azure Database for PostgreSQL announced the public preview of Azure Database services for PostgreSQL and MySQL at Build 2017 which is a simple, fully managed database service for PostgreSQL and MySQL that removes the complexities around infrastructure management, data availability, protection, and scale. READ MORE



Connect your applications to Azure with Open Service Broker for Azure’m excited to announce today a preview of the Open Service Broker for Azure (OSBA), an implementation of the Open Service Broker API for Azure services. In a multi-cloud, multi-platform world, developers want a standard way to connect their applications READ MORE