SQL Server on Virtual Machines Reviews & Product Details

No joke, migration of local SQL Database to SQL on virtual machine is "easy peasy:" simply spin up a virtual machine, back up your SQL Server instance, and restore it into the virtual machine - period! In addition, all the good stuff on your physical SQL server are available on the SQL server on virtual machine:

- Loads of tools and wizards that simplify tasks and help to get tasks completed without extensive knowledge of Database

- Query wizard with intuitive IDE

- excellent integration with other Microsoft products

- reliability plus performance

- easy administration, even via active directory

- Easy connection to external database

- additional benefit of optimization by the team that built SQL when hosted in Azure and also peace of mind that databases are highly-secured on the most compliant cloud

- Improve business continuity in the event of disaster by placing SQL Server Always On Availability Group replicas in virtual machines. Review collected by and hosted on G2.com.

- Back up is a breeze, but restoration of large database is challenging

- Software consumes a lot of memory as the database grows

- Great for mid to complex projects, but inadequate for large projects such as IoT projects

- software can use more monitoring tools Review collected by and hosted on G2.com.

This software is greatly reliable and quick. Backup and data recovery is quick and efficient. Data analysis is made so much easier through this process. Cloud flexibility and access even when remote is an added bonus. It is also compatible with multiple file systems and easy to migrate to and from. Review collected by and hosted on G2.com.

Honestly, not much to dislike. Licensing can prove to be an issue, but haven’t faced any software based issues so far. Review collected by and hosted on G2.com.

SQL Server on Virtual Machines really allows for the user to take full advantage of a mobile desktop outside of their office environments. So many times I've found myself in need of data or the ability to pull from our DHW but I can't trust my server to handle the bandwidth or even produce results within less than an hour. This software makes it so seamless and reliable to have all the benefits of the office when you are remote. Review collected by and hosted on G2.com.

It's nothing against the software but mostly against my company's excessive security about connecting to VMI and it's multi step process. Overall it makes it much harder when i have a bad connection to reconnect to the software b/c I have to restart everything. Again that's not really the software's fault, I personally blame my company issued laptops, but overall I wish something could be done about it. Review collected by and hosted on G2.com.

Operating system choice – support for Windows Server, Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and Ubuntu Linux.

Cloud flexibility – Set up and manage your SQL Server deployments in minutes, and then scale up or down.

Tuned for performance – Meet your toughest demands with virtual machines optimized by the team that built SQL Server.

Hybrid connectivity – Get the most out of your on-premises investments, and take advantage of all that Azure offers.

Highly-secured and trusted – Protect your entire data estate with a highly-secured database on the most compliant cloud. Review collected by and hosted on G2.com.

Mostly nothing to dislike. Functioning is pretty much same, when compared to desktop version. Spin up a new development environment in minutes, and only pay for what you use. Our SQL Server Developer images, including SQL Server 2017, provide a full SQL Server feature set in a free license for development and testing. SQL Server Express images allow you to host lightweight workloads (up to 1 GB memory and 10 GB storage) with a free license as well. Low virtual machine usage costs mean you pay only cents per hour, while using all the features you need for development and testing. Review collected by and hosted on G2.com.

I had to develop a utility to get status of automated jobs running throughout the day. So, SQL server came in handy and I wrote a SQL query to get the status of each job from the database. Review collected by and hosted on G2.com.

There is nothing to dislike in SQL server. It is one of the better tools ever created. Review collected by and hosted on G2.com.

The best thing about running SQL Server on a Virtual Machine includes a few different things.

1) The ability to run a virtual machine snapshot prior to doing updates. This allows for a quick roll back if the updated causes issues.

2) The ability to run a backup easily and with just a click. The speed of the backups is far better. Restoring from backup is much better.

3) The ability to increase resources on the virtual SQL server is so much simpler. Adding vCPU's and vRAM is very easy. Review collected by and hosted on G2.com.

I have no dislikes myself.

Some people do not like getting to the server console via a virtual management server.

But, I see no issue with this personally.

In fact I can get to things remotely much easier than with hardware only servers. Review collected by and hosted on G2.com.

Cost reduction, faster provisioning, ease for failover and disaster recovery. Great for doing development, migration, upgrade Work using snapshots. With proper performance tuning, we can leverage the features of virtualization. Review collected by and hosted on G2.com.

Management is more complex on a virtual environment. Need to manage more things, the physical host, the VMs, System Center. Performance tuning is very critical. Review collected by and hosted on G2.com.

You can just log in to virtual machine anytime and use it, doesn't take up your own space Review collected by and hosted on G2.com.

The risk on having virtual Machines disconnected issue or unable to login to the machine Review collected by and hosted on G2.com.

It is very userfriendly dbms and plus microsoft provides sql server management studio with the help of which one can easily design tables even without prior knowledge of sql server syntax Review collected by and hosted on G2.com.

Nothing to dislike. I love this product. Review collected by and hosted on G2.com.

its good for practise and helping us learn many things soon. Review collected by and hosted on G2.com.

the sql queries are being executed. there is nothing negative in it Review collected by and hosted on G2.com.