The Scott Blog

Where I write fairly infrequently about things that interest me, usually related to Azure + AWS, SQL Server, PowerShell, and Power BI

Connect On

Azure Migration: Networking and Security for SQL Server on an Azure VM

by Scott Jackson | Apr 21, 2024 | DFW SQL Professional, Microsoft Azure, SQL Server

Networking and security are pivotal aspects of optimizing SQL Server on an Azure VM, and can be critical to the success of your cloud migration journey into Azure. In this comprehensive guide, we'll delve into essential strategies and best practices to ensure robust...

Azure Migration: Storage for Azure SQL Server VMs

by Scott Jackson | Feb 11, 2024 | DFW SQL Professional, Microsoft Azure, PowerShell, SQL Server

Storage configuration is critical to SQL Server performance on an Azure VM, or anywhere really. Any solid DBA will tell you SQL Server's performance is dependent on its storage; I'd even go further and say storage matters more than the CPU when it comes to SQL Server...

Optimizing SQL Server on Azure VM: Sizing Recommendations

by Scott Jackson | Jan 15, 2024 | DFW SQL Professional, Microsoft Azure, SQL Server

So you're a SQL Server DBA. And, it's Tuesday. But, it's not just any Tuesday. It's that magical Tuesday where you find out that you're responsible for a cloud migration: Your SQL Servers are moving to Azure, specifically to "SQL Server on Azure VM". (Not to be...

Lessons Learned: A Year of Azure (SQL) Migration

by Scott Jackson | Jan 1, 2024 | DFW Data Leader, DFW SQL Professional, DFW Technology Executive, Microsoft Azure, SQL Server

As we step into the new year, it's a good time to reflect on two things. First, some professional gratitude for my role, team, co-workers, and leaders at Premier Trailer Leasing. Best IT team in the trailer leasing industry, and really great people to work alongside....

Formalizing The Agile Journey: Certified ScrumMaster

by Scott Jackson | Oct 26, 2017 | DFW Data Leader, DFW ScrumMaster, DFW Technology Executive

I've spent most of my development time in either waterfall or agile - but, at least at the outset, it was unintentional. When I first set out to build a web application, I decided to simply do what was needed to deliver the best product I could - which meant,...

North Dallas SQL Developer Now Available!

by Scott Jackson | Sep 7, 2017 | DFW SQL Developer, DFW SQL Professional, SQL Server

Well, it's that time! I spent the first 15+ years of my career in the financial services sector, helping build a large law firm through my abilities in both technology and law. I built, scaled, and ran the firm's IT department, and personally developed what's become...

Who Is Scott?

Hey there! I’m Scott, and these days I’m stoked to be doing all the data things – now in the cloud (Azure + AWS, and I suppose GCP too, although who uses that?). I’m also really, really good at talking you, your neighbor, your kids, and the barista at your local Starbucks out of wanting to go to law school or become an attorney. This site was created as part of a previous job search, and exists today…well, because I paid for years of hosting up front. Sometimes I blog here, and most days I can be found getting after it in a pool somewhere, hoping to drop some time in my 200 IM.