April 10, 2020 at 9:09 pm
What are a few things that a SQL Server DBA must be aware of regarding Azure cloud?
A DBA who has never worked with it before (a friend of mine has an interview next week for a Developer role but they ask for Azure cloud experience).
Thanks.
Likes to play Chess
April 10, 2020 at 10:09 pm
Post deleted...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 13, 2020 at 10:33 am
First, tell your friend to simply be honest about their knowledge and experience. Next, some good news. To a large degree, SQL Server is SQL Server. Whether we're talking about Azure SQL Database, Managed Instances, Synapse, or VMs in Azure, under the covers, it's all SQL Server. So, the fundamentals are the same. The devil is in the details and the details depend on which of these services we're talking about. However, if your friend gets the job, they need to know that you do have to treat each of these services differently. There are variations in performance, behavior and management. Your friend should plan on learning these. While, mostly, it's just SQL Server. It isn't all just SQL Server.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 13, 2020 at 4:20 pm
Performance is more variable. You could read about the differences there. You also don't have the same control. You can't see hardware, and must work on any issues with looking inside the database and correlating any issues with DTU usage. Billing is an issue, and likely a DBA needs to have a more active role here.
There are limitations on DR (restores) as well as less features. Not a lot, but some. Other than that, Grant has a good answer.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply