Moar Azure

There are a number of choices for working in the cloud, aka, renting resources, but there are three big choices: Azure, AWS, and GCP. These three dominate the cloud services, though arguably AWS and Azure are way ahead. All three have lots of services, and all three can likely meet your cloud or hybrid needs, even if you work in a regulated industry or government.

This week there was a piece on the work Microsoft is doing to increase their capacity. Between the 0365 Office services, Teams for collaboration, and their regular PaaS/IaaS workloads, they've grown quite a bit this year with the COVID-19 pandemic. As they try to increase their resources, they've had people working round-the-clock to add new servers. I'm sure they are still using containers, but likely they are struggling to fill these with new hardware.

They've also been adding bandwidth, which is a bit need between the data centers. I had no idea they have their own undersea cables, but apparently they do. I suspect Amazon and Google do as well.  There is a note that they're also coding, trying to improve efficiency. After all, while you can throw hardware at a problem, many of us know that bad code can overwhelm those efforts. We see it in our jobs every day. I would hope that many of our organizations that might be depending on software more realize that better code is an advantage for us and our customers.

I know Microsoft runs a lot of their own stuff on Azure, including development work, and they've had to reschedule their internal workloads as well as move other work outside of regions. I think that's fine in many cases, but with different laws in different countries, I hope they're extremely careful about what moves. Data sovereignty can matter.

If you read through the article, it seems that Microsoft has learned a lot about adapting their work methods, both with people and systems, to meet the increased workloads. This is one area that I hope we see some detailed technical blogs, which might help others learn how to better manage their own resource challenges, or even learn to code better. While some of this might be proprietary, with the move to having many things open source, why not share ways to improve application resource usage.

Steve Jones - SSC Editor

Join the debate, and respond to the editorial on the forums

A few years ago I used an algorithm to help me wr...

Here is a quest that was submitted on the blog tod...

A quick post today about moving across database ti...

I’m not talking about “oops” mistakes. I’m...

Learn other people’s languages NABIHA SAKLAYENCl...

As the flood gates open up on Oracle for Azure Iaa...

Microsoft has been making lots of under-the-covers...

Microsoft Azure has two different kinds of storage...

Click here to learn more about Gilad David Maayan....

James Phillips, VP of Corporate Technology at Mizuho, joins us to share their Database DevOps transformation story. You'll hear how utilizing Database DevOps enables them to adapt quickly to market changes, with consistent and consolidated processes.

In our 2020 State of Database Monitoring report migrating your databases to the cloud, and monitoring them once there, came out as the biggest challenge. Join us to discover the best practices for overcoming these challenges.

SQL Server, Virtualization and Storage expert Davi...

I am pleased to announce the Summer o’ ADF, v2020, is on! Webinars: 12:00 PM EDT 22 Jun 2020 Configuring and Managing ADF Azure-SSIS Integration Runtimes Posts: Stop an Azure-SSIS...

Before using the Azure Data Factory’s REST API i...

TL;DR: To read the value portion of a key-value pair stored in JSON in an ADF pipeline, interrogate properties., where key is the key-part of the key-value JSON pair....

Excel format in Azure Data Factory. A welcome addition to ADF! When adding an ADF DataSet: I am convinced they got tired of me saying, “Well, you’ll need SSIS if...

Microsoft is changing the way its Windows Insider testing rings will work. It's also giving the rings new names, in keeping with the recently changed Office Insider ones.

Under compatibility level 150, in both SQL Server ...

Page Life Expectancy is a Perfmon counter that’s...

Introduction The Table Scan operator is used to read all or most data from a table that has no clustered index (also known as a heap table, or just...

For years, I hated troubleshooting servers with high CPU usage caused by queries constantly asking for new execution plans. Hated it. SQL Server just doesn’t make it easy to...

Have you wondered how to get a refresh date in you...

Dynamic measures are an effective way to avoid cro...

Originally posted on: http://iamsaif.com/darrengos...

In the previous post in this series I showed how you can use the Table.Join function and the SortMerge algorithm to get much better performance for merge operations in...

Thanks for watching this week's Power BI news roun...

Amazon Elastic Kubernetes Service (EKS) has quickl...

Microsoft will deliver a minor, cumulative-update-...

Originally posted on: http://iamsaif.com/darrengos...

Microsoft 365 Personal and Family subscribers in the U.S. now can get the 'Money in Excel' add-in, which enables spending-tracking and management.

Are you interested in guest posting? Publish at DataScience+ via your RStudio editor. Category Advanced Modeling Tags Data Management R Programming Text Mining In the present tutorial, I show an introductory text analysis of a...

This video is a 12 minute demo of how to quickly c...

What does ransomware do to a SQL Server? Ransomware The way that ransomware generally does their thing it encrypts files and then leaves some clues around telling you that...

South Africa's Postbank experienced a catastrophic...

Control-Flow Enforcement Technology will debut in Tiger Lake microarchitecture.

In a previous post, I explored an option for generating fake data in sql server using Machine Learning services and the R language. I've expanded on that by creating...

The SQL Server Integration Services Projects exte...