SQLStarters

Recipes for Cloud Database Experts

Categories

  • 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

    Mika Sutinen

  • 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

    Mika Sutinen

  • 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

    Mika Sutinen

  • 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

    Mika Sutinen

  • 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

    Mika Sutinen

  • 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

    Mika Sutinen

  • Mysteriously exploding Failover Clusters and Azure Host Maintenance

    Not too long ago in the past I had really interesting afternoon. It wasn’t interesting because I had 3 Failover Clusters that exploded, that’s just horrible, it was interesting because they exploded exactly 40 minutes apart. While I do believe in coincidences, that was just way too precise to be a random occurrence. After looking…

    Read the full post…

    Posted by

    Mika Sutinen

Find me in social media

Search by tag

#automation #azure #azurevm #db2 #opensourcedb #oracle #sqlserver AWS Azure Azure Cloud VM Backups Cluster Validation Database Design Dynamic Management Views IaaS IPSEC Managed Instances Monitoring NETSH PerfMon Powershell Query Tuning SQL Database SQL PASS sqlserver SQL Server SSL T-SQL Testing