SQLStarters

Recipes for Cloud Database Experts

  • AWS Purpose-Built Databases, Part 2 of 3

    Continuing with the topic of purpose-built database on AWS. This time, I’ll be diving into the wonderful world of Document stores. For a while now, MongoDB has been the gold standard for Document databases. However, as of late, I have come to think AWS DocumentDB as a solid alternative for MongoDB as a document store. […]

    Read the full post…

    Posted by

  • AWS Purpose-Built Databases, Part 1 of 3

    I have been looking, for various reasons, to purpose-built database space recently. Purpose-built databases, as you can imagine, are databases that are specialized to provide just a single (well, in some cases it’s two) type of data store. Purpose-built databases are also great when you’re building modern, cloud native applications, which has led to the […]

    Read the full post…

    Posted by

  • Mitigating concerns for COTS application database migrations.

    I spend a lot of my working time and effort to move on-premises databases to the cloud. When I am not doing that, I am most often spending it planning on how to do it more efficiently. While I think today almost everyone agrees with the benefits of going to the cloud, there are a […]

    Read the full post…

    Posted by

  • Quick way to do security check for SQL Server database(s)

    I previously wrote about Azure Defender for SQL that brings some remarkable security capabilities to your cloud-based SQL Server estates. And while you can also get some of that goodness to your on-premises servers, sometimes you just don’t need all that comprehensive solution. Well, I have good news for you. There’s also a quick and […]

    Read the full post…

    Posted by

  • 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

  • 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

  • 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