The Next Frontier Virtualization Hybrid Management and the

The Next Frontier Virtualization, Hybrid Management and the Cloud Kellyn Pot’Vin-Gorman Technical Intelligence Manager, Delphix

§ § • • Kellyn Pot’Vin-Gorman Technical Intelligence Manager for the Office of CTO, Delphix Multi-platform DBA, (Oracle, MSSQL, My. SQL, Sybase, Postgres…. . ) Oracle ACE Director, (Alumni) Oak Table Network APEX Women in Technology Award, CTA 2014 STEM education with Raspberry Pi and Python Liaison for Denver SQL Server User Group Rocky Mountain Oracle Training Days Conference Director and Board Director Author, blogger, (http: //dbakevlar. com)

What is Virtualization? Virtualization is the creation of a virtual (rather than actual) version of something, such as an operating system, a server, a storage device, database, files or network resources.

Virtualization Adoption Trend . Source: Gartner Forecasts

This trend will only increase in the next five years as cloud overtakes the industry

Source: Right Scale State of the Cloud 2016

The Future of Virtualization An overall trend in companies that includes autonomic computing, where the IT environment will be able to manage itself based on perceived activity, and resource shared computing, in which computer processing power is utilized and/or paid for only as needed. The usual goal of virtualization is to centralize administrative tasks while improving scalability and work loads.

Welcome to the New Skill Adoption List!

Why Move to the Cloud? Savings!! • Cost • Resource • Storage • Time Well, that depends on…. • Price per Gb • Complexity • SLAs and the biggest savings…. Virtualization

How Are Companies Migrating to the Cloud? 1. Just copy data and applications into the cloud… § Straightforward approach § Inefficient, non-incremental for large environments § Open-source “bbcp” uses encryption, compresses, and multi-threads § Archaic processes recommended by vendors 2. Start with backups to Iaa. S storage, then populate re-hosted applications by restoring from those backups § Cloud backups are easy, known technology

Backups cloud service: from on-premises to the Cloud Storage Database server

Backups cloud service: from on-premises to the Cloud, then restore- Assumption Database server e l p m i S Cloud Storage Database server

Migration Complete…Not so Much… Even if only development or test has been migrated to the cloud… Data is migrated, but this doesn’t count for ongoing data loads, application connectivity across the network. To refresh will take considerable time to perform. Rarely a consideration for the difference in cost structure for processing large amounts of data from on-premise to the cloud.

How Microsoft Sees a Migration to Azure How much hardware do I need? ? https: //blogs. msdn. microsoft. com/brunoterkaly/2013/09/26/how-to-migrate-an-on-premises-sql-server-2012 -database-to-windows-azure-sql-database/

“Simple” Database Migration • Database must be MSSQL 2005 or higher, (easy) • Ensure that the database is compatible with Azure SQL DB, (correct any incompatible functions, etc. ) • Must have identified all performance issues that will be impacted beforehand. • Ensure there is little physical distance between cloud data center and bacpac files to be used for migration. • Disable management jobs that will hinder migration processing. • Drop any objects or historical data that can impact migration time and can be performed post migration. https: //docs. microsoft. com/en-us/azure/sql-database-cloud-migrate

If IIS and Using the Azure Cloud Migration Asst. • Performs assessment of IIS environment and creates report of what can be migrated. • Creates report to document what will require moving and any issues identified. • Creates any websites and associated databases in preparation for the migration. • If non-compatible products are in use, (which is in case of 90% of environments) then those must be addressed manually. • The tool is free to start, but will cost as project proceeds in duration. https: //azure. microsoft. com/en-us/downloads/migration-assistant/? &wt. mc_id=AID 559320_SEM_14 UHpl. Sj&gclid=CJWky 8 v. B 6 t. ICFd. G 2 w. Aod 0 SEJq. Q

Cost Estimates for Cloud Vendors - Azure Storage Capacity LRS ZRS First 1 TB / Month $0. 024 per GB Next 49 TB (1 to 50 TB) / Month Next 450 TB (50 to 500 TB) / Month Next 500 TB (500 to 1, 000 TB) / Month $0. 03 per GB $0. 0236 per GB $0. 0232 per GB $0. 0228 per GB $0. 0295 per GB $0. 029 per GB $0. 0285 per GB https: //azure. microsoft. com/en-us/pricing/details/storage/blobs/

Migrating from on-premise to Iaa. S § Much Improved Option 1. Data virtualization § Easy, secure, revolutionary § Optimized for faster agile development and testing § Optimized for new costing structures in Iaa. S

Example Environment- 1 TB

Data Virtualization: From Prod to Virtual d n a d d e s t e a r c i p l p m u o d C e. D MB ups ck Ba Source Environment r. S ove Validated Sync Environment SCSI/SSL

Data Virtualization: From Prod to Virtual MB Source Environment SCSI/SSL ups ck Ba r. S ove Validated Sync Environment S Any Storage I/S CS SL Create as many VDBs as needed!

Data Virtualization: Space Savings 10 1 TB? TB Validated Sync Target Delphix Virtualization Engine Dozen Virtual Database Copies, (VDBs)

Data Virtualization: How is it possible? s i e g a r o s t k S c y o l l n B O n e t t i r W Delphix Virtualization Engine Any Storage Virtual Database

Data Virtualization: on-premise Environment Delphix Virtualization Engine Backups via SMB Source DB server SQL Server 2008 -2016 1 TB 2 TB storage SCCI/SSL Target DB server SQL Server 1008 -2016 No database storage

Data virtualization: from on-premises into the Cloud Delphix Virtualization Engine 2 TB storage Source DB server SQL Server 2008 -2016 2 TB storage Target DB server SQL Server 2008 -2016 No database storage

Secondary Considerations § For Non-Production Systems… § Change the way you’ve always performed tasks. § Performing common tasks the same way as previously might end up costing more. § Secure Data § All Iaa. S alternatives promote encryption for data in-flight and for data at-rest, but encryption may not be the right answer…

How does data virtualization enhance the Cloud experience? § Optimized for the cloud in the first place… 1. Different cost structures § Much smaller storage footprint, much less data-transfer = $$$$

Different cost structures § Traditional copy data management techniques § Developed without concerns about infrastructure chargeback § This corresponds to higher cost. § Iaa. S vendors monitor storage and data transfers § Help meet SLAs, garner profits § It’s not just the data that exists in the end, so transformations can equal big money for cloud vendors.

Data virtualization minimizes… Storage costs Thin-provisioning storage avoidance Data transfer costs Far less data transferred during provisioning/refresh operations • As opposed to the volume of data transferred using traditional cloning techniques Network-attached storage data transfers offset somewhat • Most non-production usage modifies or accesses only a tiny proportion of the total database during lifetime

Cloud and Performance KNOW THY ENEMY… • Tune SQL and Apps to perform efficiently as possible- natural life of database is growth, (in processes, resources, etc. ) before migrating. • The less network latency, the better- network tracing to eliminate database blame is important. • Many of the same tools and data provides value- DMVs provide data internally to SQL Server. • Look at management tools such as Cloudmonix, (formerly Azure. Watch) App. Dynamics, Dynatrace, Zabbix or Logic Monitor.

Confidential data § All Iaa. S solutions provide encryption in-flight and encryption at-rest § But encryption doesn’t protect data as much as it needs to be. § Europe already requires data masking, not just data encryption for any confindential data: § http: //ec. europa. eu/justice/data-protection/article 29/documentation/opinionrecommendation/files/2014/wp 216_en. pdf

Confidential data § • § Encryption is reversible data obfuscation, which is very different from masking data. Data masking is non-reversible. § It solves the issue at the data level. Is authentication and authorization in non-production in compliance with security goals? § All organizations will soon need to review if critical data in nonproduction environments be accessible to developers, testers and users.

Why Masking is Important§ § § Masking personally-identifiable, (PII, HIPPA, PCI, etc. ) information renders it useless from a security standpoint Resolves both the technical and personal responsibility issue. The data can be masked before it moves to non-production, removing unnecessary risk.

Confidential data Exposure Production Non. Production

Confidential data Exposure Solution Production Encryption Non. Production Masking

Data virtualization: transformation by masking Delphix Virtualization Engine 2 TB storage SQL Server Target No database storage SQL Server Validated Sync Environment Delphix Masking Engine

Data virtualization: transformation by masking, then replicating to Iaa. S Delphix Virtualization Engine 2 TB storage Delphix Virtualization Engine 2 TB storage SQL Server Validated Sync Environment SQL Server Target Storage Only for Masked Data Delphix Masking Engine SQL Server Target Storage Only for Masked Data

Selective replication of virtual databases and files § Delphix appliances include replication § For data protection, for scalability, and for migration § Virtualized data is already compressed at-rest, further compressed and encrypted in-flight, incrementally replicated to another engine

Data virtualization + transformations = complete solution § Once data has been virtualized on-premises… § It’s transformed cross-platform on-premises. . . § It’s transformed by securely masking on-premises. . . § Then. . . § securely virtualized data can be safely replicated to Iaa. S

Data virtualization: transforming cross-platform, then masking, then replicating to Iaa. S Delphix Virtualization Engine 4 TB storage SQL Server Target SQL Server Validated Sync Environment Storage Only for Masked Data SQL Server Target Storage Only for Masked Data Delphix Masking Engine

Summary: Solutions for Cloud Migrations using Virtualization • • Watch for Chargebacks § Data virtualization minimizes storage and data transfer and transformation costs. Confidential Data § Data masking integrated with data virtualization truly secures PCI, PII, HIPPA and other confidential data.

Want to try it out, download the Delphix AWS Trial is Available for Oracle, MSSQL Soon! https: //www. delphix. com/products/free-trial-request Twittter: @DBAKevlar Linked in: http: //linkedin. com/in/kellynpotvin Blog: http: //dbakevlar. com

Thank You Sponsors Platinum Gold Silver Bronze Swag 43 | 3/25/2017