Fast Start for Microsoft Azure - SQL Server on IaaS
-1097280-1196340Fast Start for Microsoft Azure - SQL Server on IaaS00Fast Start for Microsoft Azure - SQL Server on IaaSPOC Delivery GuidePrepared for DOCPROPERTY Customer \* MERGEFORMAT Partner Enterprise Services SAVEDATE \@ "M/d/yyyy" \* MERGEFORMAT 10/14/2016Prepared byGreg HusemeierSeba ClementoniContributorsSitumalli Chandra MohanKrishna GollaTable of ContentsContents TOC \o "1-3" \h \z \u 1Introduction PAGEREF _Toc464238847 \h 12Deliver Azure Fast Start POC PAGEREF _Toc464238848 \h 23Engagement Phases PAGEREF _Toc464238849 \h 33.1Pre-engagement Information-Gathering Phase PAGEREF _Toc464238850 \h 33.1.1Kickoff Meeting PAGEREF _Toc464238851 \h 33.2Delivering the Engagement PAGEREF _Toc464238852 \h 53.2.1Engagement Schedule PAGEREF _Toc464238853 \h 53.2.2Define Migration POC Options PAGEREF _Toc464238854 \h 53.3Closeout Meeting PAGEREF _Toc464238855 \h 74References PAGEREF _Toc464238856 \h 94.1Windows Azure Virtual Machine Readiness Assessment PAGEREF _Toc464238857 \h 94.2General Azure Virtual Machines (IaaS) PAGEREF _Toc464238858 \h 94.3Network and Connectivity PAGEREF _Toc464238859 \h 94.4SQL Server on Azure IaaS PAGEREF _Toc464238860 \h 9IntroductionThe Azure Fast Start SQL on IaaS POC is intended to help the customer deploy SQL Server IaaS instances to support a specific business solution that the customer wants to test on Azure. This document covers the steps required to deliver the Azure Fast Start – SQL on IaaS POC.Deliver Azure Fast Start POCFast Start for Microsoft Azure - SQL Server IaaS Workshop presentation slidesHands on demo documentsEducation Guide for migration of SQL to Microsoft Azure IaaSMake it real POCThe ultimate deliverable of this Offering, will have a customer SQL server database running on Azure IaaS as a POC.Scoping Document – Provides some helpful questions to be used during the Scoping\Kickoff call with the customers. These questions are very critical for a successful Fast start engagementMicrosoft Azure Fast Start Delivery Guide – Guide written by Microsoft explaining all the processes to be followed by the as part of the Fast start engagementEngagement PhasesPre-engagement Information-Gathering PhaseFor this engagement to be successful, it is vitally important that it is delivered within the context of a specific customer situation and environment and it is essential to find out as much as you can before the onsite visit. Please get in touch with the Account Manager to know more about the customer’s involvement with AzureAfter the ROSS is dispatched, you need to understand the purpose of the fast start delivery. Different customers have different level of maturity and scale of Azure deployments in their environment. Fast Start delivery can be done to enable the customer to increase cloud consumption, onboard a customer who is new to Azure technology, position Azure in a compete situation etc.Customer would require an Azure subscription for performing the POC. They can either use their existing enterprise Azure subscription or trial Azure subscription. Sometimes, business group such as product groups might provide a limited Azure subscription for the Faststart engagement. Prior to the Scoping or Kick Off meeting, check with the Account Manager whether any limited Azure subscription will be used for this Faststart engagement.Kickoff MeetingThe kickoff meeting is an important part of the engagement because it helps both partner and the customer understand what the goals and the scope of the engagement are and what is required to successfully deliver the engagement within the given constraints. You will also discuss logistics for the time you will be delivering the engagement, specifically regarding what activities will be taking place and what is required to perform these activities. Work with the Account Manager to schedule this meeting in advance of this Fast Start. This meeting is very critical for this engagement compared to any other IP offeringsThe agenda for this kickoff meeting is:IntroductionsCurrent EnvironmentFast Start Overview and ObjectivesActivities and TimelineSchedule and MilestonesNext Steps and Action ItemsQuestions and AnswersPlease refer to the “Scoping document” on some of the sample questions we have prepared for both the operational and technical aspects.Verifying Customer Benefits from EngagementEngage project stakeholders to confirm that expectations have been correctly set. This discussion should include tangible customer benefits that will be identified by the engagement. Focus on technical, business, and operations aspects as appropriate. Consider using a small, less complex environment as part of the POC. Sample items include:Help me understand using Microsoft Azure to migrate on-premises SQL Server databases to Azure IaaS.You should be asking yourself these questions when preparing for the engagement.Does the customer currently use Microsoft Azure and what are they using it for?Will the attendees have Azure accounts configured for their usage?Has a virtual network been configured between the customer and Azure datacenters?Will the attendees be able to access this network from the training facility?How can we bring the customer to a solution faster?Once again, please refer to the scoping document for more detailed questions for both technical and operational topics.Sample Scenarios to Propose for POCWe would highly recommend to implement the (“Migrate existing database to cloud”) as the best option for the POC as we can showcase several aspects of the migration process and also the customer can see the immediate value add of migrating a SQL server database in cloud infrastructureMigrate existing database to cloud (Preferred option) Migrate a database to SQL Server on an Azure VMIn case the customer is not interested in migrating any of their on-premises databases(Prod\Test) to Azure OR if you have more time left in the POC engagement, try the below options as necessary.Use Cloud for setup of Dev/Test environment (Optional)Microsoft Azure dev/test scenario considerationsUse cloud as a High Availability and/or Disaster Recovery solution (Optional)High Availability and Disaster Recovery for SQL Server in Azure Virtual MachinesUse cloud only for backups (Optional)SQL Server Managed Backup to Windows AzureHow to Use Azure Storage for SQL Server Backup and RestoreDelivering the EngagementThe engagement is created to be delivered by a single person with collective knowledge in Microsoft Azure, IaaS, virtual networks, Blob storage and SQL server.Roles and ResponsibilitiesDuring the kickoff meeting, it is critical that the roles and responsibilities be clearly defined and agreed to. This is especially important because of the tight timelines and rigid engagement model. At a minimum, the should know who the primary point of contact will be during the engagement to verify the customer is constantly engaged and providing the required information. You must make it clear that the customer’s staff will be asked for their active participation and assistance during the Fast Start and that a person who is familiar with customer’s usage of Microsoft Azure portal is available (at least at the beginning of the Faststart) to ensure that attendees can access their company’s Azure portal.Engagement ScheduleEnsure that the facility is available for the duration of the Faststart and that high speed internet access is available from the training room.Define Migration POC OptionsFor a 3-day delivery, prior to the start of day 3, you should:Identify the business need that the POC will address.Identify smaller applications or websites that would be candidates for Azure migration. This information has to be passed to the customer during the Kickoff\scoping call itself so that they will have enough time to finalize the App\Database to migrate.What database will be migrated, and verify if a database upgrade is required. Verify that if you are doing an upgrade from an older database, target SQL 2005 or newer.Determine Identity Migration Requirements (Windows Authentication, etc.)Active Directory on Microsoft Azure IaaS will likely be out of scope for the POC, but with a properly configured VPN connection, they can still domain join machines to an existing on-premises AD. You should already have this information collected during the Kickoff\Scoping call and set the expectations accordingly.Determine data migration requirements and strategyLooking at these dimensions in detail you should accomplish the following activities:Migration ActivitiesEnsure that the appropriate test infrastructure is built using the customer’s Azure subscriptionEnsure the network and Identity/Access infrastructure is in placeEnsure that the proposed website or application has been migrated to the cloud. Please note that the customer normally owns the responsibility of migrating their application to cloud. Migrate current version of SQL Server to Microsoft Azure Virtual MachinesTest the Azure website or application to ensure that it meets the customer’s requirements.Consider the following table when choosing your database migration options:Database Migration OptionsPlan your Virtual Machine Size: how to move your workload to Azure Virtual Machines: Database VersionDestination Database VersionSource Database Backup Size ConstraintNotesUse the Deploy a SQL Server Database to a Microsoft Azure VM wizardSQL Server 2005 or greaterSQL Server 2014 or greater> 1 TBFastest and simplest method, use whenever possible to migrate to a new or existing SQL Server instance in an Azure virtual machinePerform on-premises backup using compression and manually copy the backup file into the Azure virtual machineSQL Server 2005 or greaterSQL Server 2005 or greaterAzure VM storage limitUse only when you cannot use the wizard, such as when the destination database version is less than SQL Server 2012 SP1 CU2 or the database backup size is larger than 1 TB (12.8 TB with SQL Server 2016)Perform a backup to URL and restore into the Azure virtual machine from the URLSQL Server 2012 SP1 CU2 or greaterSQL Server 2012 SP1 CU2 or greater> 1 TB (For SQL Server 2016, < 12.8 TB)Generally using?backup to URL?is equivalent in performance to using the wizard and not quite as easyDetach and then copy the data and log files to Azure blob storage and then attach to SQL Server in Azure virtual machine from URLSQL Server 2005 or greaterSQL Server 2014 or greaterAzure VM storage limitUse this method when you plan to?store these files using the Azure Blob storage service?and attach them to SQL Server running in an Azure VM, particularly with very large databasesConvert on-premises machine to Hyper-V VHDs, upload to Azure Blob storage, and then deploy a new virtual machine using uploaded VHDSQL Server 2005 or greaterSQL Server 2005 or greaterAzure VM storage limitUse when?bringing your own SQL Server license, when migrating a database that you will run on an older version of SQL Server, or when migrating system and user databases together as part of the migration of database dependent on other user databases and/or system databases.Ship hard drive using Windows Import/Export ServiceSQL Server 2005 or greaterSQL Server 2005 or greaterAzure VM storage limitUse the?Windows Import/Export Service?when manual copy method is too slow, such as with very large databasesCloseout MeetingAt the end of the assignment, there is a closeout meeting to finish the engagement. The closeout meeting is the final activity performed as part of the engagement. The findings for the engagement are presented to the customer, and the recommendations are delivered. It is also an opportunity to propose any following engagements that have been identified during this Offering. Topics related to the closeout meeting are:Meet and discuss:Results Closeout, finding, and recommendations presentationFindings related to original objectives and requirementsDiscussion of way to proceed (road map)Determine customer satisfactionClose engagementImportant Make sure you identify any possible follow on engagements and work with your Account Manager to transfer this information ReferencesWindows Azure Virtual Machine Readiness AssessmentThis assessment will help you with your move to Windows Azure Virtual Machines by inspecting your on-premises environment, and providing you with a check list and detailed report on steps you need to take to move your environment to the cloud. The tool works with both physical and virtualized environments: General Azure Virtual Machines (IaaS)Best Practices from Real Customers: Deploying to Windows Azure Infrastructure Services (IaaS) ?Building Your Lab, Dev, and Test Scenarios in Windows Azure Infrastructure Services (IaaS) ?Infrastructure Services on Windows Azure: Virtual Machines and Virtual Networks with Mark Russinovich Azure Internals and ConnectivityVirtual Network Overview Connect an On-premises Network to Azure via Site to Site VPN and Extend Active Directory onto an IaaS VM DC in Azure Hybrid Networking Offerings in Windows Azure VPN in Azure Virtual Networks SQL Server on Azure IaaSGetting Ready to Migrate to SQL Server in Windows Azure Virtual Machines your Virtual Machine Size: how to move your workload to Azure Virtual Machines: Database Workloads to the Cloud Platform for Hybrid Cloud TDM?White Paper Guidance for SQL Server in Windows Azure Virtual Machines Getting Started with SQL Server in Windows Azure Virtual Machines Application Patterns and Development Strategies for SQL Server in Windows Azure Virtual Machines Server in Windows Azure Virtual Machines (IAAS) ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- azure sql server hyperscale
- azure sql server timezone
- azure sql vs azure sql database
- azure sql server versions
- azure sql vs sql databases
- azure sql vs microsoft sql
- microsoft sql server query syntax
- install microsoft sql server 2016
- microsoft azure sql pricing
- azure sql server vm pricing
- sql server on linux
- sql server express on ubuntu