none
Pricing implications for Azure VM with Sql Server installed RRS feed

  • Question

  • I am editing this question to include the scenario.

    Below the asterisk's is the original question...

    Scenario:

    We are customer of company ABC.  We use their software.

    Every day, they make a copy of our database for us on their network.

    We can connect to that, query, etc.

    We want, on a daily basis, to update this on our network, by some means.

    We use this for BI.

    What do you propose?

    *****************************  ORIGINAL QUESTION **************************

    Our company plan is to have a SQL server installed on a Microsoft VM.

    Question #1:

    If we delete and restore a 50 gig database every day, is there a higher price tag due to our activity, and if so, is it significant?

    We will be receiving new file daily on ftp.

    Question #2:

    Because we have an instance on a VM, we should just be able to install SQL server and use it as a normal server, meaning we should be able to have stored procedures, views, etc. that you cannot get when you let Microsoft host  your server--Is this a true statement?

    Thank you

    Kam


    Tuesday, November 5, 2019 10:09 PM

All replies

  • Hello Kam,

    Thank you for reaching out.

    I am not sure what your use case is for dropping and deleting a database everyday. Is that a 50 gig back up file over ftp?

    Restoring a 50GB database from backup is a CPU intensive operation and you will be billed for it. However you can choose an appropriate SKU and limit the cost.

    Please provide the scenario to help us make a better recommendation

    Regarding your second question

    For all practical purposes, the lines between SQL server on a VM and Azure SQL have blurred significantly.

    You can get more details about the right deployment option here

    You will be able to create and use Stored Procs, views etc on Azure SQL just like SQL on a VM

    Yes you have greater control of your environment when you deploy on a VM but lose out on high availability, automatic patching etc. 


    Wednesday, November 6, 2019 6:50 AM
    Moderator
  • Question #2:

    Because we have an instance on a VM, we should just be able to install SQL server and use it as a normal server, meaning we should be able to have stored procedures, views, etc. that you cannot get when you let Microsoft host  your server--Is this a true statement?

    Sure, use SSMS  to mange your instance 

    If we delete and restore a 50 gig database every day, is there a higher price tag due to our activity, and if so, is it significant?

    We will be receiving new file daily on ftp

    Perhaps you can fined another way to keep the data sync without delete the db every day?


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Wednesday, November 6, 2019 9:12 AM
  • updated question.... see section on question before asterisk...

    Thank you.

    Wednesday, November 6, 2019 2:39 PM
  • updated question.... see section on question before asterisk...

    Thank you.

    Wednesday, November 6, 2019 2:40 PM
  • Ok great. Thank you for the additional context.

    I am assuming you will keep "your database" until the next day when you drop and recreate it again.

    Yes, SQL server on a VM should work for you.

    You could use SSIS as an ETL solution to copy the database from source to your instance. You have the flexibility of transferring the entire database or selectively copying the tables, procs etc that are required for your BI needs.

    Please check Transfer SQL Server Objects Task 

    Do let us know if you have further questions.

    -

    If this answers your query, do click “Mark as Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread . 

    Saturday, November 9, 2019 3:30 PM
    Moderator
  • 1) SSIS 

    2) BACKUP and RESTORE


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Sunday, November 10, 2019 4:54 AM
  • Just checking in to see if the above answer(s) helped.

     

    If this answers your query, do click “Mark as Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .

    And, if you have any further query do let us know. 

    Wednesday, November 13, 2019 2:47 PM
    Moderator