SQLStarters

Recipes for Cloud Database Experts

Categories

  • SQL Assessment API

    Every so often, Microsoft puts some extra into their SQL Server product, which doesn’t get as much time in the spotlight as it should. Nope, not talking about any of the great, new things that we got coming in with SQL Server 2022. Today’s post will be used to look at something called. SQL Assessment…

    Read the full post…

    Posted by

    Mika Sutinen

  • Nevergreen SQL Server deployments and mitigating patching pains

    Not too long ago, Microsoft released The Final Service Pack for any version of SQL Server, as a part of their move to a Modern Servicing Model. This (and the fall time here in Finland) got me again thinking about the benefits of running your database workloads on PaaS over self-managed VMs. And one of…

    Read the full post…

    Posted by

    Mika Sutinen

  • Running non-SQL Server database workloads in Azure

    I’ve written few (most of my) posts about running SQL Server, and very often about running it in Azure. While Azure is absolutely the best cloud platform for SQL Server, it is also an excellent platform for plenty of other database workloads. In short: “If it runs on a server or a virtual machine, you…

    Read the full post…

    Posted by

    Mika Sutinen

  • 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

    Mika Sutinen

  • 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

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