SQLStarters

Recipes for Cloud Database Experts

  • Officially the best Azure VM for SQL Server

    I was just recently going through my backlog of podcasts and came across Data Exposed episode with Microsoft’s Pam Lahoud (@SQLGoddess on Twitter) about SQL Server VMs in Azure. Now, we have it from the official sources that one of the best VM sizes for SQL Server workloads is the Edsv4-series. Incidentally, this is also […]

    Read the full post…

    Posted by

  • Azure Defender for SQL

    It’s always a great time to write about security, so let’s go with this topic today. One of the main reasons I love public cloud is, that beyond nice offering for databases, they also provide great features around security. One of these features, and the topic of this post, is Azure Defender for SQL. While […]

    Read the full post…

    Posted by

  • Azure SQL Managed Instance Storage Performance

    Let’s continue with the storage performance topic a bit further. One thing that sometimes can be confusing is the storage performance with SQL Server Managed Instances. The reason for confusion comes from having two separate performance tiers (General Purpose and Business Critical), with different method of managing the IO performance. In General Purpose the method […]

    Read the full post…

    Posted by

  • The need for (storage) speed and the Cloud

    In a past couple months I’ve seen this happen in a couple of different customers, so I thought I’d write a short post about the topic. While it’s easy to think that running SQL Server workloads on cloud VM’s is the same as running them on VM’s in an on-premises environment, this is typically not […]

    Read the full post…

    Posted by

  • SQL Server Managed Instance and the most unhelpful error message during a database restore

    I am a huge fan of managed database services, no matter which cloud platform they’re running on. The simple reason is that I am not a huge fan of managing the automation for the basic things like backups, patching and high availability myself anymore. There is a trade-off though when you’re using someone else’s automation […]

    Read the full post…

    Posted by

  • Database restore performance oddities of SQL Server RDS

    One of the things I’ve learned over the years is, that sometimes the performance in cloud platforms can be unpredictable and you always need to expect the unexpected. Most of the times these issues are just minor annoyances, but they can certainly be confusing the first time you run into any of them. A while […]

    Read the full post…

    Posted by

  • Comparing SQL Server deployment options between Azure and AWS

    Lately I’ve been spending lot of time outside my natural habitat, Azure, and I’ve entered the AWS frontier. Because of this I decided to write down some of my experiences about how the SQL Server deployments between these two cloud platforms compare to each other. AWS has been around longer than Azure by few years […]

    Read the full post…

    Posted by