SQL server 2014 SP1 and Azure SQL service

Dear all,

as we all knew that SQL server 2014 SP1 just released, and I am not sure if the Azure SQL service from MS cloud needs to upgrade to SP1 manually by us or it will be handled by Microsoft in this side, any idea?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
You could download the SP1? Microsoft took it back since they found problems with it. Information from SQL Server Engineering team here.
Anyway I think you shouldn't bore with the SP1 in Azure. Microsoft should do that for you as part of their service.
0
Éric MoreauSenior .Net ConsultantCommented:
If you are using SQL Azure, you don't and you cannot install patches.

Only if you run VMs you can (and you need to) install patches.
0
marrowyungSenior Technical architecture (Data)Author Commented:
Éric Moreau,

"Only if you run VMs you can (and you need to) install patches."

you mean if we host the VM ourselves and SQL server ourselves then we can do it manually ?

Vitor,

"You could download the SP1? Microsoft took it back since they found problems with it"

tks, what's wrong with MIcrosoft recently? the WP10 for lumia 920 is a rubbish ! can't see why !

Their security patches is good, which can take 9xxMB- 1.x GB each time.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

marrowyungSenior Technical architecture (Data)Author Commented:
basically for Azure SQL, how often they patch it once those SP release?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Basically it says: "We have chosen to remove SQL Server 2014 Service Pack 1 (SP1) from the Microsoft Download Center due to a significant installation issue discovered shortly after release. We sincerely apologize for the inconvenience this has caused you."
0
marrowyungSenior Technical architecture (Data)Author Commented:
yes I saw that.

I am not sure how often MS patch their Azure SQL.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
I think that if they're offering a service that the need to assure that the service is always up to date.
0
Éric MoreauSenior .Net ConsultantCommented:
>>you mean if we host the VM ourselves and SQL server ourselves then we can do it manually ?

You can host VMs in Azure. These VMs can run any softwares you need. These VMs need to be patched by you.

>>basically for Azure SQL, how often they patch it once those SP release?

Microsoft is adding new feature and installs patches more often then they are releasing to public.

Don't forget that the Azure version is not fully a version you can buy at the store. It is a special version tailored for the cloud.
0
marrowyungSenior Technical architecture (Data)Author Commented:
"You can host VMs in Azure. These VMs can run any softwares you need. These VMs need to be patched by you.
"
ok , so Azure is the name of MS cloud only and I just think Azure just made of VMs ! you know I think this is how MS cloud make of ..

"Don't forget that the Azure version is not fully a version you can buy at the store. It is a special version tailored for the cloud. "

I knew that, but I heard that Azure SQL v12 has almost everything as SQL server 2014,  right?

"Microsoft is adding new feature and installs patches more often then they are releasing to public."

so this means.... ? so they patch for us without killing our cloud production you mean ?

also is there any way for me to get a free Azure SQL ? it seem I have to pay them even for testing purpose only ?
0
Éric MoreauSenior .Net ConsultantCommented:
Think of Azure much as Office. In the sense that it is a group of products packaged under the same name. Office contains Word, Excel, Outlook, ... while Azure contains SQL Databases, VMs, Storage, HD Insight and many more (see the attached image for part of the services).

So what I say is that if you are hosting a VM in Azure, you are fully responsible of patching it. If you subscribe to any other services, they patch it for you. This is what we call PaaS (Platform as a service).

When you subscribe to an Azure service (other then VMs), Microsoft really has (at least) 2 copies of it. When they need to apply patches, they don't do both at the same time so you don't feel that one is being updated.

If you have a MSDN subscriptions, you have about some credits that you can use every months.
2015-04-18-7-49-44.png
0
marrowyungSenior Technical architecture (Data)Author Commented:
"So what I say is that if you are hosting a VM in Azure, you are fully responsible of patching it. If you subscribe to any other services, they patch it for you. This is what we call PaaS (Platform as a service)."

good, or Saas ? haahha

"When you subscribe to an Azure service (other then VMs), Microsoft really has (at least) 2 copies of it. When they need to apply patches, they don't do both at the same time so you don't feel that one is being updated."

so how they combine to one later without killing our platform ?

"If you have a MSDN subscriptions, you have about some credits that you can use every months. "

we don't have, I just want to have a personal access, any idea ? free access.
0
Éric MoreauSenior .Net ConsultantCommented:
>>so how they combine to one later without killing our platform ?

One instance is up with the current version while they update the second one.

>>free access.

http://azure.microsoft.com/en-us/pricing/free-trial/ is the only thing I know
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.