Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News
Hand-picked content to sharpen your professional edge
Editorial
 

Microsoft and Oracle Cloud Partnership

Many of us checked to make sure it wasn’t April Fools Day a couple of years ago when Microsoft announced that SQL Server 2017 would run on Linux. This means that some shops who want to run SQL Server, but not Windows Server, now can. But it also means that SQL Server professionals need to either dust off their Bash scripting skills or develop them in the first place.

We were shocked once more last year when Microsoft purchased GitHub. Personally, I wondered if the diehard anti-Microsoft crowd would quickly move to some other platform, but it hasn’t happened. This acquisition helps Microsoft become a real leader in DevOps.

After all that, you would think that everyone would be prepared for the latest news. Recently, Microsoft announced a cloud interoperability partnership with Oracle! The two companies compete in many ways, but the rivalry in database platforms made the news especially shocking to SQL Server database professionals, many of whom have always seen Oracle as “the enemy.” Of course, some of us who have built careers by focusing on SQL Server have worked with Oracle databases, too, even if it’s just migrating data from Oracle into a data warehouse. Lots of organizations run both Oracle and SQL Server, so refusing to work on other database platforms, even when you specialize in one, could severely limit your career opportunities.

The partnership between Microsoft and Oracle makes sense and benefits both organizations. You can already run many Oracle apps in Azure, but now there is a way to run Oracle applications in Azure connected to its Autonomous Database in Oracle Cloud. It’s also a way for organizations running Oracle applications on premises or in the cloud to easily take advantage of the analytics platform found in Azure. Because of a highly reliable network, single sign on, collaborative support, and license mobility, connecting to both clouds should be seamless for customers. The technology to make this happen is in place in some eastern US data centers, and a handful of organizations are already using it.

This partnership will simplify moving to the cloud, especially for those companies running their businesses on Oracle but wanting to take advantage of analytics and AI services found in Azure. It’s a win for the organizations and their customers, and I can’t wait to see what happens next.

 

 

Kathi Kellenberger

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

 
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
AI/Machine Learning/Cognitive Services

Microsoft’s Goal to Democratize AI Reaches the Power Platform

This week, Microsoft is in Atlanta where the compa...

Administration

Query machine name of the sql server instance - the hard or the harder way

I was at a client where they are using non-Microso...

Default Schemas in SQL Server

Max Vernon takes us through the order in which SQL...

Extended Event Filters Outlive Sessions

Dave Bland ran into an interesting problem during ...

SQL Server 2019: Compatability Level’s Day Of Reckoning

Skin Tags Stop me if you’ve heard this one: “W...

SQL SERVER – Script: Find Last System / Operating System Reboot or Restart Time

Sometimes we need to find last reboot time of the ...

Clustered Index Scan

Introduction The Clustered Index Scan operator is ...

Basic SQL Server Configuration Help for Involuntary DBAs

After my presentation at the Techno Security and D...

Import Local SQL Server Database to Azure – Pick the Best Method

It is not unknown to the SQL users that some of th...

Alerting When SQL Agent Jobs Fail

John Shaulis has a script to send out e-mail alert...

A Sizing Problem with Heaps

Slava Murygin shows an example where adding a clus...

Analysis Services / BI on the MS Stack

Paginated Report Bear And The Future Of Analysis Services Multidimensional

“Who, or what, is Paginated Report Bear?” I he...

Azure CosmosDB

Azure Cosmos DB Intro

Cosmos DB falls into the “NoSQL” technology gr...

Azure Cosmos DB Local Emulator

Technically you do not have to create a cosmos DB ...

Azure SQL Managed Instance

Comparing On-Prem To Managed Instance Performance

Jovan Popovic has an article explaining how you ca...

Career Growth

As a DBA, how do I offload some of my work?

I don’t have time for this “I am a DBA, I am b...

Dear Speaker, Your Time is Up

Peeves make lousy pets, but I own a few nonetheles...

What Happens to DBAs When We Move to the Cloud?

I’m finishing up a bit of a summer tour – Tech...

Now is the time to sharpen your cloud database skills. Here’s how to start.

Many of us DBAs have been able to put off dealing ...

