Category Archives : Database

09

Nov

Meeting developer needs with powerful new features in Azure Cache for Redis

In May, we announced a groundbreaking partnership with Redis Labs to bring their Redis Enterprise software to Azure as a part of Azure Cache for Redis. We were humbled by the level of excitement and interest we received. We are announcing that you can now use Redis to tackle new challenges while making your caches larger and more resilient than ever before.

There has never been a more critical time for a technology like Redis. With billions of people working from home globally, web-based applications must be more responsive than ever, and enterprises both large and small need to be able to scale rapidly to meet unexpected demand. Solutions like Redis empower developers to optimize their data architectures and solve these problems. We’ve seen tremendous adoption of Azure Cache for Redis, our managed solution built on Open Source Redis, as Azure customers have used Redis as a distributed cache, session store, and message broker. We’re excited to incorporate Redis Enterprise technology and make this solution even more powerful and available while also unlocking important new use cases for developers like search, deduplication, and time series analysis.

What is Redis Enterprise on Azure?

Microsoft and Redis Labs have partnered closely to

Share

27

Oct

Azure Cost Management and Billing updates – October 2020

Whether you’re a new student, thriving startup, or the largest enterprise, you have financial constraints, and you need to know what you’re spending, where, and how to plan for the future. Nobody wants a surprise when it comes to the bill, and this is where Azure Cost Management and Billing comes in.

We’re always looking for ways to learn more about your challenges and how Azure Cost Management and Billing can help you better understand where you’re accruing costs in the cloud, identify and prevent bad spending patterns, and optimize costs to empower you to do more with less. Here are a few of the latest improvements and updates based on your feedback:

Introducing the Azure Advisor Score Create subscriptions with ARM templates Tell us what you need when verifying billed charges What’s new in Cost Management Labs New ways to save money with Azure New videos and learning opportunities Documentation updates

Let’s dig into the details.

 

Introducing the Azure Advisor Score

Wouldn’t it be great to have some assurances that you’re running your workloads in a cost-efficient manner? That’s exactly what Azure Advisor gives you and now, with the Advisor Score, it’s easier than ever for you

Share

08

Oct

Compete. Learn. Win. Sign up for the Azure SQL Championship Today

The last six months have seen an unprecedented acceleration in digital transformation. There has never been a more important time for database administrators (DBAs) and developers to prepare for an increasingly cloud-centric future. However, we’d like to make this interesting and fun. That’s why we’ve partnered with PASS, a worldwide community of over 300,000 data professionals, to create an interactive learning experience that allows you to test your talent and build your skillset for the future—all while earning to chance to win prizes. Sign up now for the Azure SQL Championship, starting October 12, 2020.

Here are three great reasons to compete:

1. Learn about Azure SQL the fun way

Who says that learning about virtualized instances of SQL Server can’t be exciting? The Azure SQL Championship is different from a webinar or training session. Enjoy special videos from SQL experts like Bob Ward as he introduces the challenges and provides helpful hints for participants. Be sure to watch for the daily quizzes and trivia to earn badges and climb the leaderboard! If you’ve meant to learn more about Azure SQL, this is a fantastic way to start.

2. Win recognition and prizes

A little competition never hurt anyone. Complete

Share

30

Sep

Azure Cost Management + Billing updates – September 2020

Whether you’re a new student, thriving startup, or the largest enterprise, you have financial constraints, and you need to know what you’re spending, where, and how to plan for the future. Nobody wants a surprise when it comes to the bill, and this is where Azure Cost Management + Billing comes in.

We’re always looking for ways to learn more about your challenges and how Azure Cost Management + Billing can help you better understand where you’re accruing costs in the cloud, identify and prevent bad spending patterns, and optimize costs to empower you to do more with less. Here are a few of the latest improvements and updates based on your feedback:

Simplify financial reporting with cost allocation, now in preview. Connector for AWS is now generally available. Get pay-as-you-go rates for all Azure products and services. What’s new in Cost Management Labs. Expanded availability of resource tags in cost reporting. 15 ways to optimize your Azure costs. New ways to save money with Azure. Upcoming changes to Azure usage data. Documentation updates.

Let’s dig into the details.

 

Simplify financial reporting with cost allocation, now in preview

Managing cloud

Share

08

Sep

View your Azure Cache for Redis data in new Visual Studio Code extension

Azure Cache for Redis is an in-memory data store that is used to power fast, scalable applications. Now in preview, you can access all the caches under your Azure subscriptions and view their data with the new Azure Cache for Redis Visual Studio Code extension.

With this new integration, you’ll be able to use Visual Studio Code to view, test, and debug your caches—in one streamlined experience. This extension enhances ease of development by eliminating the need to manually track connection and access keys to connect to your caches. Simply authenticate with your Azure account, and you’ll instantly be able to access your Azure Cache for Redis instances.

This extension supports both common configurations—clustered and non-clustered caches, as well as all Redis data types, such as strings, lists, hashes, and sets. With it, you’ll be able to filter Redis keys by match expressions. Ultimately, this extension gives you more time to focus on development, debugging, and testing your application on your terms.

Installation and usage

The Azure Cache for Redis extension can be downloaded from the Visual Studio Code Marketplace or within Visual Studio Code by searching for Azure Cache in the extension tab.

Marketplace will direct you to open

Share

24

Aug

