Migrating Your SQL Server to the Cloud

The Clearly Podcast

11-12-2023 • 34 mins

In this podcast, the consultants discuss the topic of migrating SQL Server to the cloud. They highlight the benefits of cloud migration, such as cost savings and technological advancements, and note that cloud skills are becoming essential in the job market.

Despite the prevalence of cloud migration, many organizations still use on-prem SQL, including older versions that are becoming unsupported. The consultants emphasize the need for planning, especially with SQL 2019 soon falling out of mainstream support.

They outline various migration options:

  1. Moving the entire database.
  2. Moving subsets of data using tools like Azure Data Factory.

They also mention tools to assist in migration, such as Azure Migrate, Azure Data Studio, Backpack files, Bulk Copy, and Data Factory. While transactional replication offers minimal downtime, it is complex and requires skilled DBAs.

The discussion touches on scenarios where organizations might choose not to migrate to the cloud, such as having managed data centers, legacy applications, high-security needs, or limited connectivity.

The consensus is that cloud migration is inevitable for most organizations over the next decade, except for specific edge cases. Hybrid models are effective, particularly as transitional steps, but will likely shift fully to the cloud over time.

The podcast concludes with a note on the importance of assessment tools for migration and a preview of the next episode on "What is a Lake House?". The consultants offer their assistance with migration projects and ongoing maintenance of SQL servers.

You can download Power BI Desktop from here.

If you already use Power BI, or are considering it, we strongly recommend you join your local Power BI user group here.

To find out more about our services and the help we can offer, contact us at one of the websites below:
UK and Europe: https://www.clearlycloudy.co.uk/
North America: https://clearlysolutions.net/










You Might Like

Darknet Diaries
Darknet Diaries
Jack Rhysider
Double Tap
Double Tap
Accessible Media Inc.
TechStuff
TechStuff
iHeartPodcasts
Waveform: The MKBHD Podcast
Waveform: The MKBHD Podcast
Vox Media Podcast Network
Fortnite Emotes
Fortnite Emotes
Lawrence Hopkinson
Acquired
Acquired
Ben Gilbert and David Rosenthal
Hard Fork
Hard Fork
The New York Times
Talkin' Shop
Talkin' Shop
Eclipse Automotive Technology
The Vergecast
The Vergecast
The Verge
RNIB Tech Talk
RNIB Tech Talk
RNIB Connect Radio
Smashing Security
Smashing Security
Graham Cluley & Carole Theriault