Episode 278
| July 30, 2024
| 64 minutes
Running SQL Server on Azure VMs
With over 10 different SQL Server services now offered in Microsoft Azure, it can be difficult to know how you want to run your environment. Sometimes, the old ways are the best ways for an organization, and running SQL Server on a VM in Azure is the right fit.
In this episode of the SQL Data Partners Podcast, we chat with Anders Pedersen about his experience moving their systems to Azure VMs. We discuss some of the tiering issues, the newest storage tier being rolled out, and how he manages upgrades.
Join us for another insightful podcast where a seasoned database administrator shares their experience of managing a SQL Server environment.
Let us know what you think! Did you get any good take-aways from today's podcast or have some questions? Leave us a comment and some love ❤️ on LinkedIn, X, Facebook, or Instagram. Thank you for listening!
Our Guest
Anders Pedersen
50-ish years old, born and raised in Norway, with detours to Spain, Greece and the US. Went to college in the US and forgot to leave. US citizen since 2002.
Been a SQL Server DBA since 1995, versions 6-2022 inclusive. Although I was certified in 2012 for 10 years before I actually used it, and then just to get it upgraded to SQL 2019. Done both contract work and permanent employee, but mostly permanent. Mostly a core SQL server DBA, that also dabbles in SSIS, SSRS, and other fun things. Oh and Cursors are your friend!
Gaming when not DBAing. Avid EverQuest player for 25+ years. Currently enjoying slow life in coastal North Carolina.
You grab your d20 and you roll it, and if it's odd numbers, you do 4 cores, and if it’s even, you do 8. Sometimes people try to be scientific, and sometimes...play horseshoes.
Meet the Hosts
Carlos Chacon
With more than 10 years of working with SQL Server, Carlos helps businesses ensure their SQL Server environments meet their users’ expectations. He can provide insights on performance, migrations, and disaster recovery. He is also active in the SQL Server community and regularly speaks at user group meetings and conferences. He helps support the free database monitoring tool found at databasehealth.com and provides training through SQL Trail events.
Eugene Meidinger
Eugene works as an independent BI consultant and Pluralsight author, specializing in Power BI and the Azure Data Platform. He has been working with data for over 8 years and speaks regularly at user groups and conferences. He also helps run the GroupBy online conference.
Kevin Feasel
Kevin is a Microsoft Data Platform MVP and proprietor of Catallaxy Services, LLC, where he specializes in T-SQL development, machine learning, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL, president of the Triangle Area SQL Server Users Group, and author of the books PolyBase Revealed (Apress, 2020) and Finding Ghosts in Your Data: Anomaly Detection Techniques with Examples in Python (Apress, 2022). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.
Want to Submit Some Feedback?
Did we miss something or not quite get it right? Want to be a guest or suggest a guest/topic for the podcast?