-
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…
Posted by
-
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…
Posted by
-
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…
Posted by
-
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…
Posted by
-
School of Hard Knocks: SQL Server, Storage Spaces Direct and Cluster Shared Volumes edition
While I work 100% with cloud based SQL Server deployments these days, my life is not all unicorns and PaaS services. Surprisingly (or not) enough, many of the environments in the cloud are still build on top of good, trusty virtual machines. Except that sometimes they’re not good or trusty. There are definitely some good…
Posted by
-
Sometimes the VM in Azure is the best option for your SQL Server workloads
I have previously written quite a few post about how much I like the Platform-as-a-Service databases for SQL Server (and for databases in general), and I do like them quite a bit. But would I recommend them for all use cases and workloads? Heck no! At the moment there are some features and limitations in…
Posted by
-
Do you know how many different types of users there are in SQL Server?
The answer to this question is not 2, happy and unhappy users. This time we’re discussing security, not the end user experience of your perfectly tuned databases. I was recently having a discussion around SQL Server security, more specifically about the logins and user. The question I was asked after going through couple examples was,…
Posted by