-
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. […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
Posted by
SQLStarters
Recipes for Cloud Database Experts
Categories
- AWS (9)
- Azure (27)
- Blockchain (1)
- Career advice (4)
- Databases (31)
- DevOps (3)
- DMV (4)
- Failover Clustering (5)
- Ignite (1)
- Microsoft (13)
- PASS Summit 2013 (5)
- PASS Summit 2014 (2)
- PASS Summit 2015 (5)
- PASS Summit 2016 (1)
- PASS Summit 2017 (1)
- PerfMon (6)
- Performance Monitor (6)
- Performance troubleshooting (8)
- Security (15)
- SQL Server (65)
- SQL Server Administration (69)
- SQL Server DBA (64)
- SQL Server Service Packs (2)
- TCP Chimney Offload (1)
- Tools and Utilities (14)
- Uncategorized (12)
- Windows Administration (11)
- Windows Networking Features (7)
- Windows Server Management (16)
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