During the course of the last few weeks and months, we’ve been publishing many different articles related to automating database deployments, templates for database workloads in Windows Azure Pack (WAP), blog posts about how to leverage the WAP APIs to work with virtual machines and/or databases, and many others. All of these relate to specific subtopics in a larger “Database as a Service” solution.
Well, now is the time to bring everything together, and summarize some ways to enable Database as a Service with the Microsoft Private Cloud stack!
This time, instead of writing a blog post series, we’re providing the content as a downloadable document, similar to an eBook format. This will also simplify offline reading when needed.
– titled Enabling Database as a Service with the Microsoft Private Cloud stack –
is available here:
The document includes:
Update : In May 2015, this paper was updated with the latest changes and enhancements in Update Rollups (UR) 3, 5 and 6 for Windows Azure Pack. There are also a few additional FAQ entries in the second part of the document. Download link remains the same, and blog post for v1.1 is here.
The full agenda follows:
1. First, let’s define “Database as a Service”
2. Delivering Database as a Service scenarios through System Center and the Windows Azure Pack
- Preparing the VM Clouds fabric
– Templates for virtual machines with SQL Server
- Preparing the SQL Servers fabric
- Enabling Database as a Service for tenants, through Plans and subscriptions
- Looking at the tenant experience
– Plan subscription
– Creating a virtual machine with SQL Server installed
– Creating a database
3. Some requirements that make Windows Azure Pack a good fit for Database as a Service
4. Frequently Asked Questions about Database as a Service in the context of Windows Azure Pack
- Do I need to use both the VM Clouds and the SQL Server resource providers?
- What if I like the shared approach, but want to provide more dedicated servers to my tenants?
- How can I can provide additional value added services for my tenants when plans are subscribed?
- Can I pre-provision resources for my tenants, when they subscribe to my plans?
- Using Windows Azure Pack, can I also enable Database as a Service for other types of database software?
- My processes are largely based on ITIL today. How can I combine ITIL with Database as a Service?
- When using the shared model with the SQL Server Resource Provider, how can I ensure my tenants get their fair share of performance?
- Can I get data for potential chargeback with my tenants?
5. Other options with System Center
6. Looking beyond Database as a Service: Why Microsoft to virtualize and manage SQL Server
7. Appendix: Links reference
And, finally, here are the links leveraged throughout the document, provided as a reference for convenience:
- Building Clouds Blog – this is where you are now!
- Windows Azure Pack overview
- Overview of the SQL Server Resource Provider for Windows Azure Pack
- Service Models feed and the Web Platform Installer (WebPI)
- References for Creation, Configuration, and Automation of VM Role Gallery Items
- Sample VM Role Gallery Items for SQL Server, and Update to the Sample VM Role Gallery Items for SQL Server
- VM Role Example kit
- Configure SQL AlwaysOn Availability Groups in Windows Azure Pack
- SQL Azure Database Basic, Standard and Premium offerings
- Dedicating a part of the SQL Server fabric to a specific tenant
- Custom Resource Providers in Windows Azure Pack – Extending the Hello World Sample calling a SMA Runbook
- Automation–The New World of Tenant Provisioning with Windows Azure Pack (Blog post series). More specifically, Part 4 shows how to deploy Virtual Machines on behalf of a tenant, and Part 5 shows how to deploy SQL Server databases on behalf of a tenant, and discusses how to integrate with ITIL processes
- Custom Resource Providers in Windows Azure Pack – Moving from Hello World to your own Resource Provider
- VM Role Gallery Items for Oracle DB 12c
- Chargeback : Service Reporting feature overview
- Chargeback : Partner Cloud Cruiser
- SQL Server Self Service Kit
- SQL Server Self-Service Kit “SMA Edition”
- Oracle Self-Service Kit
- 1 million IOPS from a single VM at TechEd Europe 2012
- Windows Server 2012 Hyper-V Delivers On Scalability and Performance for Virtualized Enterprise Applications
We hope this all up document on the Database as a Service topic will be helpful. Thanks for reading and, as always, feel free to share any feedback!