A letter to my 20 year-old self

This post is a part of #tsql2sday, a monthly commu...

Redgate SQL Prompt
Computing in the Cloud (Azure, Google, AWS)

Moving SQL Databases to the Cloud with the Data Migration Assistant

If you are moving SQL database instances into Azur...

Data Privacy, Compliance, and GDPR

10 steps you can take to be compliant worldwide – free whitepaper

Learn how data protection legislation is changing around the world and the 10 steps database teams can take to ensure compliance and defend against data breaches.

DevOps

How Developers and DBAs Collaborate in a DevOps World (video)

You’re a DBA, and your development team is all-i...

Offloading Code Review Burdens with Automation

Ed Elliott argues that automation and testing can ...

What steps are there to move to safe automated database deployments?

Database deployments are scary, you have all this ...

Combining Machine Learning with DevOps

Rolf Tesmer explains that machine learning and Dev...

Managing Database Changes with Scripts

Ed Elliott continues a series on automated databas...

ETL/SSIS/Azure Data Factory

Azure DevOps - Build SSIS project (CI)

CaseI have my SSIS project in Git (Azure Repos Git...

HA/DR/Always On/Clustering

The danger of HADR_SYNC_COMMIT wait and synchronous replication in AlwaysOn Availability Groups

The life of Database Engineer is never boring. We ...

Kubernetes + AGs + SQL Server 2019 CTP 3

Allan Hirt has a fix for an annoying bug in the la...

Machine Learning

Multiple Logistic Regression in Python

Are you interested in guest posting? Publish at Da...

Performance Tuning SQL Server

Making Non-SARGable Queries SARGable with an Index

Denis Gobo violates Betteridge’s Law of Headline...

Physical Operators: Apply and Nested Loops

Paul Whtie takes us through the Apply operator ver...

Columnstore Index Scan

Introduction The Columnstore Index Scan is not rea...

PowerPivot/PowerQuery/PowerBI

Removing HTML Tags From Text In Power Query/Power BI

Recently I found I needed to remove all the HTML t...

Using Power Query to Pivot Text

Matt Allington shows how you can pivot text data f...

Syncing slicers in Power BI

The June 2019 update of Power BI includes the abil...

Solving a Complex Time Problem In Power BI

Level: Intermediate I was delivering some training...

Reporting Services

How to Uninstall Microsoft SQL Server 2017 Reporting Services

I had to uninstall SQL Server 2017 Reporting Servi...

T-SQL

Learn Basic Data Analysis with SQL Window Functions

This article is about T-SQL (Transact-SQL) Window ...

Does the case statement short circuit?

Let’s start with definitions: CASE Statement: Th...

T-SQL bugs, pitfalls, and best practices – Joins

Itzik Ben-Gan continues his series on T-SQL bugs, ...

Just Using sp_executesql Doesn’t Make Dynamic SQL Safe To Use

Safe Belt A lot of people I’ve talked to about d...

T-SQL SET Operators Part 2: INTERSECT and EXCEPT

In my previous article, I explained the basics of ...

Vendors/3rd Party Products

How to provision realistic and compliant data to development – free whitepaper

Compare common approaches to provisioning test data to database development teams, and assess how they stack up in terms of delivering realistic test data, managing bottlenecks, and meeting data privacy regulations.

Virtualization and Containers

Containers and Data

Randolph West argues that you should keep data and...

Containers and data: you gotta keep ’em separated

There was an interesting conversation on Twitter r...

Webinars

Taming the Wild West

Thursday June 27 16.00-17.00 / 10.00-11.00 Central - How Standard Bank overcame technical and cultural challenges to implement database CI/CD.

The State of SQL Server Monitoring 2019

Tuesday June 25 16.00-17.00 / 10.00-11.00 Central - Join our expert panel as they discuss the key findings of Redgate’s 2019 State of SQL Server Monitoring survey.

Standardize Database Development Across your Organization in 4 Key Steps

Monday June 17 16.00-17.00 / 10.00-11.00 Central - Discover how adopting 4 steps will lay your foundations for automation and Compliant Database DevOps.

 
RSS FeedTwitter
This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -