SQLStarters

Recipes for Cloud Database Experts

Categories

  • Why I know DBA role survives the public cloud.

    For the past 10 years or so, I’ve seen it occasionally come up in the discussions that DBA won’t be needed in the future. Originally, it started with the vendors claiming that their database systems are becoming self-tuning. Then the final nail in the coffin was to be the public cloud, which was also to…

    Read the full post…

    Posted by

    Mika Sutinen

  • Database Migration, Modernization, and R-strategies.

    Public cloud is a really great place to put your application and database workloads. However, it’s not always clear how, exactly, that should happen. Some people talk about migrating, others about modernizing, a few mix everything together, and then there is a bunch of words that all start with the letter R. In this post,…

    Read the full post…

    Posted by

    Mika Sutinen

  • AWS Purpose-Built Databases, Part 3 of 3.

    All good things must come to an end, including this 3 part blog post series. In this post, we’ll dive into one of the database systems I am not hugely familiar with, Apache Cassandra, and it’s AWS counterpart, Keyspaces. What is Cassandra, then? It’s an open-source distributed, wide column data store that is capable of…

    Read the full post…

    Posted by

    Mika Sutinen

  • 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

    Mika Sutinen

  • 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

    Mika Sutinen

  • 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

    Mika Sutinen

  • 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

    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