Using SQL Server Management Pack in VCF Operations with DSM provisioned SQL Server

Many of my recent posts have focused on the new Microsoft SQL Server data service in the 9.1 version of VMware Data Services Manager (DSM). On the back of those posts, I had a query about whether it was possible to use the Microsoft SQL Server Management Pack for VCF Operations that is available on the  VCF Solutions Catalog with DSM provisioned SQL Servers. The short answer is yes, you can install this management pack in your VCF Operations and create a SQL Server account for it. The Management Pack for Microsoft SQL Server now connects to your Microsoft SQL…

Using VCF Automation 9.1 Blueprints to snapshot and clone DSM provisioned MySQL databases

In my VMware Data Services Manager 9.1 launch post, I mentioned that this release now has the ability to use vSAN ESA snapshots to create a copy of a MySQL database. I also mentioned that this snapshot could then be used to very quickly spin up additional copies of the database using the “clone from snapshot” feature. I also mentioned that this feature is not yet plumbed up into the VCF Automation UI, but that it is available via the API. And since that is the case, it is then possible to go ahead and create VCF Automation blueprint. The…

Configuring SQL Server with VCF Automation & Data Services Manager versions 9.1

In my most recent post, we looked at the steps to deploy the new Data Services Manager 9.1 SQL Server data service. In that post, we created an infrastructure policy to allocate vSphere resources such as CPU, Memory, Networking and Storage to the SQL Server Engine and subsequent databases. We saw how this approach can offer a DBaaS (Database as a Service) to your end-users, allowing consumers to use the DSM portal to provision their own databases on an existing SQL Server instance. In this post, we want to take that a step further and show how Data Services Manager…