RetiredDBA.com

RetiredDBA.com provides tidbits, ideas and insights to all things Microsoft SQL Server.

Home / Cloud / Hey DBAs… is your head in the cloud?

Hey DBAs… is your head in the cloud?

/
/
/



This is a webinar review: 5 Critical Considerations When Migrating Data to the Cloud by Kevin Kline, Mike Wood, Brian Knight. Kevin Kline is a Principal Program Manager at SentryOne. Mike Wood ia a Lead Cloud Engineer at SentryOne. Brian Knight is the founder of Pragmatic Works.

Kline, Wood and Knight discussed high level points to consider when migrating SQL Server data to the cloud. As with most migrations there are many ways and tools to assist in a migration. Moving SQL Server data and applications to the cloud has multiple options too.

  • It’s importance to review and cleanser your SQL Server data before a major migration
    • Dump the garbage SQL Server data for leaner, cleaner and faster performance.
    • Think about any special compliance requirements such as HIPPA, PCI, PII, GDPR, etc.
    • Good time to check T-SQL stored procs and other SQL Server artifacts for clean and optimized code.
  • Fully document your SQL Server data sources and metadata
    • Consider Data lineage origins and where SQL Server data moves over time.
  • Choose different tools and techniques to actually move SQL Server data
    • Backup / restore
    • Import / export
    • Replication
    • Amount of acceptable downtime will determine best solution<./li>
  • How to test SQL Server data for fidelity
    • Make sure to test for month end, year end, special one-time processes.
  • How to maintain parallel systems during transition
    • Cloud version of SSIS is a useful tool.
    • Queue based data writes allows local and cloud systems data syncs.
  • Summary
    • Some processes are slightly different in the cloud, but many are similar processes.
    • Azure has a hybrid option that AWS and Google does not have.
    • SQL Server in the cloud is gonna happen! Right?

Many other tips and tricks on cloud computing and performance are discussed during the webinar. E.g. You do not want your app and data in different data centers or you will incur additional costs. Thumbs up for this webinar on ‘5 Critical Considerations When Migrating Data to the Cloud’ by Kevin Kline, Mike Wood, Brian Knight.

Notes:
HIPPA – Health Insurance Portability and Accountability Act
PCI – Purchase card inititive compliance
PII – Personal Identifiable information
GDPR – Euro regulations for PII

So DBAs… your head is in the cloud now. Right?


Ad

Whizlabs – 165 Practice Questions for Microsoft Azure Exam AZ 400 | Buy Now

Edureka – DevOps Training by Edureka Gain expertise in various Devops processes and tools like Puppet, Jenkins, Nagios, GIT for automating multiple steps in SDLC, Ansible, SaltStack, Chef. Know More!

Whizlabs – Practice Tests for Exam AZ-400: Microsoft Azure DevOps Solutions

Whizlabs – Online Training for Agile Certified Practitioner (PMI ACP)® Certification Exam | Enroll Now

Edureka – Data Science Training by Edureka Drive Business Insights from Massive Data Sets Utilizing the Power of R Programming, Hadoop, and Machine Learning.

Ed2Go –Intermediate SQL – By the end of this course, you’ll be able to use a wide range of advanced SQL techniques with confidence.


This div height required for enabling the sticky sidebar

Advertisers



Programmer Solutions Inc Websites

BUSINESS
CITY JOB RESOURCES
MIDWEST JOB RESOURCES
SOUTH JOB RESOURCES
WEST JOB RESOURCES
Industrial Supply DealsChicago Job ResourceKansas Job ResourceAlabama Job ResourceAlaska Job Resource
Office Supply DealsWashington, DC Job ResourceIllinois Job ResourceArkansas Job ResourceArizona Job Resource
EDUCATION
SPECIAL JOB RESOURCES
Indiana Job ResourceDelaware Job ResourceCalifornia Job Resource
Back To School MallDiversity Job ResourceIowa Job ResourceFlorida Job ResourceColorado Job Resource
SHOPPING
First Job ResourceMichigan Job ResourceGeorgia Job ResourceHawaii Job Resource
Health Care and FitnessFreelance Job ResourceMinnesota Job ResourceKentucky Job ResourceIdaho Job Resource
Just Best GiftsIntern Job ResourceMissouri Job ResourceLouisiana Job ResourceMontana Job Resource
Just Clearance SalesSeasonal Job ResourceNebraska Job ResourceMaryland Job ResourceNevada Job Resource
Just Comparison ShoppingSenior Job ResourceNorth Dakota Job ResourceMississippi Job ResourceNew Mexico Job Resource
Just OutletsVolunteer Job ResourceOhio Job ResourceNorth Carolina Job ResourceOregon Job Resource
Luxury Matters
TARGETED JOB RESOURCES
South Dakota Job ResourceOklahoma Job ResourceUtah Job Resource
Tradin StuffBlue Collar Job ResourceWisconsin Job ResourceSouth Carolina Job ResourceWashington Job Resource
Value BuyersExecutive Job Resource
NORTHEAST JOB RESOURCES
Tennessee Job ResourceWyoming Job Resource
TECHNOLOGY
Finance Job ResourceConnecticut Job ResourceTexas Job Resource 
FrontPage HelpHealthcare Job ResourceMaine Job ResourceVirginia Job Resource 
MCDBA DirectoryIT Job ResourceMassachusetts Job ResourceWest Virginia Job Resource 
Retired DBAPink Collar Job ResourceNew Hampshire Job Resource  
SQL Server DirectorySports Job ResourceNew Jersey Job Resource  
Transact SQL DirectoryWhite Collar Job ResourceNew York Job Resource  
  Pennsylvania Job Resource  
  Rhode Island Job Resource  
  Vermont Job Resource