Power mission-critical applications with Azure Database for PostgreSQL

In our current environment, organizations are increasingly looking towards digital solutions to engage their customers and remain competitive. They’re discovering that their customers’ needs can be best met through differentiated, digital experiences delivered by cloud-native applications.

When building a new application, one of the most important decisions to make is where to store the application data. We see tremendous interest in Azure Database for PostgreSQL when it comes to storing relational data in the cloud for mission-critical applications. Here’s why:

Why Azure Database for PostgreSQL? 100 percent open source. Azure Database for PostgreSQL is built on community edition Postgres, with open extension support so you can leverage valuable PostgreSQL features, including JSONB, geospatial support, and rich indexing. Our Postgres team at Microsoft is committed to nurturing a culture of contributing to and collaborating with the Postgres community, and we’re excited to welcome Postgres committers to the team. These committers review submitted code for Postgres, “commit” it into the source code repository, and work with other contributors to test, refine, and eventually incorporate it into the next Postgres build. In future blogs, they’ll share what they’re working on when it comes to new versions of Postgres and updates

Share

05

Aug

New Azure SQL Learning Tools help reduce the global technology skills gap

Microsoft’s learning solutions pave the way toward data-centric jobs of the future

“It’s been forecasted 800 million people need to learn new skills for their jobs by 2030. In this time of change, people are hungry to learn, gain new skills, and grow their economic opportunity.”—Satya Nadella, CEO, Microsoft

Across Microsoft, we are helping a new generation of technology workers develop the right level of skills. Recently, Microsoft announced the availability of new virtual learning programs. These programs, focused on technical topics, are already helping people enhance their digital expertise and, for some, are providing a foundation for success in a new career path.

Building upon this goal, we’re excited to announce the Azure Data team’s latest additions to these educational programs.

Our all-new content will help beginners being introduced to Azure as well as SQL experts learn how to understand the benefits of Azure SQL. Since SQL Server and Azure SQL share the same engine, these new set of tools builds upon familiar content. This means SQL Server professionals can become Azure SQL professionals with just a little bit of help, such as:

Microsoft Learn learning path: This six-course Azure SQL fundamentals learning path provides a built-in lab environment

Share

28

Jul

Three reasons to migrate your ASP.NET apps and SQL Server data to Azure

The way we work and live has changed. Over the last several months, enterprises have had to shift their strategy from “physical first” to digital first and accelerate their digital transformation to enable remote productivity, reduce costs, or rapidly address new opportunities. In a digital first world, websites and web applications play a significant role in how customers interact with a business. To make a great first impression, companies are modernizing their web applications and data to the cloud for optimal performance, and saving money along the way.

Nearly a third1 of the world’s public websites are built on ASP.NET, and for good reasons; it’s fast, scalable, and secure. What if you could combine those benefits with the operational and financial benefits of the cloud? Microsoft Azure offers the only end-to-end application hosting platform to build and manage .NET applications, enabling significant cost savings, operational efficiencies, and business agility.

Here are three ways you’ll benefit from migrating your ASP.NET apps and SQL Server data to Azure.

Optimize costs with fully managed services that do more for you

Operating your .NET applications on a fully managed platform allows your teams to focus on what matters most by offloading apps, infrastructure, and

Share

28

Jul

Eight ways to optimize costs on Azure SQL
Eight ways to optimize costs on Azure SQL

Across the globe, businesses are emerging into a new normal, eager to restart or rebuild, but still operating in uncertain times. Optimizing costs and redirecting the spend to where it matters most is as important as ever, and many companies see the cloud as a way to control costs, build resilience, and accelerate time to market.

Customers choose Azure for a variety of reasons, but one of the main reasons is to lower their costs. What more could you do if you could save up to 80 percent or more on your database costs? We introduced the Azure SQL family of database services to help businesses cost-effectively adapt and scale to rapidly changing conditions. Here are the top eight ways you can optimize your data spend, with savings available wherever you are in your digital transformation journey.

1. Maintain business continuity in the cloud with free SQL Server licenses

Use your active Software Assurance benefit to get a free license for every SQL Server in your datacenter for a secondary passive replica you can use for disaster recovery to an Azure Virtual Machine.

2. Shift capex to opex with SQL Server on Azure Virtual Machines

Migrating your data to virtual

Share

11

May

Office Licensing Service and Azure Cosmos DB part 2: Improved performance and availability

This post is part 2 of a two-part series about how organizations use Azure Cosmos DB to meet real world needs, and the difference it’s making to them. In part 1, we explored the challenges that led the Microsoft Office Licensing Service team to move from Azure Table storage to Azure Cosmos DB, and how it migrated its production workload to the new service. In part 2, we examine the outcomes resulting from the team’s efforts.

Strong benefits with minimal effort

The Microsoft Office Licensing Service (OLS) team’s migration from Azure Table storage to Azure Cosmos DB was simple and straightforward, enabling the team to meet all its needs with minimal effort.

An easy migration

In moving to Azure Cosmos DB, thanks to its Table API, the OLS team was able to reuse most of its data access code, and the migration engine they wrote to avoid any downtime was fast and easy to build.

Danny Cheng, a software engineer at Microsoft, who leads the OLS development team explains:

“The migration engine was the only real ‘new code’ we had to write. And the code samples for all three parts are publicly available, so it’s not like we had to

Share